# Prepare a CSV file for an import

## Purpose

Prepare the file for the specific entity and operation you want to import. A CSV extension alone does not make a file valid for that import.

## 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

1. Follow the selected import's current template and column instructions.
2. Check the values and remove accidental surrounding spaces. Do not rely on colours, bold text or complex formulas to communicate data.
3. Export or save as `.csv` if the selected import requires CSV, rather than uploading `.xls` or `.xlsx`.
4. Follow that import's column-matching and validation steps where offered. Correct reported issues before submitting.
5. 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.

## Choose the import guide

- [Update Products](/article/import-products)
- [Import Supplier products](/article/import-supplier-products)
- [Import Products to one promotion](/article/import-products-to-promotion)
- [Choose a promotion import route](/article/import-promotions)
