Merge CSV files and save them as an Excel workbook
Opening a CSV directly in Excel can mangle leading zeros and leave figures stored as text. Downloading the merged result as an .xlsx workbook gives you a proper spreadsheet file instead, with cleaned amounts already stored as numbers.
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
- Drop your CSV files into the tool.
- Set Amounts to one of the Tidy options so amount columns are converted.
- Set Output to XLSX.
- Review the preview and the summary counts.
- Click Download and open the workbook in Excel or another spreadsheet program.
Good to know
Amounts become number cells
Cleaned values in amount columns are written as numbers, so SUM and pivot tables work straight away and you avoid the green warning triangles that text numbers trigger.
Everything else stays text
Dates, descriptions and any amount the tool could not read are written as text, which protects IDs and codes from being reformatted.
Prefer plain text?
Choose CSV instead. The CSV export keeps every value as written, which suits imports into accounting software or scripts.
Questions
Does the workbook have formulas or formatting?
No. It is a plain single-sheet workbook with your merged rows.
Can I open it in LibreOffice?
Yes. It is a standard .xlsx file.
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.