Municipal Records Migration: Quattro Pro Files in Government Archives

TL;DR

Cities, counties, and agencies often retain Quattro Pro worksheets for budgets, parcels, grants, and department reports because retention schedules are measured in decades. Local conversion to PDF, XLSX, HTML, and CSV produces formats that fit modern records systems while keeping potentially sensitive constituent data inside the agency network.

Public records age in decades, not quarters

Budget worksheets, parcel summaries, grant tracking sheets, and department reports may be retained for 25, 50, or even 75 years depending on the records schedule. The format becomes the access barrier long before the records reach end-of-life.

Public-records requests, council inquiries, audits, and grant reviews can all surface these files on short notice. The team that already has them converted moves at a different speed than the team that does not.

Why government data should never go to a free converter

Constituent data, parcel-level information, vendor lists, and personnel-adjacent records appear inside many of these workbooks. Uploading them to an unknown server is rarely allowed under state IT policy and frequently violates the records-management standard the agency has already adopted.

A desktop tool that runs on the agency workstation keeps the data inside the network and produces outputs that map cleanly to the records system.

Retention-friendly output set

1. PDF for access and retention

PDF/A is the long-term format most state archives expect. Generate a PDF for each Quattro Pro notebook so requests, councils, and auditors can be served quickly without spinning up a spreadsheet client.

2. XLSX for staff review

XLSX is the working format. Department staff open it in Excel to verify totals, review formulas, or build the next year's plan from a historical baseline.

3. CSV for ingestion into records systems

Most modern records management and ERP platforms ingest CSV well. Use it for parcel rolls, vendor lists, and any tabular records that need to live inside the system of record.

A retention-aware workflow

Document the retention schedule that applies to each archive. Convert the original Quattro Pro notebook, keep the binary alongside the converted outputs, and capture a conversion log that ties source-to-output paths and timestamps.

Treat the converted PDF as the access copy and the XLSX/CSV outputs as the analytical copies. The original .wq1 stays in deep archive until the retention schedule says otherwise.

Make Quattro Pro a footnote in your records modernization plan

Public-sector teams rarely get extra time to do this work. Convert once, document the workflow in the records-management plan, and move on—your future self handling a public-records request will thank you.