Question
Closed · Answered

How can I keep Buda’s spreadsheet cleanup from changing valid data?

Leonard Li

I want to use Buda to clean a spreadsheet that contains duplicate rows and inconsistent formatting. Some columns contain product codes with leading zeros, which need to stay exactly as written.

How should I define the cleanup rules so those codes are preserved? Can I ask for a separate cleaned file and a summary of the changes, while keeping the original untouched?

Report
Kelly
Team

Yes. Keep the original spreadsheet untouched, and ask Buda for a separate cleaned file plus a summary of the changes. In the cleanup rules, say that product-code columns must stay exactly as written: treat them as text, and do not strip leading zeros.

Diagram · Keep the original, preserve codes as text, and review the summary

How to define the rules

When you start the task, attach the spreadsheet and include rules such as:

  • Do not overwrite the original file. Write the cleaned result to a new file.
  • After cleaning, give me a summary of what changed (for example which duplicate rows were removed, and which formatting was standardized).
  • Product code columns must stay exactly as written. Treat them as text, not as numbers, and do not remove leading zeros.
  • Only apply the other cleanup (duplicates and inconsistent formatting) to the columns I named.

If a rule is only “clean the sheet” without calling out those codes, they can be converted to numbers and lose the leading zeros.

How to verify

  • Confirm the original file is still unchanged.
  • Open the cleaned file and check several product codes that had leading zeros — they should still be there.
  • Read the change summary and confirm it does not list those codes as reformatted numbers.
  • Spot-check a few duplicate or formatting fixes to be sure those intended changes did happen.

If a product code was changed, stop and correct the rule before accepting the cleaned file.

Boundaries

  • A change summary is not a substitute for opening the two files and checking the codes yourself.
  • If the spreadsheet program previews a code as a number, still confirm the saved value includes the leading zeros.
  • Work on a copy for the cleanup task even if you already have a backup elsewhere.

Example goal for an Agent

Clean this spreadsheet into a new file. Do not change the original. Remove duplicate rows and standardize the formatting I listed, but keep every product code exactly as written, including leading zeros, treating those columns as text. Then give me a summary of the changes.
Report

Your reply

Sign in to join the discussion. Reading is always open; you only need an account to post.

Sign in