You can upload existing data to use in experiences. All files you upload to the platform must adhere to the following requirements:
- All files must contain comma-separated values in CSV, TXT, or TSV format. You can compress the file with a ZIP or GZ extension.
- All files must use UTF-8 character encoding and without the byte order mark (BOM).
- Files cannot exceed 10 GB uncompressed or 100 million rows.
- Files cannot contain more than 30 columns and must contain at least one column.
- Include only a single row per unique identifier.
- Omit thousandths separators from numeric values (for example, 9,000 should be
- Omit leading currency symbols.
- You must put a set of double quotation marks (") at the beginning of and at the end of the content of a field if that content includes a comma (for example,
"Bldg 2, Ste 29").
- Dataset names and headers are limited to the Latin-1 (ISO-8859-1) character set.
If you have any questions about dataset requirements or increasing an account's row limit, contact your Account Manager.
You can include the following data types in a file:
- Strings (text)
- Boolean (true/false)
The platform treats the following values as empty:
- An empty value
Header vs. Headerless Rows
When you create a new dataset, the initial file must contain a header row. The header rows that you include in subsequent files are used to identify new and updated attributes. Verify that the column headers remain the same in subsequent files that you upload to maintain the integrity of the columns in the dataset.
If you want to update an existing dataset without adding new columns, you can exclude the header row from the file. Add
NOHEADER to the end of the filename (for example,
123_filename_NOHEADER.csv) to indicate that the file doesn't contain a header row.
Date and Time Requirements
Use the ISO 8601 standard for all dates and times.
Columns that contain
date values must adhere to one of the following formats:
Columns that contain
time values must adhere to one of the following formats:
You can provide fractions of a second, but you must separate them with a period or a comma. You can include up to six digits. Any more than six digits are ignored.
You can use a space or
T to delimit the date from the time. For example, submitting
YYYY-MM-DDT11:50:00 results in
Unless you specify a different time zone, Coordinated Universal Time (UTC) is applied. When you specify other time zones, the following formats are supported:
The following examples demonstrate time zones that have been correctly formatted:
The platform interprets the following values for Boolean data as true or false:
The platform converts text in Boolean data types to lowercase before comparing it to these values.