Research Guides
Find the Real Header in a Research CSV
Some research CSVs begin with a report name or coverage note before the column names. If an import treats that first record as the header, the rest of the file can land under the wrong column labels. Verify which record starts the table before citing any value.
Separate report notes, column names, and data
In this fictional traffic export, the first record describes the edition, the second names the columns, and the third is the first observation:
"November report, desktop only"
page,date,visits
/pricing,2026-11-01,42
Record the first line as context: the 42 visits cover desktop traffic in this example. Do not treat it as a column name, and do not drop the note from your research record when you skip it in the import. Write down the name of the raw file and keep it unchanged.
Configure the parser instead of opening and resaving the file
The W3C vocabulary for tabular metadata distinguishes the number of rows to skip before the table from the number of header rows. For this example, a compatible dialect configuration would set skipRows to 1 and headerRowCount to 1. An import tool may call these settings something else or not support them. Use a CSV-aware parser rather than stripping physical lines blindly: a quoted value can include a line break. See Count Research CSV Records, Not Text Lines.
Check one row before relying on the totals
Confirm that the imported columns are exactly page, date, and visits. Then check that /pricing, 2026-11-01, and 42 occupy those three columns in the first data row. If a later export drops the coverage line or adds another one, stop rather than quietly skipping the same number of rows. A correct row count can still hide shifted labels.
Copy this import check
Source file and edition | notes preserved | rows skipped | header rows | expected columns | first data row checked | import decision
Attach the original file or its publication URL and the import settings to the claim. That lets another researcher reproduce both the 42 and the qualification that it reflects desktop visits only.