Put two to four files together.
Files from different months, or different systems, rarely agree on what a column is called. You pair them up once, and the merge is repeatable from then on.
Column mapping
When two files disagree on a name.
January calls it cust_name, February calls it Customer. You pair them once, and the merged file has one column.
| In january.csv | In february.csv | Merged column |
|---|---|---|
cust_name | Customer | Customer |
amount | Total | Amount |
order_id | order_id | Order ID |
Columns only some files have are kept or dropped — your choice, one at a time, so nothing disappears without you saying so.
What a merge does
Two to four files
Enough to combine a quarter of monthly exports, or the same report from several systems, without turning the screen into a list of files.
Nothing disappears quietly
Columns only some files have are kept or dropped one at a time — your choice — so a column never vanishes because it was missing from one file.
- Merge 2–4 CSV files into one
- Map columns between files that name them differently
- Compare 2–4 CSV files
- List identical records
- List records that differ
- Export the result
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.