Shopify CSV import error
“Illegal quoting on line … / Missing or stray quote on line …”: what it means and how to fix it
Why it happens
- Curly quotes (“ ”) that Excel or Word inserted instead of straight quotes (").
- A quote mark inside a cell that isn't doubled, such as 12" pizza tray.
- A description pasted in with line breaks and quotes.
- The file isn't saved as UTF-8, so accented letters break it.
How to fix it
- Open the file in a plain text editor, go to the line in the message and look for a quote that isn't closed.
- Replace curly quotes with straight ones, and double any quote inside a cell (12"" pizza tray).
- Save the file as CSV UTF-8. In Excel, choose “CSV UTF-8 (Comma delimited)”.
- Import again.
How Bulkvane handles it
Bulkvane reads CSV files as UTF-8 and tells you which row has a broken quote: “Row 8 has a quote (") that is never closed. Check that cell and save the file again.” Importing the Excel (.xlsx) file directly avoids CSV quoting problems altogether.
Every file is checked before anything changes, with problems named by row in plain words, and any import can be undone for 30 days. All of Bulkvane's messages are in Errors A–Z.
Questions
Why does my CSV show strange characters like é?
The file was read with the wrong encoding. Save it again as UTF-8 and re-open it.
Does Bulkvane accept Excel files?
Yes. Bulkvane imports .xlsx files directly, so you don't need to save as CSV first.
Message, cause and fix from the Shopify Help Center: common product CSV import issues, checked . Still stuck? See Shopify CSV import not working? or ask us.
Preview every change.Undo any import for 30 days.
Install free