# 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, 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](https://help.jounce.com/contacts/import-from-a-csv/add-a-custom-field-while-importing).

## 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?](https://help.jounce.com/contacts/import-from-a-csv/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](https://help.jounce.com/contacts/import-from-a-csv/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

See [Import contacts from a CSV file](https://help.jounce.com/contacts/import-from-a-csv/import-contacts-from-a-csv-file).

## 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 2026-11-09 · https://help.jounce.com/contacts/import-from-a-csv/prepare-your-csv-file
