A job is the sequence, not the file.
Save the steps you took and run them on next month's file. Rote checks the columns still match before it does anything, and stops rather than guessing if they do not.
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. Rote remembers the fixes so you only make them once.
- 01OpenOpen a CSV. Rote reads the rows, columns, encoding and delimiter for you.
- 02CleanFix what is wrong — blank rows, duplicates, column names, order. See every change before it is written.
- 03SaveSave the steps you took as a job. It remembers the sequence, not the file.
- 04ReuseNext week, open the new file and run the job. The same work, without doing it again.
What a job records
The sequence, not the file
A job holds the operations you performed, in order. It is not tied to the file you performed them on.
It stops rather than guesses
Before a job runs, Rote checks the incoming file still has the columns the steps refer to. If one has been renamed or is missing, it says so and stops.
- 1Change valuesTrim spaces — every column
- 2Remove empty rowsAll columns blank
- 3Remove duplicatesWhole row must match
- 4Rename columncust_name → Customer
Open next week's file, pick this job, and the same four steps run again.
Planned — not built yet
- Folder triggers
- Scheduling
- Batch processing
- Run history
- Failure notifications
- Schema and change detection
- Excel files (XLSX)
- Command line
- Email, Slack, Teams and webhooks
Be first to use Rote.
Rote is in development. Join the wishlist and we'll let you know when the beta is ready. If there is something you need it to do, ask.