Skip to main content

Import parts from a spreadsheet

Parts → "Import from Excel" loads many parts at once from an .xlsx or .csv file. Nothing is saved until you have seen the preview and pressed Import.

The window has a "Download template" button with the expected columns and an example row.

Columns​

Headers are recognised in English and Spanish, ignoring accents and capitals: serial, category, km, hours, events, expiry, car, position, location, notes, plus the date the part was registered. If a header isn't recognised, pick the column by hand.

The preview​

Every row is shown as one of three:

  • Will be created — ready to import.
  • Already exists, skipped — a part with that serial is already in your team (the preview says where it is). The import never changes an existing part.
  • Error — the reason is on the row. Rows with errors are left out; the rest can still be imported. "Download errors" gives you those rows to fix and import again.

What is refused​

Parts lifing is safety-critical, so the import refuses anything it would otherwise have to guess:

  • A wrong unit in a column (for example miles or hours in the km column). Units are never converted.
  • An ambiguous number such as 1.234 or 1,234, unless the same row shows which mark is the decimal.
  • An ambiguous date such as 03/04/2026. Use 2026-04-03 or a day above 12.
  • A category that isn't in your catalogue (the closest name is suggested), a car that isn't in the programme, or a position already taken or over the category's maximum.
  • A serial repeated in the same file.

A row with no km is imported as a new part with 0 km, and the preview flags it so it isn't missed.

After importing​

The summary names every row as created or not created, with the reason. A part only counts as created once the server has confirmed it.

Not imported (add them from the part afterwards): sub-components (for example an engine's turbos), and a part's status (a part with a car comes in as fitted, otherwise as a spare).

Was this page helpful?