Skip to main content

CSV Upload - FAQs

What format does thanks.io require?​

UTF-8 encoded with a header row. Each subsequent row is one recipient.

What columns are required?​

A deliverable physical address is required (at minimum: street address and country). Name, city, state/province, and postal code are strongly recommended. Email, phone, and custom fields are optional.

How do I map custom fields?​

The upload column-mapping screen lets you map CSV columns to custom1-custom10. Once mapped, those values are available as %CUSTOM1%-%CUSTOM10% in any creative's message (or the message you write in Send Mail).

I mapped a custom field, but I don't see it on my list. Did the import work?​

Custom fields aren't among the columns a mailing list shows by default, so a successful import can look like it left them out. Open the list, click Columns in the recipients toolbar, and tick the fields you want under Custom fields (for example Custom 1). The values appear as a column beside each recipient. You can also click any recipient to see all of their fields in the edit dialog.

The column choice applies to every list and is remembered in the browser you made it in. On a phone the optional columns are hidden, so check from a wider screen. See Choosing which columns show.

Can I preview before uploading?​

Yes. thanks.io shows a preview with sample rows and column mappings before you confirm the import.

What happens to duplicate rows?​

Duplicate rows are imported. Duplicate Prevention then governs whether each recipient receives mail within the 36-hour window. De-duplicate your CSV before uploading for cleaner lists.

Does CSV upload update existing recipients?​

No. Uploading adds new recipients. To update an existing recipient's address or custom fields, edit the recipient directly in the dashboard.

How do I handle international addresses?​

Include a country column with the 2-letter country code (e.g., CA, GB). Follow the postal conventions of the destination country.

How do I add a spouse, second name, or business name to the postage address?​

Use the 2nd Contact field (the CSV column header is company). The value you enter will appear below the recipient's name on the envelope.

You can also reference it in a message using %COMPANY%.

If you want to address both people in the message body (for example, "Dear Bob & Alice"), store the combined name string in a custom field such as custom1, then use %CUSTOM1% in your message.