Let the model suggest changes while the workbook stays under control

For price lists and registries, AI can help interpret inconsistent text: normalise names, classify products or flag likely typos. Risk begins when a model directly rewrites the working workbook. A shifted row or overwritten formula can turn a few saved minutes into a silent accounting error.

Create a copy, send only the necessary columns and request a change table: row ID, original value, proposed value, change type and explanation. Do not let the model invent identifiers or edit adjacent rows.

Validate values before writing them

Check field types and business reference data. A price must remain numeric in the correct currency, an SKU must match the accepted format, and a unit of measure must exist in the reference list. Route discrepancies to the employee who approves changes. After approval, create a new workbook version and retain an audit trail: who accepted the change, when and why.

In XLSX, a formula is stored separately from its cached result. The cache reflects the last calculation and may be stale after a library changes the workbook. A value visible in the file therefore does not prove that the formula was recalculated.

A pilot sequence

1. Choose one workbook and task, such as classification or description normalisation.
2. Record manual corrections and time per row.
3. Process a copy with no write access to the original.
4. Validate the schema, types, required fields and formulas.
5. Check the result in Excel or LibreOffice as used by employees.
6. Publish a new version only after human approval.

Use a spreadsheet calculation engine for formulas and totals, not a language model. If validation rules are undefined, even a local model can confidently suggest incorrect changes.

What to measure

Compare time per accepted row, the share of proposals needing no edits, affected formulas and total errors. Separate routine records from rare exceptions. Scale only the data class where quality is repeatable and an approval owner has been assigned.