Bank statements

Barclays statement to CSV: turn a UK statement into a clean sheet

How to get a Barclays statement into CSV or a spreadsheet: look for the bank's own export first, else convert the PDF, then clean it with a few formulas.

Editorial illustration for Barclays statement to CSV: turn a UK statement into a clean sheet

To get a Barclays statement into CSV, first look for a download or export option on the statement screen of your own online banking; if it offers CSV or Excel, use that because it avoids reading a PDF at all. If it only offers PDF, convert the PDF to a sheet and clean the columns before you add anything up. Screens differ by account type and change over time, so follow what your own account shows.

What are the steps from statement to sheet?

  1. Sign in on the bank's official site or app and open the statements or transactions area.
  2. Pick the date range you need and look for a download or export choice.
  3. Prefer CSV or Excel if offered. Otherwise download the PDF.
  4. Open the file in Excel or Google Sheets. For a PDF, use a converter you trust or copy the table across.
  5. Check opening balance, total money in, total money out and closing balance against the statement.

Never put your banking login into a third-party converter. A converter only needs the file.

What does a messy export look like and how do I fix it?

A typical statement has a date, a description, an amount going out, an amount coming in and a running balance, though your own file may differ. For sums you want one signed column. Say money out is in D and money in is in E, with the first row at line 2, then in F2 type =IF(D2<>"", -D2, E2) and fill down. Spending is now negative, income positive.

DateDescriptionOutInSigned amount
03/06/2025Supermarket£62.40--£62.40
04/06/2025Salary-£1,950.00£1,950.00
06/06/2025Rail season ticket£148.00--£148.00
09/06/2025Cinema£24.50--£24.50

The rows are made up. A quick total of the four signed amounts is 1,950.00 - 62.40 - 148.00 - 24.50 = £1,715.10, which should equal the change in balance over those rows.

How do I add a category column and total by month?

Add a category in column G by hand or with a lookup. Then, to total grocery spending between two dates held in J1 and J2, use =SUMIFS($F$2:$F$500, $G$2:$G$500, "Groceries", $A$2:$A$500, ">="&$J$1, $A$2:$A$500, "<="&$J$2). This only works when column A holds real dates. If the dates are text, Sheets will not compare them properly.

  • Keep dates in one format and check the first and last rows after import.
  • Sort by date, and watch that card payments pending on the last day do not appear twice.
  • Keep a copy of the untouched original file so you can always return to it.

Can a sheet do everything?

For one account and a few months, yes. When you have several accounts, years of files or want categories to be applied automatically, a sheet gets heavy. SpendixAI imports statements as PDF, CSV or Excel and lets you review rows before saving. It is built around India and the rupee, so check that it suits your situation before relying on it for pounds. The base currency has to be chosen before the first import and cannot be changed later.

What if the CSV opens with merged columns or odd characters?

A comma inside a description can split one column into two, and a spreadsheet can reinterpret dates into another style or strip the zeros from a reference number. Use the sheet's import tool for text files rather than double-clicking, choose the right separator, and mark reference columns as text.

  • Open the file in a plain text editor first to see what the raw rows look like.
  • If dates came in month-first when the file is day-first, re-import with the date format set for the column.
  • Keep reference numbers as text, so leading zeros survive.

Checklist for each month

  • Export the same period every time, from the first to the last day.
  • Keep the original file and a cleaned copy.
  • Reconcile the closing balance.
  • Note one-off items such as annual payments so they do not distort monthly averages.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports