Combine Several Bank Statements into One Spreadsheet
A year of statements is twelve PDFs, and most questions about your money need them all in one place. Here is a tidy way to build a single transaction list from many statements.
Your file is never uploaded. RowSmith reads text-based PDF statements in your browser. Scanned PDFs aren't supported yet. Always review the rows before you use them.
Open the free statement converter
Steps
- Convert each statement PDF to CSV, one file per month.
- Name each file by account and month, such as savings-2026-03.csv.
- Open the free Merge and clean CSV tool and add all the files.
- Remove duplicate rows, then download one combined file.
Good to know
Overlapping periods
Statement periods don't always match calendar months, and a transaction near the cut-off can appear on two statements. After merging, sort by date and look at the boundary days, or let the duplicate check flag identical rows.
Add a source column
When you combine several accounts, add a column naming the account before merging. Later you can filter or build a pivot table by account without guessing where a row came from.
One file at a time today
The free converter handles one statement at a time. To join the converted files into one, use the merge tool.
Questions
Will the running balance still make sense?
Within each month it will. Across a merged file of several accounts, the balance column mixes accounts, so you may want to drop it.
Is there a limit on how many files I can merge?
The merge runs in your browser, so it depends on your device. A year of monthly files is fine on a typical laptop.
This guide was written with AI assistance and reviewed against the converter's behaviour. Always review your output before using it.
RowSmith is an independent tool and is not affiliated with any bank or software company.
Converting is free. RowSmith Pro ($9/month or $59/year) adds suggested Schedule C categories, saved cleanup rules and monthly category totals.