Purpose
Prerequisites
Open the selected import flow or guide and obtain its current template and column instructions. Confirm the required file format before preparing your data in Excel or Google Sheets.
Steps
- Follow the selected import's current template and column instructions.
- Check the values and remove accidental surrounding spaces. Do not rely on colours, bold text or complex formulas to communicate data.
- Export or save as
.csvif the selected import requires CSV, rather than uploading.xlsor.xlsx. - Follow that import's column-matching and validation steps where offered. Correct reported issues before submitting.
- Use the selected import's result checks to confirm which rows succeeded or failed.
Fields and columns
- Headers and identifiers: use the exact names and matching identifier specified for the selected import.
- Data values and formats: follow that import's column, delimiter, encoding and date requirements; there is no universal CSV schema.
Expected result
You have a file prepared for the selected import's own specification and can proceed to its validation stage. Preparation or upload is not proof that the import finished.
Limitations
Different imports have different templates, columns and formats. This checklist does not replace the selected import's specification or guarantee that every row will succeed.
Errors and recovery
If matching or validation reports an error, use the relevant template and error message to correct the file. Review the result after submission rather than assuming upload means success.