AI Spreadsheet Cleanup: Keep the Original Meaning

Before an AI agent cleans a spreadsheet, define what each column means and which transformations are allowed. Removing visual inconsistency is useful only when identifiers, dates, missing values, units and formulas keep their intended interpretation. A tidier sheet with changed meaning is a different dataset.

Start with a preserved original and a small column rule record. Ask the agent to apply unambiguous rules and return unresolved cells separately. That gives the owner a decision about exceptions instead of a polished file whose assumptions are hidden.

The following examples are hypothetical. A semantic change alters what a value represents, rather than only how it is displayed. Use the table to decide which column rules the agent can apply automatically and which cases should enter an exception record.

W3C’s tabular data model distinguishes a cell’s string representation from its semantic value, which can depend on annotations such as datatype. This supports recording interpretation rules alongside the cells rather than assuming the text is self-explanatory. The standard does not define the business meaning of your spreadsheet.

Python’s CSV documentation provides a concrete loss example: its writer converts None to an empty string and notes that the transformation is not reversible. That is a specific library behavior, not a claim that every export treats missing data the same way.

The rules below are editorial recommendations for agent-assisted cleanup. Inspect the actual import and export path before choosing a format. A successful export confirms a file was written; it does not establish that formulas, cell types or missing-value distinctions survived.

For each relevant column, record its purpose, accepted type, unit or locale, missing-value convention and allowed transformations. A customer reference is an identifier even if every example happens to contain digits. Converting it into a quantity can remove leading zeros that distinguish the original code.

For a hypothetical date column containing “03/04/2026,” neither the agent nor a spreadsheet’s default locale can establish the intended order from that cell alone. Use the source specification or ask the owner. If evidence remains absent, keep the original text and flag the cell rather than choosing the more familiar interpretation.

For units, distinguish a display label from a conversion. Adding a currency symbol does not perform an exchange-rate conversion. A conversion needs an explicit rule and provenance; this article does not recommend rates or financial assumptions.

An exception record should identify the source row, original cell, proposed change, reason for uncertainty and owner decision. Stable row identifiers are important because sorting can change row positions. If the sheet lacks a suitable identifier, preserve a source-row reference before rearranging it.

For duplicates, define the entity and the evidence required to merge rows. Two identical names can describe different people; two different spellings can describe the same organization. Treat the matching decision separately from removing repeated whitespace.

The ask-instead-of-guessing guide helps set escalation thresholds. A known, authorized column rule can run without repeated questions. Missing evidence about the meaning of a cell belongs in the exception record.

Compare the original and output by stable row reference. Check which cells changed, why they changed and whether the rule was authorized. Row counts and totals can catch some mistakes, but equal totals do not prove that values stayed attached to the right entities.

Where formulas matter, inspect both the expression and the result in the intended application. Replacing a formula with its displayed value can preserve today’s appearance while removing future recalculation. Our file-output acceptance reference covers checking the actual delivered copy.

Use the test-data reference to build a small controlled example with leading zeros, ambiguous dates and explicit missing values. Passing that example checks the specified cases. It does not prove the full workbook is clean; retain the output comparison and unresolved exceptions for the real acceptance decision.