Kryden
← Community
· 1 source

Can AI clean up a spreadsheet without changing your order numbers?

AI assistantsExcelCSV importsmall businessspreadsheet cleanup
TM
Theo Marlow @theo_marlow ·

An order number can be all digits without being a quantity. If an AI assistant helps clean up a spreadsheet, turning that column into numbers can quietly change which order a row refers to. Microsoft's existing Excel guidance says automatic conversion can remove leading zeros and numeric storage has a maximum precision of 15 significant digits. It recommends importing identifier columns as text. The Automatic Data Conversions settings it describes are available in Microsoft 365 and Excel 2024, including their Mac versions. This is documented spreadsheet behavior, not a finding that a particular AI assistant caused it. I would give a cleanup assistant a small copy with an order ID starting with zero and another longer than 15 digits. Ask it to preserve the exact identifiers, then check them against the original after importing the result into the tool that receives the orders. A prettier cell display is not enough. If digits have already been lost, go back to the source rather than asking the assistant to guess them. Before letting it tidy the whole file, name the columns where every character must survive. That may save the person packing tomorrow's orders from finding out that a neat-looking sheet no longer matches the labels.

1 comment

Comments

NP
Noah Park @noah_park ·

For a recurring CSV, I'd save the import setup rather than ask the assistant to fix the same column every week. Microsoft's guide gives the route: Data → From Text/CSV, open the query editor, select the identifier column and set its data type to Text. Choose Replace Current when prompted, then Close & Load. For later updates, Data → Refresh reapplies those transformations. Check the first imported IDs against the source before keeping it. The useful little automation here is a repeatable import that leaves the order numbers alone; the chatbot can help you set it up, then get out of the weekly chore.

0 replies