How to Format Your CSV File Correctly for Importing/Updating
Use this guide to prepare a CSV file so it imports and updates without errors in Stock Sync. It covers column headers, hidden characters, Excel formatting, and line breaks.
How to Format Your CSV File for Importing or Updating
- Map by column index when there are no headers: If your CSV file has no headers, or the headers are unreadable, map fields using column index numbers. For example, use
1for the first column and2for the second. - Remove hidden characters from headers: Some CSV files include hidden BOM characters, such as
, at the start of the first header. These prevent Stock Sync from recognizing the column name. Map that column by its index instead of its header text. - Keep identifiers as text in Excel: Excel can convert long numbers such as ISBNs, EANs, barcodes, and SKUs into scientific notation or cut off digits, which creates incorrect or duplicate identifiers. Format identifier columns as Text before saving, or edit the file in a plain-text editor such as Notepad or VS Code.
- Use consistent line breaks: Inconsistent line breaks can cause the error "Incorrect row separator." Make sure the file uses one consistent row separator, typically a line break (
\n).
Troubleshooting Steps
- Issue: Columns are not recognized, or the first header shows strange symbols such as
→ Solution: Map the column by its index number instead of its header name. - Issue: SKUs or barcodes look incorrect or duplicated → Solution: Format identifier columns as Text in Excel, or edit the file in a plain-text editor.
- Issue: "Incorrect row separator" error → Solution: Save the file with one consistent line break style, typically
\n.
Good Articles to Continue
- I am having trouble mapping my source file columns. What are the column headers/index? → Explains how column headers and indexes work in Matching Column.
- How do I correctly map fields in my product feed? → Covers mapping fields in Step 2 and checking headers against the feed file.
- How do I ensure my CSV file matches the required feed settings? → Covers delimiters, hidden characters, and required column names.
Updated on: 13/11/2026
Thank you!
