Fix the things that are always wrong.
Rote reads the file's rows, columns, encoding and delimiter for you, then gives you the operations you would otherwise do by hand — with a preview before anything is written.
For example
Four problems every hand-made export has.
Trailing spaces you cannot see, a blank row, the same order twice, and a column named for a database rather than a person. Here is that file, and the same file after a job runs.
Before
| order_id | cust_name· | amount |
|---|---|---|
| 10431 | ··Northgate Supply· | 4820.00 |
| 10432 | Bell & Rowe | 3275.50 |
| — | — | — |
| 10432 | Bell & Rowe | 3275.50 |
Saved job
- 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.
After
| Order ID | Customer | Amount |
|---|---|---|
| 10431 | Northgate Supply | 4820.00 |
| 10432 | Bell & Rowe | 3275.50 |
· marks a space you would not otherwise see. The red row is blank in every column. Nothing here is edited by hand — it is the four steps below, run in order.
Everything you can do to a file
- Open a CSV and see rows, columns, encoding and delimiter
- Find empty rows
- Remove selected rows
- Find duplicates
- Rename columns
- Delete columns
- Create a column with a default value
- Reorder columns
- Sort by several fields at once
- Filter rows
- Change values by rule — trim, replace, change case
- Preview every change before writing
- Export a cleaned CSV
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.