How do I format my data correctly for import?
Last Updated 10 days ago
Follow these requirements when preparing your import file:
- Arrange data with one record per row
- Separate each data item with your chosen delimiter (comma, tab, semi-colon, or colon)
- Do not include column headings in your data rows
- Include a header row and a terminal row with the word
END in the first column - Maintain the same column order as the provided template
- Include blank entries (e.g.,
60,,First Class) for missing data fields - Limit files to a maximum of 1000 records per import
Important: Choose a delimiter that does not appear in your data. For example, if your data contains commas (like "Newman, Paul"), use a different delimiter to avoid import failures.