Save the steps once. Run them on next week's file.
Every fix you make in the Data Workspace becomes a step. Save the steps as a workflow, and next week's file takes one click — after Rote Workspace has checked that every column the steps need is still there.
No sign-up · No credit card · Nothing to install
Open → Clean → Save → Reuse
Do the work once. Save it. Repeat it.
Most file cleaning is the same handful of fixes, every week, on a new file. RoteRun remembers the fixes as a workflow, so you only make them once.
- 01OpenOpen a CSV or an Excel workbook. Its rows, columns, separator and encoding are read for you, and its problems listed.
- 02CleanFix what is wrong — blank rows, duplicates, spaces, dates, column names. See every change before you download.
- 03SaveEvery fix is a step. Save the steps as a workflow: the sequence, never the file.
- 04ReuseNext week, open the new file and run the workflow. It checks the columns first, then does the same work again.
What a workflow records
- 1Trim spacesEvery column
- 2Remove empty rowsAll columns blank
- 3Find duplicatesWhole row must match
- 4Tidy headerscust_name → Customer
Open next week's file, run this workflow, and the same four steps run again.
Already use Power Query?
Both repeat a cleanup on next week's file, and each suits different jobs. See how Rote Workspace and Power Query compare.
What it does, in detail
Every fix is a step
- Steps listed in the order they run
- What each step did to this file: “3 cells changed”, “2 rows removed”
- Move, edit or remove any step
- Add any of 20 actions from a list
Save and share
- Save in this browser
- Download as a small .json file — steps only, never data
- Import a workflow file
- My workflows lists everything you saved
Checked before it runs
- Every column a step names must exist at that step
- Renames by earlier steps are followed
- A missing column blocks Run and names the step
- A workbook's sheet remembered by name
Rote AssistantLaunching soon
Rote Assistant runs saved jobs on a schedule or when a file lands in a folder, and stops before writing anything when the columns change.
Explore Rote Assistant →Start cleaning in the next ten seconds.
Open Rote Workspace and try it on the sample file, or on your own. No sign-up, no credit card.