To successfully synthesize your dataset, the content must be encoded in UTF-8, have commas (,) or semicolons (;) as comma separators, and adhere to the following rules:
Header row
-
The first row must contain the column names.
-
Each column name in a table must be unique and may not exceed 255 characters.
-
These names cannot have special characters like commas, semi-columns, columns, slash, dollar-sign, backslash, quotes, double-quotes, etc.
Alphanumeric entries (text, categories, strings)
-
Entries containing line breaks, and spaces at the beginning or end, must be quoted with double-quotes.
“this is, one column” “this is \n two lines” “ space at the beginning and end “ -
double quotes in entries must be escaped with double quotes itself
“this does contain “”quoted text”””
Date and time values
-
must be encoded in one of the below formats
-
must have missing values encoded as empty strings
| Format | Example | |
|---|---|---|
Date |
|
2020-02-08 |
Datetime with hours |
|
2020-02-08 09 |
Datetime with minutes |
|
2020-02-08 09:30 |
Datetime with seconds |
|
2020-02-08 09:30:26 |
Datetime with milliseconds |
|
2020-02-08 09:30:26.123 |
|
The following formats are not supported:
|