Articles on: Frequently Asked Questions (FAQ)

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


  1. 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 1 for the first column and 2 for the second.
  2. 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.
  3. 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.
  4. 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


Updated on: 13/11/2026

Was this article helpful?

Share your feedback

Cancel

Thank you!