Bills AI

How do I get bank statement transactions from a PDF into Excel or Google Sheets?

Convert the statement PDF to CSV, then open the CSV in Excel or import it into Google Sheets. The free Bills AI converter produces the CSV from text-based PDFs without a signup. It copies dates and amounts exactly as printed, so Excel or Google Sheets may read them differently depending on regional settings. Check a few rows against the statement.

Last reviewed:

Steps

  1. Download the statement from your bank as a PDF whose text can be selected, not a scan.
  2. Convert it with the free converter and download the CSV. The file is written with a UTF-8 byte-order mark so Excel reads accented text correctly.
  3. In Excel, use the Data tab and choose From Text/CSV, then pick the file. In Google Sheets, use File, then Import, then Upload, and choose the CSV.
  4. Look at the date and amount columns. Values are copied as printed, so a decimal comma (1.234,56) or a day-month-year date can be read differently by your spreadsheet's regional settings. Adjust the column format or locale if needed.
  5. Add up the debit and credit columns and compare them with the totals printed on the statement.

When this will not work

  • A statement that is a scan or photo cannot be converted by the free tool.
  • Dates without a year (02 Mar) stay without a year in the CSV. Add the year in your spreadsheet, and take care with statements that cross New Year.
  • Amounts with a currency symbol or a CR suffix are read as text by spreadsheets, so remove the symbol or suffix before summing.
  • If your spreadsheet uses a decimal comma, choose the semicolon delimiter in the converter before converting.

Related

Frequently asked questions

Why do my dates or amounts look wrong in Excel?

The converter copies values exactly as the PDF prints them and does not normalise them. Excel and Google Sheets then apply their own regional settings, which can swap day and month or treat 1.234,56 as text.

Can I convert a statement straight to an .xlsx file?

The free converter produces CSV, which Excel and Google Sheets both open or import. It does not produce .xlsx files.

Do I need an account to convert a statement to CSV?

No. The free converter needs no signup and no AI is used to read the PDF.

More answers