Fix it
My file won't upload
A list comes in as a .csv or .txt file of up to 50,000 rows and 50 MB, with a header row and an email column. Here's what each message means, and the fix.
Most lists go in first time. When one doesn't, the message says why, and the fix takes a minute.
What the message says, and what to do
| The message says | What to do |
|---|---|
| Please upload a .csv or .txt file. | Save your spreadsheet as a CSV first (below). |
| File too large | A file can be up to 50 MB. Split it in two, and upload each part to the same list. |
| File has … rows — limit is 50,000. | Split it into files of 50,000 rows or fewer, and upload each to the same list. |
| File must have a header row and at least one data row. | Put the column names in the first row, like Email and First name, with your contacts below. |
| You must map an email column. | On the mapping step, set the column that holds the addresses to Email (required). |
Save a spreadsheet as a CSV
| In | Do this |
|---|---|
| Excel | File, Save As, then choose CSV UTF-8 |
| Google Sheets | File, Download, then Comma Separated Values (.csv) |
| Numbers | File, Export To, then CSV |
The Import button won't press
Tick the box that says everyone on the list asked to hear from you. The import can't start without it.
Good to know
Uploading to a list that already has people on it? Update existing subscribers refreshes their details. Insert new only skips anyone already there.
Step by step: Upload and clean your list.
Related
- Upload and clean your listMake a list, upload your contacts as a CSV, check the columns and confirm consent. Every address is cleaned on the way in, then checked with its own mail server.Step by step · 13 steps
- Why fewer people get my campaign than I uploadedDuplicates and broken addresses are left out as a list comes in, and an address that fails its check, bounced or unsubscribed is never mailed. The list's Clean tab shows each one, and why.Fix it
- Can I bring my contacts from another email platform?Yes. Export them as a CSV from your old platform and upload it to a list. Keep its status column, and anyone it marks unsubscribed, bounced or invalid stays off that list.Question