Import data formatting requirements

Modified on Tue, 5 Dec, 2023 at 4:22 PM

When importing data into Audience Republic, the values in your import file must meet certain formatting requirements, or the import may not succeed.

When preparing your data for an import, thoroughly check that each field meets the outlined requirements:

Contact field requirements

Email address

  • The cell format should be General or Text
  • A valid email address consists of an email prefix and an email domain. For example: testprefix@testdomain.com
  • Make sure that no spaces exist, either within the email address or after it. To remove invisible spaces we recommend using the TRIM function in excel.



Names (First name and Last name)

  • The cell format should be General or Text
  • The first and last name of the contact must be split into 2 separate columns


Mobile number

  • The cell format should be General or Text
  • Mobile numbers must include:
    - International country calling code
    Area code: See here for reformatting area codes.
    Phone number
  • Numbers and '+' symbol will be accepted
    Spaces and dashes will be ignored
  • Remove () brackets



Gender

  • The cell format should be General or Text
  • Gender values can be entered as either:
    • M / F / O
    • Male / Female / Other


Date of birth

  • The cell format should be Date: DD/MM/YYYY or YYYY/MM/DD



Country

  • The cell format should be General or Text
  • For best results we recommend ISO 3166 2 letter codes but other formats (e.g. United States or USA) are accepted. Best practice is to ensure all data uses the same format prior to import.

State

  • Country must be included in your CSV file
  • When mapping the fields during importing, ensure you select Country and State


Tags

  • The cell format should be General or Text
  • Only these character types will be imported for tags
    • Letters (abcdefg)
    • Numbers (12345)
    • Hyphen ( - )
    • Underscore ( _ )
  • If there are multiple tags, each tag should be separated by a comma:

  • Another acceptable format is tags separated by commas and also wrapped by quotes (This is the format MailChimp exports tags by default)



Event field requirements

Start or End date and time

  • The cell format should be Custom: d/mm/yyyy h:mm


Event ID

  • The cell format should be General or Text 
  • Each Event ID must be unique
  • Values can include numbers, upper and lower case letters and symbols


Ticket/order field requirements

Order date and time

  • The cell format should be Custom: d/mm/yyyy h:mm
  • Note that upon importing, you will be asked to identify a timezone for the Order date and time. You should select the timezone applicable to the data you are importing, not the timezone you are in. Typically, order date and time is provided in UTC, though some ticketing provider platforms may translate the date to your local time. If you are unsure we recommend contacting your ticketing provider.


Order ID

  • The cell format should be General or Text 
  • Each Order ID should be unique
  • Values can include numbers, upper and lower case letters and symbols


Total paid

  • The cell format should be Number, with 2 decimal places 



Related articles

Prepare ticket sales data for import

Prepare events data for import

How to reformat mobile numbers to include country codes

Troubleshooting: importing contacts to a list


Still need help?

Contact us at support@audiencerepublic.com 



Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article