# Free PDF to Excel Converter UK: Pounds, Dates and GDPR

- Author: CheapBankConvert (https://cheapbankconvert.com)
- Published: 2026-10-17
- Category: Free vs paid converters
- Canonical: https://cheapbankconvert.com/blog/free-pdf-to-excel-converter-uk

> A free PDF to Excel converter for UK statements must read pound signs and day-first dates. See what breaks, what GDPR asks, and what paying costs.
A free PDF to Excel converter can handle a UK bank statement, but check three things in the result: the pound sign must not turn amounts into text, day-first dates must not flip into American order, and paid in and paid out columns must keep their signs. Under UK GDPR, you also keep rights over the uploaded file.

## Can a free PDF to Excel converter read UK statements?

A free PDF to Excel converter reads a UK statement the same way it reads any PDF: it finds the text and guesses where the columns are. The layout is rarely the problem. The trouble starts afterwards, when Excel interprets the pound signs, the dates and the debit and credit columns using settings that may not match a British file.

Most free converters are built for a general audience. They pull text into cells and leave the meaning to Excel. That works for a table of names. For a statement it means three questions decide whether the file is usable:

- **Are the amounts numbers?** A cell showing £1,250.00 may be stored as text, so it will not add up.
- **Are the dates right?** 03/04/2026 means 3 April in the UK and March 4 in the US.
- **Is each amount the right way round?** UK statements often print money in and money out in separate columns, and a free converter may merge them.

None of these shows up as an error message. The sheet looks fine until a total is wrong. The steps for a general free conversion are in the guide to [converting a PDF to an Excel spreadsheet free](/blog/convert-pdf-to-excel-spreadsheet-free). This post covers what is different about a British statement.

## Pound signs and comma thousands in a UK Excel export

A pound sign in front of an amount can make Excel store the cell as text, especially if your copy of Excel is set to a US region or the sign came through as an odd character. A text amount looks right on screen, but a SUM formula skips it, so your total comes out low or as zero.

You can test a column in a few seconds. Select the amounts and look at the status bar at the bottom of the window. If it shows a Sum, the cells are numbers. If it shows only a Count, at least some are text. Numbers also sit to the right of a cell by default, and text to the left.

To fix a text column:

1. Select the column and use Find and Replace to replace £ with nothing.
2. Replace any spaces between the sign and the number in the same way.
3. Use Data, then Text to Columns, and finish the wizard without changing anything. Excel converts the cleaned text to numbers.
4. Format the column as Currency with the £ symbol, so the sign is shown but not stored.

Comma thousands separators, as in 1,250.00, are the same in the UK and the US, so they rarely cause trouble on their own. The problem appears if your Windows region uses a comma for decimals, as many European settings do. Then 1,250.00 can be read as text, or as 1.25. If you share files with colleagues abroad, check the region setting before blaming the converter.

## Day-first UK dates that Excel turns into American ones

Day-first UK dates go wrong when Excel reads them as month first. A transaction on 3 April becomes 4 March, and a date like 25/04 cannot be read as a month at all, so it stays as text. The result is a column where some dates are swapped and some are not dates.

The mix is the dangerous part. Days 1 to 12 convert quietly into the wrong date, while days 13 to 31 stay as text. If you sort by date, the swapped rows move to the wrong month and the text rows sort to the end. A monthly total built on that column will be wrong with no warning.

Two ways to fix it:

- **Import with the right order.** If you open a CSV, use Data, then From Text/CSV, and set the file origin or locale to English (United Kingdom). Excel then reads 03/04 as 3 April.
- **Repair an existing column.** Select the date column, open Text to Columns, choose Delimited, then on the last step set the column data format to Date with the order DMY. This works on text dates. Dates already swapped into real values must be converted again from the source.

Check the result against the statement. Pick a row near the middle of the month, such as the 20th, and one early in the month, such as the 5th, and confirm both. If both match the PDF, the column is safe.

A CSV file can carry the same problem into any app that imports it. The post on the [best PDF to CSV converter](/blog/best-pdf-to-csv-converter) includes a date check to run on a CSV before an import.

## What does UK GDPR mean for uploading a bank statement?

UK GDPR applies to personal data, which the ICO defines as information that relates to an identified or identifiable person. A bank statement with your name, address and spending fits that easily. So the converter that receives it must handle it lawfully, and you keep rights over it, including asking for it to be erased.

The [ICO's guide to what personal information is](https://ico.org.uk/for-organisations/uk-gdpr-guidance-and-resources/personal-information-what-is-it/what-is-personal-information-a-guide/) explains that a person can be identified directly, by a name, or indirectly, by putting several details together. A statement contains both kinds.

One right is especially useful after a conversion. The [ICO's page on the right to erasure](https://ico.org.uk/for-organisations/uk-gdpr-guidance-and-resources/individual-rights/individual-rights/right-to-erasure/) says you can ask for your data to be erased verbally or in writing, and the organisation should answer without undue delay and at the latest within one month. The right is not absolute, so a request can be refused in some cases.

What this means in practice:

- **Read the privacy notice first.** Look for who runs the site, where files are stored, and how long they are kept.
- **Prefer tools that delete files soon after.** A clear deletion period is better than a vague promise.
- **Know who to ask.** If the notice names no contact for data requests, treat that as a warning.

A free site that funds itself from your data is a poor fit for a statement. Strip the account number from the PDF if the tool lets you, or use a tool that keeps the file on your own computer.

## UK statement edge case: paid in, paid out, CR and DR

UK statements often show money in two columns, headed Paid in and Paid out, or mark each amount with CR for credit and DR for debit. A free converter may copy both columns as positive numbers, or drop the CR and DR letters, which leaves you unable to tell a refund from a payment.

Here is how common UK features fare in a free conversion, with example values.

| UK statement feature | Example on the PDF | What a free converter may produce | Fix in Excel |
| --- | --- | --- | --- |
| Pound sign | £1,250.00 | Text, not a number | Replace £ with nothing, then Text to Columns |
| Day-first date | 03/04/2026 | 4 March 2026, or text | Import with UK locale, or Text to Columns with DMY |
| Paid in and Paid out columns | 450.00 under Paid in | Two positive columns, or one merged column | New column: paid in minus paid out |
| CR and DR suffix | 120.00 DR | "120.00 DR" as text | Split the letters off, make DR rows negative |
| Balance with OD | 85.40 OD | Text | Make OD balances negative |

The fix for separate columns is one formula. Put paid in in column C and paid out in column D, then a new column with =C2-D2 gives a single signed amount. Fill it down and check that a known purchase shows as negative.

CR and DR need one extra step. Split the letters into their own column with Text to Columns, then use a formula that makes the amount negative where the letter is DR. Once the signs are right, the running balance can be checked row by row.

## What paying costs for a UK statement conversion

Paying for a UK statement conversion costs whatever the tool charges, plus any fee your card adds if the price is in another currency. A tool priced in dollars is charged to a UK card in pounds at your card provider's exchange rate, and some cards add a foreign transaction fee on top.

CheapBankConvert prices in dollars on its homepage. At early pricing, a statement of up to 10 pages costs $2.99 and one of 11 to 40 pages costs $5.99, paid once with no subscription. A statement of 2 pages or fewer converts free. Your card statement will show the amount in pounds, set by your card's rate on the day.

CheapBankConvert reads the layout of a statement rather than working from a list of banks. That is not a promise about any particular UK bank, so check the free preview of the first 2 pages, and look at the date column and the signs before you pay. CheapBankConvert is getting ready to open; [Get started](/get-started) takes your email so you hear when it does.

Compare that with a subscription. A monthly converter plan priced in pounds costs the same every month whether or not you convert anything. If you need a statement a few times a year, paying per file is usually cheaper. If you avoid subscriptions on purpose, the post on [using Excel without a subscription](/blog/excel-without-subscription) covers the spreadsheet side of the same choice.

Free tools that bill after a trial are a separate risk. The guide to [converting PDF to Excel free with no trial](/blog/convert-pdf-to-excel-free-no-trial) shows how to spot one before you hand over a card.

## Checklist for a free UK statement conversion in Excel

A free UK statement conversion is ready to use once the amounts add up, the dates match the PDF, and the money in and out carry the right signs. Work through these checks in order, since each one depends on the one before.

1. **Read the privacy notice** of the converter before uploading, and note how long files are kept.
2. **Count the rows.** Compare the number of transactions in Excel with the number on the statement.
3. **Check the amounts are numbers.** Select the amount column and confirm the status bar shows a Sum.
4. **Check two dates.** One before the 13th of a month and one after, against the PDF.
5. **Check the signs.** A purchase should be negative and a deposit positive, whatever the source columns were called.
6. **Tie out the balance.** Opening balance plus the sum of amounts should equal the closing balance on the statement.
7. **Delete the uploaded file** if the site offers that, or ask the operator to erase it.

If the sheet fails step 4 or step 6 and you cannot see why, convert again with a different tool rather than patching. A file that is wrong in several places will take longer to repair than to redo.