How to standardise column names across multiple csv exports
- Step 1Define your target column name schema — Agree on canonical column names: 'sku', 'quantity', 'price_gbp', 'supplier'.
- Step 2Open each export in Header Rename — Drop each supplier or partner file in turn and rename headers to the schema.
- Step 3Download each standardised file — Save each renamed CSV before moving to the next file.
- Step 4Merge the standardised files — Feed the renamed CSVs into the CSV Merger tool to produce one clean dataset.
Frequently asked questions
Can I process multiple files at once?+
Header Rename works on one file at a time. For each source file, repeat the rename-and-download cycle.
What if two columns in the same file should have the same canonical name?+
Duplicate column names cause problems in most tools. Rename one to a unique variant and document the difference in your schema.
Is there a way to automate this for many files?+
For bulk or recurring standardisation, the Pro API exposes this operation programmatically.
Privacy first
Processing runs locally in your browser with PapaParse. No file is uploaded — only metadata counters are saved for signed-in dashboard stats.