Troubleshooting

Fix Excel template-data imports

Imports can fail or produce poor results when spreadsheet headers, rows, or values do not match the template.

Steps

  1. Confirm the file opens normally in Excel.
  2. Use one header row and consistent column names.
  3. Remove unintended blank rows and merged cells.
  4. Preserve leading-zero identifiers as text.
  5. 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.