Convert a Barclays PDF statement to Excel

Drop your Barclays PDF below and get a real Excel workbook rather than a CSV renamed — frozen header row, filters on every column, currency formatting and a totals row. Your statement never leaves your computer.

Barclays is one of only two layouts checked against a real statement rather than a synthetic test file — see the notes below for what that covered.

Drop your statement here

or choose a file — nothing is uploaded

What you get

The download is a .xlsx file with these columns, in this order:

  1. Date
  2. Description
  3. Money Out
  4. Money In
  5. Amount
  6. Balance

Worth knowing. The Balance column only appears when your statement actually printed a running balance. If your bank does not print one, the workbook comes out without it rather than with an empty column.

How to download your Barclays statement as a PDF

  1. Log in to Barclays online banking (or the Barclays app).
  2. Select the account you need, then open its statements or documents section.
  3. Pick the statement period you want.
  4. Choose the option to download or save as PDF — not "print".

Banking apps rename their menus from time to time, so the exact wording may differ slightly. You are looking for the original PDF statement rather than a printout or a screenshot — a printed copy sometimes loses the table structure the converter reads.

How to open it in Excel

  1. Download the .xlsx file.
  2. Open it in Excel, Numbers, LibreOffice or Google Sheets — no import wizard, it opens directly.
  3. The header row is frozen and filters are already on, so you can sort and filter straight away.

Notes for Barclays statements

Barclays prints separate "Paid out" and "Paid in" columns. This is one of only two layouts checked against a real statement — a 12-page file of 193 transactions, where every printed balance reconciled exactly. Barclays prints a balance once a day rather than on every row, so most transactions fall inside a checked range and the rest are marked as unverified in the results.

Why the conversion happens in your browser

A bank statement lists your income, your address, your spending and your account number. Most converters ask you to upload that to their servers and keep it there. This one reads the file locally instead, so there is no copy of your statement anywhere but your own machine — and nothing that can be breached later.

Common questions

Is this a real Excel file or a renamed CSV?

A real .xlsx workbook. It carries formatting a CSV cannot hold — column widths, a frozen header, autofilters, currency number formats and a totals row.

Will it open in Google Sheets or Numbers?

Yes. The .xlsx format is read by Google Sheets, Apple Numbers and LibreOffice as well as Excel.

Is my Barclays statement uploaded to convert it?

No. The PDF is read by JavaScript running in your own browser, and there is no endpoint on this site that can receive it. You can watch your browser's network tab while it converts and see that nothing carrying the file leaves.

How do I know the figures are right before I import them?

Where your Barclays statement prints a running balance, every amount is re-checked against it and you are told how many rows that covered. Anything that could not be read safely is listed separately and left out of the file rather than guessed at. Check both before importing into Microsoft Excel.

What does it cost?

One page credit converts one page, and five are free on your first visit. If a statement is longer than your balance covers, the opening pages convert free as a preview so you can see whether it reads your layout before paying. Nothing is charged when a conversion fails.

Other formats for a Barclays statement

Excel imports for other banks

Every bank and format →

Simple pricing

One credit converts one page, so you pay for what you actually convert — a two-page statement costs two. Five credits are yours to start with.

Free

£0

  • 5 page credits to start
  • Full export, every format
  • No account needed

Enough to check a short statement end to end.

Most popular

Page credits

£9.99

  • 50 page credits
  • Credits never expire
  • One-off — nothing recurring

About four twelve-page statements.

Pro

£24.99/mo

  • 500 page credits a month
  • Tops up automatically
  • Cancel anytime

For bookkeepers running client statements monthly.