Convert Barclays bank statement to Excel
Upload the statement PDF and download an Excel file with one transaction per row: date, description and amount in separate columns (and the balance, when the statement shows it).
Secure
Your bank statements aren't shared with anyone and are encrypted in transit. Password-protected PDFs open in your browser. How we handle your files
Built for firms
For accountants and bookkeepers who reconcile accounts every month: one transaction per row and the same columns every time.
Accurate
We keep improving how each bank converts. If a file doesn't convert the way you expected, email us at support@extractpro.app and we'll fix it.
How do you convert your Barclays bank statement to Excel?
With ExtractPro, a Barclays statement saved from Online Banking or the Barclays app becomes an Excel file (.xlsx): each transaction is one row, and its date, description and amount have columns of their own (the balance too, when the statement shows it). Barclays says “You can save your statement by selecting the PDF icon in the toolbar or under the ‘File’ menu.” Barclays Bank UK PLC is at barclays.co.uk.
How to download your Barclays statement from Statements and documents in Online Banking
- Log into Online Banking.
- Select Manage accounts, then Statements and documents.
- Select the statement to view, download and print it.
- Save it by selecting the PDF icon in the toolbar or under the File menu.
- Or open the app, tap Help/More and choose Statements.
“In Online Banking, select ‘Manage accounts’, then ‘Statements and documents’.”
Step-by-step guide: How to download a Barclays bank statement
How it works
3 steps, in seconds
Download the statement
Get the statement for the period from Barclays; if it comes as a PDF, that is the file to upload.
Upload it to ExtractPro
If the PDF is password-protected, enter the password and the file unlocks in your browser. The password never reaches our servers.
Download the Excel file
One transaction per row, with date, description and amount in separate columns (and the balance, when the statement shows it).
FAQ
About Barclays statements
01Does ExtractPro accept a Barclays statement saved from Online Banking?
Does ExtractPro accept a Barclays statement saved from Online Banking?
Yes. Open the Barclays statement under Statements and documents, save it with the PDF icon and upload the saved file. What comes back is a spreadsheet with a row for each transaction.
02How long does Barclays keep online statements available?
How long does Barclays keep online statements available?
Barclays says “If you receive Online Statements, you can view them online for up to 7 years, as long as the account is still open.” For an account that has been closed it says “If you've closed an account, but still bank with us, statements for that account will be available for up to 5 years.”
03Where do Barclays statements start, and where are they listed?
Where do Barclays statements start, and where are they listed?
Barclays says “We have automatically uploaded electronic copies of your statements from July 2013.” On the web they are listed under your profile: “Under your profile, go to ‘My Barclays documents’”.
Your Barclays statement, in Excel
Free during launch. Upload the PDF and download the Excel file.
Convert my statementOther banks in the United Kingdom