To export a list go to the Lists section and select My Lists. Then click on the list name.
On the right-hand side, you will find an Export List button.
Click on the Export list button and file for export will be automatically downloaded in XLS format.
What information is in the exported file?
The file will contain the following information about your contacts:
- Email address
- Opt-in time
- Opt-in IP
- Opt-in source
- Confirmation time
- Confirmation IP
- Last changed (date, time)
- +any custom fields you have added
How to convert a CSV file into Excel?
If your list contains special characters, your export may not display correctly in Excel file. To see special characters in Excel, use this workaround.
- Change the file extension from .csv to .txt, then open the file in new, empty Excel file. To do that click on the folder icon on the left-hand side. When Excel prompts for the file type and character encoding, set encoding to UTF-8.