Prepare your CSV file
Short answer
Save your list as a CSV with a header row and one column of email addresses. Name the columns the way Jounce expects and it matches them for you.
When you’re done, you have a file Jounce can read in one go, with every column landing in the right field.
What the file needs
- A CSV file. The file picker offers only CSV files, and an Excel or Numbers file dropped on the box is turned away, so save a spreadsheet as a CSV first. In Excel, choose Save As and pick CSV UTF-8 as the file type, or plain CSV if your Excel doesn’t list it. In Google Sheets, choose File, Download, then Comma-separated values.
- A header row. The first line names the columns. Jounce reads it to match them.
- An email column. You can leave out every other column.
- Under 10MB. The upload box says CSV up to 10MB and refuses a larger file.
A file can hold up to 50,000 rows. For a longer list, split it into two files and import each. A workspace can import 250,000 rows a day in all.
Excel saves a CSV differently from one country to the next, and Jounce works out what yours did. Commas, semicolons, and tabs between columns all read the same, and an accent like the é in José comes through from either file type. For an alphabet beyond Western Europe’s, such as Polish, Greek, or Japanese, save it as CSV UTF-8.
A sample to copy
On the Upload step, select Download a sample CSV. You get
sample-contacts.csv, with one example row. Its columns are First name,
Last name, Email, Optin time, Optin IP, Confirm time, Confirm IP, Segments.
Replace the example row with your people and keep the header.
Column names Jounce recognizes
Jounce matches a column by its header. It ignores capitals, spaces, hyphens, and underscores, so first_name matches First name. You can fix any match on the next step, so a different name isn’t a problem.
| Field | Headers Jounce matches |
|---|---|
| Email, Email address, E-mail, Mail | |
| First name | First name, Firstname, First, Given name, Fname |
| Last name | Last name, Lastname, Last, Surname, Family name, Lname |
| Segments | Segment, Segments, Tag, Tags, List, Lists, Group |
| Consent date | Optin time, Opted in at, Subscribed at, Subscribe date |
| Keep as proof | Optin IP, IP address, Confirm time, Confirm IP |
| Status | Status, Subscriber status, Subscription status, Email status |
A header that matches one of your custom fields, such as Birthday, maps to that field. Any other column starts as Don’t import. You can map it by hand or create a field for it.
The Segments column
Put the segment’s name in the cell. For several, separate them with a colon,
like VIP:Newsletter. A semicolon, a vertical bar, or a comma works too. (Your
spreadsheet puts quotes around a cell with commas when it saves the CSV.)
Jounce adds the person to each segment with that name. When your file names a segment you don’t have yet, Add them to a segment offers to create it, in a box that starts ticked. Untick it, and those people still come in, just not into the segments you didn’t have.
A segment with a colon in its name, such as Interest: Photography, still matches. Jounce looks for the whole name before it splits at a colon. Some tools export each tag in quotes, like “VIP”,“Newsletter”, and Jounce reads each quoted name whole.
A Status column
Some tools put your whole list in one export, with each person’s status in a column. A column with one of the Status headers in the table above maps there on its own. You can set any other column to Status by hand.
Jounce then takes in only the rows marked active, subscribed, confirmed or opted in, and the rows left blank. Capitals don’t matter, a hyphen reads as a space, and a subscriber or contact at the end is left off. So Confirmed subscriber and Opted-in both count as active.
Every other row is rejected with its reason. When a Manager or an Admin imports the file, Jounce also remembers everyone it marks unsubscribed, bounced or spam. Then a later import can’t add them back. Someone on your list who is still Subscribed takes that status too. See Why were some rows rejected?
Careful Check that the column holds your other tool’s email status. One that means something else, such as an order’s status, can mark people unsubscribed: Cancelled reads that way. Set it to Don’t import, since you can’t undo what an import keeps.
A file with an UNSUB_TIME or a CLEAN_TIME column works the same way, even without a Status column. Mailchimp puts them in its unsubscribed and cleaned exports. A row with a time in either is read as unsubscribed or bounced, whatever that column maps to.
Without a Status column, or one of those, each new person Jounce takes in is Subscribed. So before you import, delete the rows of anyone who isn’t active in your other tool.
An address on more than one row
Jounce treats every row with the same email address as one contact, and capitals don’t matter: Ada@example.com and ada@example.com are the same address. That contact joins the segments from every row.
A name or custom field in a later row replaces an earlier row’s, and an empty cell leaves it alone. For someone new, the consent date and proof come together from the first row that has either.
The summary counts each contact once and puts the extra rows on a line of their own. For a long list, the email Jounce sends does the same.
Bringing a list from another tool
Most tools export their opt-in date and IP columns with the list. Keep them in the file. Jounce matches them to Consent date and Keep as proof, so your permission records come with you. Keep your opt-in proof when you import explains what Jounce stores.
Keep a status column too, if the export has one, and every row with it. Jounce leaves out the people who aren’t active. When a Manager or an Admin imports the file, Jounce also remembers the ones who opted out.
Next step
More in this topic
Also answered here
- do my column names have to match exactly
- does the import create segments from my file
- what format does my file need to be
Updated