Cleaner Copy
Give it a report. Get back a copy with the same sheets, headings and formulas, and randomized values in the columns you choose.
- Runs in your browser
- Opens no connection
- Keeps nothing afterwards
This tool works in your browser, so it needs scripts turned on. The article explains what it does.
No connection can be opened from this page
Before you start
Three things to know about how this works.
The file stays with you
The page reads the file inside your browser. It cannot open a connection, so it has no way to send the file anywhere.
You choose the columns
You see every column first. Each value is replaced with a random one of the same shape, unless you leave its column alone.
The copy gets checked
When the copy is made, the page searches it for every text it replaced and tells you what it found.
What to keep in mind
- A column you leave alone stays exactly as it is. A notes column can say anything about anyone, so let it be replaced.
- Totals and trends in the copy are randomized along with the values. Use the copy to build a script or a layout, and take your numbers from the real report.
- The page tells you what it replaced and what it could not check. Whether a copy may leave your organization is for whoever is responsible for that to decide.
Choose a file
An Excel workbook (.xlsx or .xlsm) or a CSV file. Nothing is changed in this step.
Drop a workbook or a CSV file here
The sample report is a small clinic workbook with invented patients. It is a good first run.
Choose columns
Every column gets randomized values unless you choose otherwise. A column can also be coded, or left exactly as it is.
Save the copy
The copy is being made.
Making the copy, then searching it for what was replaced.
What a copy is for
Help from an AI assistant
An assistant can write the Excel script or the report layout from a copy that has the same shape as your report.
Testing a script or a bot
Build and test against the copy. Then run the finished script on the real report, on your own computer.
Seeing what a file holds
The second step lists hidden sheets, macros, saved connections and built-in queries in plain words.