Input data formatting guidelines
Use this as a short checklist before adding data. Detailed normalization and validation rules are described in the detailed normalization and validation documentation.
- For CSV input, use
utf-8encoding (usually this is the default encoding). - Excel files with different encodings are supported as this is internally translated to
utf-8. We do not recommend to use other encodings thanutf-8due to possible encoding translation errors. - For
INTfields, values must be whole numbers.5and5.0are accepted, but5.5is rejected. - We recommend using ISO date/datetime strings:
- date:
2025-02-02 - datetime:
2025-02-02T10:00:00ZOther formats are supported, see the detailed normalization and validation documentation.
- date:
- For
BOOLEANfields, usetrueorfalsestrings (case-insensitive). - If you use an extraction or transformation tool, check the tool documentation for additional input rules.
- For missing values (
null/nan), leave the cell empty. FILEfields are not supported yet.