Fix Excel template-data imports
Imports can fail or produce poor results when spreadsheet headers, rows, or values do not match the template.
Steps
- Confirm the file opens normally in Excel.
- Use one header row and consistent column names.
- Remove unintended blank rows and merged cells.
- Preserve leading-zero identifiers as text.
- Export a working table and compare its structure with the import.
Good to know
The import warning indicates that existing table data will be overwritten.