Merge two or three files into one.
Monthly exports, or the same report from different systems, rarely agree on their columns. Rote Workspace matches columns by name, suggests near matches, and shows exactly what the merged file will hold before you download it.
No sign-up · No credit card · Nothing to install
Column mapping
When two files disagree on a name.
January calls it cust_name, February calls it Customer. Pair them in the merge, 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 |
A column only some files have is kept, with blanks where a file lacks it — nothing disappears without you seeing it.
What it does, in detail
Choose files
- 2 or 3 files, up to 50 MB each and 100 MB together
- CSV files or Excel worksheets — even several sheets of one workbook
- Move, replace or remove a file at any time
Match columns
- Matched by exact name — never by position, never by guess
- Near matches (capitals, spaces) suggested, never applied for you
- Send any column into another, or keep it on its own
- Rename the output columns
Review and download
- Exact counts: rows per file, rows and columns in total
- A preview, 100 rows a page, with each row's source file
- File 1's rows, then file 2's, then file 3's — none changed or dropped
- An optional column naming each row's source file
Rote AssistantLaunching soon
Rote Assistant combines every file in a folder that matches a name rule — and can do it on a schedule.
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.