Any importer

“The import preview is blank”

The importer accepts the file, opens the preview, and shows nothing. Because the file was accepted, the natural conclusion is that the data is bad — but a blank preview far more often means the reader found no rows it recognised, which is a different problem with a different fix.

Symptoms

  • The file is accepted but the preview table is empty
  • A row count of zero is shown alongside a file that is clearly not empty
  • The same file previews fine in a spreadsheet

What actually causes it

Cause 1

The header row was not where it was expected

Exports that begin with account name, address and date-range lines push the real header down. The importer reads the first line as column names, finds nothing it recognises, and treats everything else as unusable.

Cause 2

The delimiter was not detected

A semicolon-delimited file read as comma-delimited collapses into one column per row. There is technically data, but no field the preview can put in a column.

Cause 3

A blank line stopped the reader

Several importers stop at the first empty line. If your export has one directly under the header, the preview is empty while the file is full.

How to fix it

  1. Drop the file into the checker below: it reports the delimiter, the column count and any blank rows, which identifies all three causes at once.
  2. Delete preamble rows so the header is the very first line of the file.
  3. Let the checker convert semicolon delimiters and strip blank rows, then download and retry.
  4. If the preview is still empty, the file genuinely has no data rows — re-export with a wider date range.

Skip the manual edit — fix it automatically

The checker distinguishes "no rows in the file" from "the reader could not find the rows", which the preview screen never does. Free, no signup, no upload.

Open the fixer

Your file never leaves your browser.