Tools › Map Columns to a Template
Map Excel Columns to a Template
Rename and reorder columns to match a required template, fill defaults, check required columns. Free — no sign-up.
Free tools powered by Toolsitz — more free tools for files, PDFs and images.
How to use it
- Choose your data file (and optionally the template file with the right headers).
- Write the mapping, one per line:
Template column = Your column. Add defaults likeCountry = India. - Press Run. Rows missing a required column go to a separate errors file.
Useful when a website, bank or software wants an upload file in its own exact format. Columns with the same name are matched automatically.
What you get
- Mapped CSV/XLSX in the template's column order
- Errors file: row, column, reason
- Mapping recipe
Good to know
- Name the template file template.* so we know which is which
- Up to 20 MB per file, 2 files at a time.
- Files are deleted from our server within an hour.
Do it yourself in Excel
Questions
Do I need the template file?
No. Writing the mapping is enough.
What happens to rows that fail?
They go into errors.xlsx with the reason, so you can fix and re-run them.
