SPREADSHEET GUIDE

What to do when an Excel header is not in the first row

Reports often begin with a title, date range, or blank rows. Treating row one as the header can turn the real column names into ordinary data.

Reviewed by FoldSuite · July 31, 2026

Find the real header row

Look for the first dense row of unique text labels. It usually sits immediately above the first data record.

Remove merged title cells

Merged cells in report titles are useful for presentation but unreliable for data processing. Keep them outside the table range.

Verify every file

Monthly exports can move the header row. Detect it per file instead of assuming one fixed row number.

FIX IT IN YOUR BROWSER

Use the file on your device. Nothing gets uploaded.

Load a sample or choose your own files, confirm the result, and download a clean workbook.

Open the free tool