"There was an error importing your CSV file" — here's what's actually wrong

How our tool fixes this automatically

Rather than hunting through the file yourself, upload it to our free Shopify product converter. It checks every one of the common causes mechanically — the invisible byte-order mark at the start, the delimiter (comma vs. semicolon vs. tab), the encoding, and whether your column names match Shopify's required header names. Anything it can fix safely, it fixes and lists in plain language so you can see exactly what changed. Anything that needs your attention — like a column name it doesn't recognize — it flags separately so you know what to look at.

You get back a clean file that's ready to upload to Shopify. Your original is never touched.

The fastest way to find which problem you have yourself

If you built your file in Excel or Google Sheets, start by opening the raw file in a plain text editor (Notepad on Windows, TextEdit on Mac in plain-text mode). Look at the very first line. You should see clean column names separated by commas, starting with Handle. If you see semicolons, strange symbols at the beginning, or column names that look slightly off — you've found the problem.

If the file looks fine in a text editor, the next thing to check is whether your column names match Shopify's template exactly. Shopify publishes a sample template in its admin. Download a fresh copy and compare your first row to it, character by character.

Why Shopify stops before reading a single product

When Shopify says "There was an error importing your CSV file," it's hitting a problem before it can parse anything — the file itself is unreadable as far as Shopify is concerned. The three most common culprits:

Your file was opened and saved in Excel. Excel has a habit of silently changing the file in ways that break Shopify. The biggest one: on some computer settings, Excel saves CSV files using semicolons to separate columns instead of commas. Shopify expects commas. The file looks fine in Excel but Shopify can't make sense of it.

There's an invisible character at the start of the file. Excel sometimes adds something called a byte-order mark — a special invisible code — at the very beginning of the file when it saves. You can't see it, it doesn't show up in any column, and it silently breaks the import. Shopify sees garbage instead of your first column header.

The column headers don't match what Shopify expects. Shopify's import is case-sensitive and exact. If the first row of your file says title instead of Title, or variant price instead of Variant Price, Shopify may refuse the file entirely rather than trying to figure it out.

What if fixing the format doesn't work?

A small number of "error importing" cases come from the file being too large (Shopify has a 15 MB limit), or from the file not being a CSV at all — for example, if you uploaded an actual .xlsx file directly instead of exporting it to CSV first. In either case, Shopify gives the same unhelpful error message. Our tool accepts both .xlsx and .csv formats and converts to a clean Shopify-ready CSV either way.

Seeing a different error message? Try Line is invalid (no explanation) or go back to the main Shopify import converter to start fresh.