How to prepare a csv for mail merge by removing unused columns
- Step 1Export your contact list as CSV — Download from your CRM, form tool, or spreadsheet.
- Step 2Drop the file into Column Remover — All columns are listed. Select the ones you do not need for the merge.
- Step 3Remove surplus columns — Keep only: FirstName, LastName, Email, and any personalisation columns like Company or City.
- Step 4Import into your mail merge tool — Upload the trimmed CSV to Word, Google Docs, Mailchimp, or your chosen tool.
Frequently asked questions
What columns should I keep for a basic email merge?+
At minimum: FirstName (or FullName) and Email. Add Company, City, or any other columns you reference in the template.
Can Mailchimp handle a CSV with extra columns?+
It can, but each column becomes an audience field and clutter makes mapping slower. Trimming first saves setup time.
Does this change the email or name data?+
No. Only the removed columns are affected. Remaining data is untouched.
Privacy first
Processing runs locally in your browser with PapaParse. No file is uploaded — only metadata counters are saved for signed-in dashboard stats.