Knowledge Base

User reported that the Complete_Averages.csv export from FaceReader Online was misaligned: episode names were scattered across rows instead of staying in the episode column. They needed a corrected data file for their project.

Resolution – The misalignment occurs when episode names contain commas or hidden line breaks, which break the CSV structure. The recommended fix is to rename episodes using only letters, numbers, underscores or dashes (no commas or returns), then export the results again as an Excel file. The Excel export keeps the data aligned. If a CSV is still required, open the clean Excel file and save it as CSV or change your system’s list separator before exporting.

FAQ and Step-by-Step Instructions

Why is my FaceReader Online CSV export misaligned?

• The Complete_Averages.csv file can become misaligned when episode names include commas or hidden line breaks. CSV files use commas to separate columns, so commas inside a name cause the episode label to shift into the next column. Hidden line breaks can push data into a new row.

How can I fix the misaligned export data?

• In FaceReader Online, locate the episodes that have commas (,) or line breaks in their names.
• Rename each episode to use only letters, numbers, underscores (_) or dashes (-). Avoid punctuation and returns.
• After renaming, export your results as an Excel file (.xlsx) instead of CSV. The Excel format preserves the columns and keeps episode names in the correct column.
• Open the Excel file to verify the data is aligned correctly.
• If you still need a CSV, use Excel’s Save As function to save the clean file as .csv. Alternatively, change your system’s list separator to a different character (e.g., semicolon) before exporting to CSV again.

How do I rename episodes in FaceReader Online?

• Log in to FaceReader Online and open the project containing your episodes.
• Navigate to the episode list or timeline where episode names are defined.
• Click on each episode name and edit the text. Remove any commas, line breaks or special characters. Replace spaces with underscores if needed.
• Save your changes before exporting.

What if I still encounter issues after renaming and exporting?

• Make sure there are no hidden characters in the episode names. You can copy the names into a plain text editor to check.
• Double‑check that you exported the results as Excel first and verified the alignment.
• If problems persist, contact Noldus support with a sample of your data for further assistance.