Netmend

Netmend · Bank statement → CSV · Barclays

Convert a Barclays UK statement PDF to CSV or Excel

Barclays gives you official PDF statements and a separate CSV export of account transactions. Use the CSV when you can. This page shows both paths and the PDF columns for when the export does not cover the period you need.

United Kingdom (Barclays UK)100% in your browserNo accountFrom $20 if you want it done

Convert a Barclays PDF now

The defaults below are set for a typical Barclays file. You can still change them. The file never leaves your computer.

No statement at hand? (fictional data)

How it stays private: the page uses the open-source pdf.js library (Mozilla) to read the file locally. There is no server and no upload. You can disconnect from the internet after the page loads and it still works.

The Barclays statement format

DatesPDF statement dates are typically DD/MM/YYYY. Some on-screen or older exports show a date as “DD Mon” without a year — add the year from the statement period before you import across a New Year boundary.
NumbersUK format: 1,234.56. Choose UK/US numbers and a comma CSV (or “Excel in Europe” if your copy of Excel uses a decimal comma).
RegionUnited Kingdom (Barclays UK)

Where to download the official file

Official PDF statements, from Barclays Help (“How can I view Online Statements?”):
  1. In the Barclays app: Help/More on the home page, then Statements.
  2. In Online Banking: under your name, open Online Statements, choose the account, and download the PDF. Statements from July 2013 onwards are in the archive if you registered in time; they also sit in My Barclays documents / Cloud It.

For a spreadsheet of recent transactions (not the official monthly statement): open the account’s transactions, set a date range, then use Export All and choose CSV. That file is the one to import into Excel or accounting software when the period is still available.

What the PDF contains

A typical Barclays UK current-account PDF lists Date, Description, Paid In, Paid Out and Balance. Only one of Paid In or Paid Out is filled on each row. Payment references can wrap onto a second line under the same date.

Official CSV or Excel, when the bank offers one

The official statement is a PDF. The transaction CSV typically has Date, Description, Paid In, Paid Out and Balance. Prefer that official CSV. Use our converter for older PDF statements, or for PDFs someone emailed you.

What to watch for

Sources (checked 12/11/2026). Barclays Help, “How can I view Online Statements?” (barclays.co.uk), checked 12/11/2026. CSV/PDF column notes (Date, Description, Paid In, Paid Out, Balance) from current UK layouts the same day. Banks change layouts without notice: treat the first row of your own file as the authority.

Need it done for you? From $20

The free tool is for a clean, text-based PDF. For scans, password files, a packed year of statements or a layout that has to match your accounting software, we convert them and check every total against the opening and closing balance.

Done-for-you conversion
$20 / 20 pages

75 pages $40 · 200 pages $80. Totals reconciled. 48h. Pay on Fiverr.

Need it done for you? From $20
Privacy

Your statement is processed only for the order and deleted after delivery. This page itself never uploads the file.

Who handles the data: Pedro Carvalho (Netmend), dayinportugal@gmail.com. No address, phone or national ID is asked for or published.

FAQ

Can I download a CSV from Barclays?

Yes, from the account’s transaction list (Export All), for a date range the bank still offers. Official monthly statements remain PDFs.

Paid In and Paid Out vs one Amount column?

The bank uses two columns. Our tool outputs a single signed Amount (money out negative) plus Balance. You can split it back in Excel if you prefer.

Does this cover Barclays in Africa or the US?

No. Those are different banks and layouts. Check a date after the 12th and a known amount.

Other bank guides

Excel formula translator · Testimonial wall · Pinterest pin maker · All Netmend services