Tab-delimited File Tips

A tab-delimited file is a text file that's set up with a tab separating each column of text. Mailchimp accepts these types of files for contact imports, and helps you map tabbed columns to a field in your audience.

Tips for setup

  • Before you export your file from a database application, take a look at their FAQs or support page for instructions on how to save as a tab-delimited file. It's a standard export format, but since every application is different, the steps will vary.
  • You can also export data as a tab-delimited file from most spreadsheet applications. Make sure your file ends with a ".txt" extension.
  • After you have a tab-delimited version of your audience, open it in a spreadsheet, like Microsoft Excel, to arrange and format your columns for import to Mailchimp. When you export the final, edited document from Excel, make sure to save it as a tab-delimited file again.

If you run into other problems with your import, check out these import troubleshooting tips.

Was this article helpful?

Anything else we can do to improve our site?