Cleaning a folder of exports the same way, every month
Apply one set of cleaning steps to many files at once, download them as a ZIP, and save the steps as a workflow for next time.
Monthly exports from the same system usually have the same problems: stray spaces, a blank line at the end, dates in a local format. Fixing each file by hand is slow and easy to get slightly different every time. Batch cleaning applies exactly the same steps to every file.
1. Load the files together
Drop several CSV or Excel files on the cleaner (the free plan takes 3 at once; paid plans take more). Choose Batch: clean each file separately. Merge is the other option, for stacking files into one table.
2. Build the steps on one file
Pick any file to preview. Every change is highlighted, removed rows are listed with the reason, and the batch table above the preview shows rows in and out for every file, so you can spot a file that behaves differently before downloading.
3. Download a ZIP
All files → ZIP of CSVs (or of XLSX) builds one archive in your browser with a cleaned file per input, named after the original with -clean added. Nothing is uploaded to build it. If you prefer one workbook, All files → one XLSX puts each file on its own sheet.
4. Save the steps as a workflow
Give the steps a name and save them. Next month, load the new exports and apply the workflow in one click. Workflows are lists of steps, not data. You can export one as a JSON file to share it with a colleague, or (on Pro and Business) save it to your account so it follows you between computers and, on Business, your team.
What a workflow contains
The settings you typed into steps are stored as typed: column names, find & replace text, separators. Keep find & replace values short and generic (N/A, -); they are limited to 1 KB so a workflow never becomes a place where data is stored.