Empty cells in your product CSV: why and how to fix

A product CSV sometimes has cells that should hold a value but are empty. Empty cells can cause rows to be skipped, prices to be missing, or products to show incomplete details after an import. The file often looks fine at a glance, so it helps to know what to look for.

1. A required column was left blank. A product row has no title, price, or SKU because the value was never entered or was cleared by mistake. Sort each key column so the blanks group together, then count them.

2. The separator count is off. One row has an extra or missing separator, so every value after it shifts one column to the left or right. This leaves an empty cell at the end of the row and a value in the wrong column. Compare the number of separators in the bad row with the number in a good row.

3. A line break inside a text field splits one product into two rows. A line break inside quotes is valid CSV, but a program that does not handle it reads the rest of the text as a new row. That new row then has most of its cells empty. In the synthetic example below, such a program sees a second row holding only the rest of the description (the words in blue and the closing quote mark), with empty sku, title and price cells. The fix is to keep the whole description on one line; the empty cells then disappear because there is one row again.

4. A cell looks empty but is not. It may hold only spaces, or a placeholder such as a dash or "N/A". It can pass a quick visual check but still count as a missing value.

Everything outside these four items is not verified in this text; check it by hand.

Fix on a copy. Save a copy of the file and work only on the copy; keep the original untouched. Find the empty cells by sorting or filtering each key column to bring blanks to the top. For each one, decide which of the four reasons applies. Correct it: fill the missing value, repair the separator, join the split line, or clear the space or placeholder. Write down each change in a short list (row, column, old value, new value) so you can undo any of them.

Recheck. On the corrected copy, run the free CSV check again first, then look by hand at anything it does not cover. Compare the row count of the copy with the original; it should match unless you intentionally merged split rows, as in the third reason. When the copy looks right, you can try uploading it. The import result on your side is the final word, so read any messages it shows and fix what they point to.

If you would like a second look at the corrected copy, the free CSV check is offered on our site as a simple first step.