How to Import Bank PDF Statements into Microsoft Excel for Free

Here's how to easily convert a PDF of a bank statement into a CSV file that can be opened with Microsoft Excel or Google Sheets.

While most banks now allow importing of bank statements directly into the CSV format, occasionally you may need to convert a PDF of a bank statement into a CSV file that can be opened with Microsoft Excel or Google Sheets.

The following websites can convert PDF files to CSV for free:

Step 1: Converting PDF files to CSV

Step 1a: Using Power Query to import data from a PDF file

Alternatively, on Windows OS, you can directly use Power Query to import data from a PDF file, without having to convert it to a CSV first.  Unfortunately, this option is not available for users on alternative operating systems.

  • Use Data > Get Data > From File > From PDF and click Import.
  • In the Navigator box, click on the desired item and click Transform Data or if it is clean, you can directly Load to > Excel
aPJ3tiXU0OEEYD1f9idqgEzq38p7rk2N1OudELSyGlL MgMRZyJa89cpuEAlmhV8lT0h2JJOT30F2r6x7hqY8M26AeQ9gA7iwYfJDjQVmLpIXL2MKzMRWMPXSroCuwIONq5AUEtR8vOunA5Akl8xomqT7yvHNcnOjE YgF

Source: https://www.excel-university.com/import-pdf-data-into-excel-with-power-query/

Step 2: Cleaning up your bank activity

  • Cleaning up will allow your data to be more concise and easier to read. To clean the bank activity, you will need the Power Query Add-in in Excel. 
  • Open a new window and excel. Click on Data 🡪 Get Data (Power Query)
Graphical user interface, application, table, Excel

Description automatically generated
1kJINdsLX8bcIoDeRB0FtUDGqECtH LWu14nBB2nS5LOjArVs8xmmW 7cosAJCXpGXd8D5gqt w U9bm E9BIv3jfqL4vwyHf1DdGY8C5Wtgo0oA9bKN1kRLmzVTnTCssdhFvPS 5nF6uFC41TimPzy9Fxtj8F hXq0mN GSbeEPEnpTWKHQkGTKfM20s57Nl6Dw
  • Under Choose Data Source, select Text/CSV
PwbFG7OKr9OA050nOV015C3FtHVaaCy5PxznX2T4xuxSZ23xejZMAPJ4h4Hcgc3gT9LmqNFuovXNQbUI jFlJqJQKpM2Cc8BvtLHFVWa1 K73et6Py1dPuD46 rbNtGB 7raRPuz9rsQ6iMwxuYI I fiyu7nuOk3pfZ1kUeP8jMoDd9G uvkh 34fWhRdOwf 6QWw
  • Select the CSV file downloaded earlier, then click on Get Data, then click Next.
LArIiBGwoCT48d5MF0LbRa yBP5tHhCAwIwUmfSFmCyUp1FStppHLxX7iROlyiAfLNSzVvzES92AeSfDRYlmxxLYkJNo0LLpGjqk eN16jkaG0Ct4fWFOTdEGj70aTGT3GpmUQt B0w 86LZf91 VbUDlsXuQ13 nNGoU HFY2kbtfAZR9QsJIahZfIuHimvrUaN9Q
mXh7ra6YZIfXtJev3PR Ly6PoLKFiEhQ0mq Yi9AcdQqQTPDytZtT39Fyy1hFklpwFNXsuzGW1g 11Vb MV2oZFAqmP6zbn 19SfcrQzniBz3Pb0WxC4d
  • In the file data preview, click on Transform Data or Edit (depending on your OS). Your data will then show up in the Power Query Editor, where you can clean it up.
YluAB9SBqmeku2yu2YSuTGQ9jIeZDJQMF fTn2 l1vNNxp0 RlQ59nbUdXZdNu5nqbbyY9W16cIF9DTTrN6DqYyDyh86olDA9qey AnNjMQHD IGKxH
  • Right-click on the Column to rename the columns as required.
4qPsQ5fSm noUBpxTJISo7fmD89HVQK SGfaPHN8xT g0atW2IL6xmPENRYM3oTRijippVtA FbqxxQlgSj3 feSM3DgJNrrfNkEshlieDoELQAdv2jli y3 S4cKq0ux1GvYAumpIaGs w4M2WqXHMwkOo80ziWHAh5Cc39nHZIdjRE0aRnKpSqC3qlUwr5i plkw
  • Use the Remove Rows option to remove any unwanted data that has been exported from the PDF. A dialog box will appear asking for the number of rows that need to be removed.
  • Insert a number and click on OK.
KBrp jP o78yUkv58h2OUWaKE34Nb3ERf liyU3B58pl2HiFJC1nkwMoQFzkxHl7BxQNqpr4PKxtO4HiSdMIWeq5ssbXZBCx
h8U7JGlXrqTHoinvFE7QQnHx7IqK0jnypdVkVf8pad92l XFt4oMR2 dqiXUIPXHLRmaklE7f4IzW0WqNh hyTn9tW9oQwcU0eASk3KZBu wq7tl9sQH6ibFRO6TeRE0fH5N siMlU3RDp0eijSYyoiZG43SMhlCVeByt1F84Z05tmMHEKVAQnKXnshTVmQFFhMdkg
  • Next, we will use the Conditional Column command, which is quite useful in cleaning up and organizing bank data. Click on Add Column > Conditional Column and a dialog box will appear asking you to assign conditions/clauses to organize your data.
Graphical user interface, table

Description automatically generated
  • In the dialog box for Conditional Column, insert the column name (in this case it’s Category), and then assigned conditions through clauses.
    • For the purpose of this data set, if the Transaction column contains the value E-TRANSFER (case sensitive) then the category assigned to it should be Email Transfer Received. We click the Add clause button to create our next rule.
    • If none of these clauses are true, then, we set the Else value to Miscellaneous.
    • You can continue to add as many clauses to the column as required, and then click OK. A new column will appear next to your data set as per the rules set in the Conditional Column.
VOAcxN4BMOpcXyyuZ9 U if17fr1De xJ5ASJzge9fORIsXjma7JG9RmFMpT2cFgy 89MZDdbVpQPWr jiEydeXzx3Zi5fFZ9nSraR DL73k9VcFY1fdpfyfF1yPJpJ11BTjvYqkJFHne7hXqmHKsFazjchxEOkQ4Io9 N58Sd6XtulgTwMb7 4vepimYmgVisv9A
hu494 8dy13MbGkvojPs9dq6BpU9 36VkyWVs ttUjLnBmjPIqrqoKiwMcKtZJfL2ZXW0hCVVev7G 2mtnbmyXp0blAND3gx2N31XwphSVXWdHAhh6k5dVFxPjzfC9V1rt1hmRajgnOk 7NBaAaFbGm4STjUEzYglkCPtKCWzFFt7cmsKrg1jmMyL2bpMBys5orlNA
Graphical user interface, application, table

Description automatically generated
  • At this point, you can Close and Load the Editor, and all your data will appear on an Excel worksheet.
Graphical user interface, application, table

Description automatically generated
Z6h2p2121 L2AbpkXPdFqB7fAF57XEXaUeojaq421q S 5V1OREq1y8Zf7xYWPY6hWRhM1TScb 9PbbHueYKzxrOZjKoo36TSF7fCsz3F9JMPVZa1NnwFvwmdoS4w7o08V7XAgfqDHUxliLji5wo 5WE3adFZfJ7YEQSLe0u SDWcVrbHpJp1gTyXdiAm4Zc3ZtCnA


Tiller Money

Tiller Money

Your financial life in a spreadsheet, automatically updated each day.

Start Your Free Trial

"There isn’t another tool on the market that does what Tiller can do.”
Will Hinton, Google Review October 30, 2023