CSV Column Mapper
Fit an export to an import template — or pick, rename and reorder its columns.
1. Your file
The CSV or Excel file whose columns you want to choose, rename, reorder or fit to an import template. CSV files over 50 MB are read as a stream.
Or paste the table (from Excel, Google Sheets or a CSV)
2. Columns
Untick a column to drop it, type a new name to rename it, and move it with the arrows. The download has the kept columns in this order.
Copy the first row of the sample file a CRM, store or accounting program gives you for imports. Each of its columns gets the column of your file with the same or a similar name; check the choices and fill in defaults.
Saved mappings
Saved in this browser only, with the source columns by name — so a mapping fits the next export with the same headings.
3. Result
About the CSV Column Mapper
Get a CSV or Excel file into the shape another program wants. Choose and arrange keeps the columns you tick, in the order you set, under the names you type. Match an import template starts from the other side: paste the header row of the import file a CRM, online store, mailing service or accounting program expects, and each of its columns is filled from the column of your file with the same name, a usual synonym (Mobile for Phone, Pincode for ZIP, E-mail for Email) or a similar spelling. Template columns your file does not have get a default value — a country, a currency, a tag — so the import does not fail on an empty required field.
Mappings can be saved in your browser with the source columns by name, so next month’s export with the same headings maps in one click. CSV files larger than 50 MB are read as a stream: the preview shows the first rows and the download runs through the whole file without loading it into memory.
How to use it
- Choose your CSV, TSV or Excel file, or paste a table copied from a spreadsheet.
- To pick columns: under Choose and arrange columns, untick the ones to drop, type new names, and move columns with the arrows.
- To fit a template: choose Match an import template and paste the template’s header row. Check each suggested column (the badge says how it was matched), change any that are wrong, and fill in default values for the rest.
- Optionally save the mapping under a name for the next file.
- Check the preview and download the result as CSV, TSV or Excel.
Examples
Your file: Customer Name, E-mail, Mobile, Pin code, Notes · Template: Name, Email, Phone, Zip, Country
Name ← Customer Name, Email ← E-mail, Phone ← Mobile, Zip ← Pin code, Country ← default “India”; Notes is left out.
Invoice No, Date, Party, GSTIN, Taxable, CGST, SGST, IGST, Total
Customer, GSTIN, Invoice No, Total — four columns in a new order, “Party” renamed to “Customer”.
Common uses
- Preparing a customer or product file for an import into a CRM, an online store or an accounting program.
- Removing columns with private data before sharing a file.
- Putting the columns of monthly exports in the same order before combining them.
- Renaming cryptic export headings into readable ones.
How columns are matched to a template
Names are compared after removing case, spaces, punctuation and accents, and splitting joined words (FirstName = First name = first_name). A template column is filled from:
- a column with the same name — “E-mail” for “Email”;
- a usual synonym — Mobile, Cell or Contact number for Phone; Pincode or Postal code for ZIP; Surname for Last name; Organisation for Company; Remarks for Notes;
- a similar name — the same words in another order, or a spelling slip such as “Adress” or “Emial”, marked so you can check it. Names with different numbers (Address 1, Address 2) and short names a letter apart (Date, Data) are never paired.
Names in any script are compared (Имя = имя). Each column of your file is used once, best matches first; anything else is left for you to choose. Nothing is decided for you without being shown: every template column lists the column it takes, and you can pick another or none.
Defaults, saved mappings and large files
A template column with no source gets its default value in every row (or stays empty); tick Use the default values for empty cells too to fill blanks in mapped columns as well. Saved mappings stay in this browser’s storage and refer to source columns by their names; when a column is missing from a new file, the page says which and uses the default instead. CSV files over 50 MB are streamed: they can be saved as CSV or TSV (an Excel file would need the whole table in memory).
Limitations
- Workbooks up to 50 MB and CSV files up to 50 MB are loaded whole; larger CSV files, of any size, are streamed and saved as CSV or TSV (not Excel).
- Matching uses column names only, not the contents; check the suggested columns before importing.
- Cells are copied as they are: dates and numbers are not reformatted.
- Saved mappings are kept only in this browser; clearing its data deletes them.
Privacy
Everything happens in your browser. What you enter or open here is not uploaded or stored by MySmartCoPilot.
Frequently asked questions
How do I delete columns from a CSV file?
Choose the file, untick the columns under Choose and arrange columns (or Drop all and tick the ones to keep), and download. The other columns keep their values exactly.
How do I make my file match an import template?
Copy the first row of the template file (the column names), choose Match an import template and paste it. Check the suggested column for each, set defaults for the ones your file does not have, and download.
What does the badge next to a column mean?
Same name and Usual synonym are confident matches; Similar name is a guess from the spelling to check; Chosen is your own choice; No column means the template column gets its default value.
Can I reuse a mapping for next month’s file?
Yes. Type a name under Saved mappings and select Save mapping. Next time, choose the new file and apply the mapping; columns are found by their names.
Is my file uploaded?
No. The file is read in your browser and the new file is created on your device; saved mappings stay in this browser.