SPIR spare parts record extraction

SPIR forms are the least spreadsheet-like spreadsheets in engineering: multiple tabs, merged headers, tag groups running across the columns and part line items running down the rows. AxioExtract reads them with a deterministic template parser rather than a vision model, so the same form gives the same result every time.

How the read works

Deterministic, not AI-guessed

The parser locates the SPIR layout by its printed labels and positions. Its always recommend to us ethe source .xlsx file and industry standard format for best results.

Specific tabs only

Multi-tab workbooks are common — the data usually lives on one sheet such as “SPIR Data”. Only the relevant sheet is read, so supporting tabs, instructions and revision logs do not pollute the output.  Source spreadsheets are required to ensure pages are picked up correctly.

Matrix to triples

The tag-versus-part matrix is flattened into (tag group, part, quantity) triples, which is the form that spreadsheets, ERPs and procurement systems can actually use.

PDF SPIRs

When the SPIR arrives as a PDF rather than a workbook, the grid is reconstructed from the page geometry — text positions and rule lines.

Tag register and bill of materials

A tag group covers several physical tags. “Generate tag register” explodes each group into its individual tags and can be downloaded as CSV. From there the BOM panel builds either a per-tag bill of materials — every tag with its parts and quantities — or a consolidated one that sums identical parts into a single procurement line. A dropdown filter shows the item count per tag so you can view the BOM for one tag at a time. More on BOM output is on extract a BOM from a PDF.

Scoring and blank cells

SPIR forms are legitimately sparse: most tag-versus-part intersections are empty because that tag does not take that part. Completeness scoring therefore counts only the columns a SPIR read must fill, and ignores non-required cells that are blank on the source, so a correctly read sparse form is not penalised.

Previewing the workbook

Spreadsheet and PDF SPIRs are shown in a built-in preview with a tab strip and sticky headers, so a selected row scrolls into view on the original sheet. Corrections are made in the grid before exporting to Excel, Google Sheets, JSON or XML.

Common questions

What is a SPIR?

A Spare Parts and Interchangeability Record is a supplier form that lists tag groups across the columns and spare part line items down the rows, with quantities at each intersection. It is used to agree recommended spares for a package of equipment.

Can a SPIR be read without AI?

Yes. AxioExtract reads SPIR workbooks and SPIR PDFs deterministically, using label and position matching rather than a vision model, which makes repeat reads of the same template consistent.

Can a bill of materials be produced from a SPIR?

Yes. After review you can generate a tag register from the tag groups, then build a BOM in per-tag or consolidated view, filter it to a single tag, and export it.

Try it on your own document

Credits are included with every new workspace — no card required to start.

Start extracting