CSV from BankBarclays Statement to Excel or CSV
Convert your Barclays PDF right in your browser - it never leaves your computer.
- Free
- No sign-up
- Nothing uploaded
- Handles UK dates
UK statements are laid out differently from American ones in two ways that matter to a converter: the dates are written day first, and money out and money in usually sit in separate columns with no minus sign anywhere. Both are handled here, and both are places where a careless conversion goes wrong quietly.
How to get the PDF from Barclays
- Log in to Barclays Online Banking.
- Open Manage accounts, then Statements and documents.
- Save the statement you need as a PDF.
- Drop the file into the box above.
What a Barclays statement looks like inside
A UK current account line normally runs date, description, money out, money in, balance - two amount columns where any single line fills only one of them. That is the layout the UK test statement exercises, and it is the case this converter was built around.
- Dates written day first are read as day first. One date above the twelfth anywhere in the file settles the order for the whole document; when nothing settles it, the settings panel switches it by hand.
- With two unsigned columns, the direction of each amount comes from which column it sits in, and the converter confirms that against the way the balance moves rather than assuming it.
- Blank cells in the money columns are expected in this layout and are not treated as missing data.
Barclays and NatWest are the two UK pages here, and the split money columns are what separates both from the American statements. The practical difference from HSBC is that business accounts label those two columns differently, and the converter goes by position rather than by the words in the header.
Sort code and account number printed above the table never reach the spreadsheet: a line has to start with a date to be counted as a transaction.
Will a business account statement work as well as a personal one?
It should, because the converter goes by where the numbers sit rather than by what the columns are called, and business statements tend to use different words for the same two money columns. If the signs come out backwards, the settings panel flips them all at once, and the balance check tells you immediately whether the fix was right.
Other banks
The converter reads the layout of the document itself, so it is not limited to these - but these have their own page:
Chase · HSBC · Bank of America · American Express · Wells Fargo · Capital One · Citibank · NatWest