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 list imports, and helps you map tabbed columns to a field in your list.

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 list, open it in a spreadsheet, like Microsoft Excel, to arrange and format your columns for import to MailChimp. When you export the final, edited list from Excel, make sure to save it as a tab-delimited file again. 

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

Was this article helpful?
What can we do to improve articles like this?

Technical Support