Merge several CSV files into a single file
Monthly exports, one file per account or per store, a folder of reports from the same system: sooner or later you need them as one table. This guide walks through stacking several CSV files into a single download without copying and pasting between windows.
Your file is never uploaded. The PDF is read in your browser and makes no network requests while it works.
Open the Merge & clean CSV tool
Steps
- Open the tool and drop all of your CSV files onto the box at once, or click it and pick several files.
- Check the file list to confirm every file you expected was read.
- Leave Trim spaces and Drop empty rows ticked unless you have a reason not to.
- Tick Add source file column if you want to know which file each row came from.
- Choose CSV or XLSX under Output, review the preview and click Download.
Good to know
Your files stay on your computer
The merge is done by JavaScript running in the open tab. No file is sent to a server, so you can use it for exports you would rather not hand to a website.
Separators are detected
Comma, semicolon, tab and pipe separated files are accepted, including .tsv and .txt exports, so files from different programs can be combined in one pass.
Order of rows
Rows are stacked file by file. If you need them in date order afterwards, sort the merged sheet in your spreadsheet program.
Questions
Is there a limit on how many files I can add?
There is no fixed count in the tool. Very large files depend on the memory available to your browser, so if a tab struggles, merge in smaller batches.
Do I need an account?
No. There is no sign-up, and closing the tab clears everything.
Starting from bank statement PDFs? RowSmith converts text-based PDF statements to CSV or Excel in your browser.
This guide was written with AI assistance and reviewed against the tool's behaviour. Always review your output before using it.