input-textStandard Fields

When you import a CSV into Daisychain, you should include column headers for each field.

Standard headers found in the template file (available herearrow-up-right and in Step One of the CSV Import Wizardarrow-up-right). Alternative header names will be auto-matched by our importer -- see the table a the bottom of this help doc for more details.

Note that you do not need to include all of the fields below when uploading a CSV file -- the minimal requirement for successful CSV upload is email address and/or phone number.

  • first_name

  • last_name

  • email

  • phone_number

  • email_opt_in Values for this field must be "TRUE" to ensure a person can receive emails through Daisychain. ​

  • sms_opt_in A "TRUE" value here is only required for sms_opt_in if you plan to send texts from phone numbers that have strict opt-in requirements, such as short codes or phone numbers outside of the US. For standard 10DLC long codes or toll-free numbers in the United States, a contact can still be texted as long as they are Textable, even if sms_opt_in is not "TRUE." ​

  • sms_opt_out This field indicates whether the person has explicitly opted out of receiving SMS messages.

  • post_office_box

  • street_address

  • extended_address Often known as "line two" of an address. ​

  • locality Town or city ​

  • region State, province, or region. Values for this field should be two or three letters, following the ISO 3166 standardarrow-up-right. In the United States, use the two letter abbreviation for the state. ​

  • postal_code Also known as a ZIP code or post code. ​

  • country Values for this field should be two letters. If you're unsure of the right two-letter country code, please reference the List of ISO 3166 country codesarrow-up-right, and look for the Alpha-2 column. ​

  • tags Values for this field should be lowercase and without any spaces -- any spaces in tags should be replaced by dashes. Multiple tags can included in a single column, separated by commas. Tags need to first be created in Daisychainarrow-up-right before they can be added with a CSV upload.

Full List of Accepted Header Names

Field Name
Accepted Inputs

First Name

first_name, firstname, FirstName, First Name, first name, fname, FName, First

Last Name

last_name, lastname, LastName, Last Name, last name, lname, LName, Last

Email

email, Email, email_address, emailaddress, EmailAddress, email address, Email Address

Phone Number

phone_number, phonenumber, PhoneNumber, phone number, Phone Number, phone, Phone, Cell Phone, cell_phone, cellphone, CellPhone, cell phone, mobile, Mobile, Mobile Phone, mobile_phone, mobilephone, MobilePhone, mobile phone

Email Opt-In

email_opt_in, emailoptin, EmailOptIn, email opt in

Email Opt-Out

email_opt_out, emailoptout, EmailOptOut, email opt out

SMS Opt-In

sms_opt_in, smsoptin, SmsOptIn, sms opt in

SMS Opt-Out

sms_opt_out, smsoptout, SmsOptOut, sms opt out

Post Office Box

post_office_box, postofficebox, PostOfficeBox, post office box

Street Address

street_address, streetaddress, StreetAddress, street address, Street Address, address, Address

Postal Code

postal_code, postalcode, PostalCode, postal code, zip_code, zipcode, ZipCode, zip code, Zip Code, Zip, zip

Extended Address

extended_address, extendedaddress, ExtendedAddress, extended address

City

locality, Locality, City, Town, city, town

State/Region

region, Region, State, state, province, Province

Country

country, Country

Tags

tags, Tags, tag, Tag

Last updated