Import Template Mapper
Map file columns to a required template, check required fields, and export the prepared file.
Comma, semicolon or tab separated, or upload a CSV or XLSX file. The first row holds the column names.
The column names the other system expects, in order, separated by commas.
Your result
Paste or upload your table, then type the template columns.
How to use it
- Paste or upload the table.
- Type the template columns, separated by commas.
- Check the mapping and download the CSV in the template's columns.
Examples
- SynonymMobile for the phone column Matched for you
- Missing columncompany with no source An empty column and a warning badge
- Extra columnNotes Listed as not used
Tool details and privacy
Prepare your table for an import template: type the template columns; they are matched to your file's columns by name or common synonym, and you adjust the rest.
Shop and CRM imports refuse a file whose columns do not match their template.
Options
- A template column can be left empty.
Limits
- Value formats are not converted; use the date normalizer if needed.
- Up to 5,000 rows.
Privacy
What you type or open stays in your browser. Nothing is uploaded or saved on the server.
Questions
Are the values changed?
No, only the columns.
How are columns matched?
By name or common synonyms, and you can change it.
Does it read XLSX?
Yes.
Is the table uploaded?
No.