HubSpot import error: “Make sure each column with data has a header”
Why HubSpot rejects your contacts file with this message, and how to fix it in a few minutes.
Fastest fix
Upload the file and see exactly which rows cause the problem. Free, and the file stays in your browser.
Check my file for HubSpot →Why this happens
- A column has values but an empty first-row cell (often a stray value far to the right).
- The header row is not the first row — there is a title or blank row above it.
- Merged header cells from Excel leave some columns without a name.
How to fix it
- Make sure row 1 contains only column names, with nothing above it.
- Give every column with data a name, or delete columns you don't need.
- Delete empty-looking columns on the right side — they may contain spaces.
- Unmerge header cells and save again as CSV (UTF-8).
Still stuck? Ask SheetFix Support