Manufacturing ERP Archives: Converting Microsoft Works Spreadsheets Before They Disappear

TL;DR

Manufacturing archives still contain BOM extracts, costing models, capacity plans, and MRP outputs in Microsoft Works formats. Converting them locally to XLSX, CSV, and PDF preserves chain-of-custody, enables reuse for audits and product-line analysis, and removes the risk of uploading sensitive operational data to a free online tool.

Where Microsoft Works files hide on the plant floor

Bills of material, routing snapshots, capacity plans, MRP outputs, and per-product costing files were the lifeblood of pre-ERP manufacturing. Even after migrating to SAP, Oracle, or modern MES platforms, those .wks and .wdb files often survived because they were copied forward during every storage migration—and because someone signed off on a price or quantity using one of those files.

They tend to live on plant file shares, in folders named with serial numbers or fiscal years, and inside zip files attached to old change-control records.

Why the archive still matters

Old Microsoft Works files come back into scope during audits, warranty analysis, recall investigations, supplier disputes, divestitures, and product-line research. The file format becomes the access barrier long before the data becomes irrelevant.

When a finance or quality team needs a 1998 cost build to defend a current contract, the archive is suddenly business-critical—and uploading it to a random online converter is rarely acceptable.

Convert in three priorities

1. XLSX for active review

Use XLSX as the primary review format. It opens in Excel, preserves multiple sheets, and lets analysts recalculate models against current assumptions.

2. CSV for analytics ingestion

Push CSV exports of key tabs into your ERP staging area, data warehouse, or Power BI dataset. CSV is the most reliable format for downstream pipelines and SQL load jobs.

3. PDF for immutable archival

Generate PDFs alongside the XLSX/CSV outputs to keep a "what the original looked like" snapshot. PDF is the right format when the file becomes audit evidence.

Chain-of-custody for industrial archives

Convert from a read-only copy of the source archive, write outputs to a separate folder, and capture a per-file conversion log with source path, output path, format, and timestamp. That log is what auditors and supplier dispute teams will ask for.

Keep the originals untouched. The Microsoft Works file binaries are evidence of what existed; the converted files are how today's teams interact with that evidence.

Get ahead of the next audit

The teams that survive the next supplier dispute or product-line review are the ones whose 1990s spreadsheets are already converted, indexed, and searchable. Modernize the archive once and stop fearing the file extensions.