Free tools Windows power users keep installed
One-click scans. No signup required.
Power Query can turn recurring bank, credit-card, ledger, or other financial exports into a refreshable Excel table. The dependable method is to start with the cleanest source available—usually CSV or Excel—keep compatible files in a dedicated folder, use Data > Get Data > From File > From Folder, clean the generated query, preserve source metadata, and reconcile the result before relying on it.
Power Query (also called Get & Transform) extracts, reshapes, and loads data; it does not decide whether a transaction is valid, classify every entry correctly, or replace reconciliation and accounting review. Microsoft describes the feature and its supported Excel environments in About Power Query in Excel.
What counts as a financial statement?
The same import pattern can handle several kinds of financial data, but the checks are different for each:
- Bank and credit-card statements: transaction date, posting date, description, debit, credit, and balance.
- Income statements: account or category, period, actual, budget, and variance.
- Balance sheets: account, reporting date, debit or credit balance, entity, and department.
- General-ledger exports: journal date, document number, account, memo, debit, credit, department, and project.
- Brokerage statements: trade date, settlement date, security, quantity, price, fees, and cash movement.
This guide emphasizes recurring bank and credit-card imports, then shows how to adapt the structure for other reports. A bank query usually appends transaction rows; a balance-sheet or income-statement query may need to preserve account hierarchies, reporting periods, and source-specific sign conventions.
#1 Best Overall
- Classic Office Apps | Includes classic desktop versions of Word, Excel, PowerPoint, and OneNote for creating documents, spreadsheets, and presentations with ease.
- Install on a Single Device | Install classic desktop Office Apps for use on a single Windows laptop, Windows desktop, MacBook, or iMac.
- Ideal for One Person | With a one-time purchase of Microsoft Office 2024, you can create, organize, and get things done.
- Consider Upgrading to Microsoft 365 | Get premium benefits with a Microsoft 365 subscription, including ongoing updates, advanced security, and access to premium versions of Word, Excel, PowerPoint, Outlook, and more, plus 1TB cloud storage per person and multi-device support for Windows, Mac, iPhone, iPad, and Android.
Choose the source format before opening Power Query
Power Query cannot make an unstructured source reliable by itself. Use the highest-quality export your institution offers.
| Source | Best use | Main risks |
|---|---|---|
| CSV or structured Excel | Recurring imports and validation | Locale, encoding, hidden sheets, formulas, and leading-zero loss |
| OFX, QFX, or another accounting export | Systems that support the format | Connector and field availability vary |
| Text-based PDF with stable tables | When no structured download exists | Repeated headers, split descriptions, shifted columns, and page totals |
| Scanned or image-only PDF | Last-resort extraction | Requires OCR or conversion; every row needs checking |
| Manual copy and paste | One-off, low-volume work | Not repeatable and easy to alter accidentally |
Check the bank or accounting system’s download menu for CSV, Excel, OFX, QFX, or an integration before choosing PDF. Treat PDF as a presentation format, not automatically as a data table.
Prerequisites and a durable design
- Use a supported Excel desktop edition with Power Query/Get & Transform. Microsoft lists support for Excel for Microsoft 365, Excel 2024, 2021, 2019, and 2016, while connectors and refresh destinations differ by Windows, Mac, web, and edition. Check the Excel version support matrix.
- On Windows, Microsoft’s current Power Query overview identifies .NET Framework 4.7.2 or later and Edge WebView2 requirements. Follow the current Microsoft requirements for your installation.
- Back up the raw files and restrict access: statements contain sensitive financial information.
- Define the output columns before transforming anything.
- Use a separate reconciliation method rather than treating a successful refresh as proof of accuracy.
A three-layer workbook is easier to audit:
- Raw: source content with filename, path, account, and period metadata.
- Staging: header removal, cleanup, type conversion, filtering, and normalization.
- Reporting: categorized and reconciled rows used by pivots, charts, or statements.
Recommended transaction schema
| Column | Type | Purpose |
|---|---|---|
| Account | Text | Preserves suffixes and leading zeros |
| Statement period | Date or text | Useful when the source has no period field |
| Transaction date | Date | Locale-independent date value |
| Posting date | Date | Keep separately when supplied |
| Description | Text | Retain raw wording in another column if you standardize it |
| Debit and Credit | Decimal number | Prefer separate fields when the source supplies them |
| Amount | Decimal number | Use one signed value only with a documented convention |
| Balance | Decimal number | Identify whether it is running or ending balance |
| Source file | Text | Trace a row back to its statement |
| Row status | Text | Optional valid, warning, error, or duplicate flag |
Import one statement
Excel workbook
- Select Data > Get Data > From File > From Excel Workbook.
- Choose the workbook.
- In Navigator, select the relevant worksheet, table, or named range. Named ranges can appear as selectable datasets.
- Select Transform Data, clean the data, and set types.
- Choose Home > Close & Load or Close & Load To.
Inspect the workbook rather than assuming the first sheet is correct. Hidden rows, merged cells, presentation formatting, stale formulas, or multiple similarly named tables can change the result. The Excel connector’s behavior and limitations are documented by Microsoft in its Excel connector documentation.
CSV or text file
- Select Data > Get Data > From File > From Text/CSV.
- Select the file.
- Check delimiter, file origin or encoding, and whether the first row contains headers.
- Choose Transform Data.
- Review automatically detected types and replace them with explicit, locale-aware types where necessary.
Automatic detection can misread dates, decimal separators, account numbers, and negative values. Preserve account identifiers as text so leading zeros are not discarded.
Outdated Drivers Are Slowing You Down
One free scan finds every outdated or missing driver and matches the right update for your exact hardware.Free scan · exact hardware matchPC Slower Than It Used to Be?
A free scan shows the junk files, broken settings and background clutter dragging Windows down - then fixes them in one click.Free scan · Windows 10 & 11PDF statement
- Select Data > Get Data > From File > From PDF.
- Select the PDF and inspect tables and page objects in Navigator.
- Choose the object containing the complete transaction set, then select Transform Data.
- Remove repeated headings, page labels, blank rows, and totals.
- Repair split descriptions or amounts before assigning types.
The PDF connector works best with selectable text and a consistent table layout. Scanned pages, positioned text, encrypted files, and visually complex statements may need OCR or conversion to CSV/XLSX first. Microsoft documents the connector and current requirements on its data-source import page.
Rank #2
![Microsoft Office Home & Business 2024 | Classic Desktop Apps: Word, Excel, PowerPoint, Outlook and OneNote | One-Time Purchase for 1 PC/MAC | Instant Download [PC/Mac Online Code]](https://m.media-amazon.com/images/I/41H8B5iqO4L._SL160_.jpg)
- [Ideal for One Person] — With a one-time purchase of Microsoft Office Home & Business 2024, you can create, organize, and get things done.
- [Classic Office Apps] — Includes Word, Excel, PowerPoint, Outlook and OneNote.
- [Desktop Only & Customer Support] — To install and use on one PC or Mac, on desktop only. Microsoft 365 has your back with readily available technical support through chat or phone.
Build a recurring monthly folder import
Folder combining is the most useful pattern when a new statement arrives every month.
Prepare the folder
- Create a dedicated folder such as
Bank Statements/Checking/orStatements/2026/. - Keep one compatible statement type and account in that folder.
- Use predictable names such as
2026-07-31.csv. - Keep raw originals elsewhere as a backup.
Power Query includes files and subfolders selected by the folder connection, so unrelated PDFs, spreadsheets, temporary files, and other accounts can corrupt the result. Microsoft recommends filtering by extension, filename pattern, or folder path when needed in Import data from a folder with multiple files.
Connect and combine
- Select Data > Get Data > From File > From Folder.
- Choose the folder and select Combine > Combine & Transform Data.
- In the Combine Files dialog, choose a representative sample file.
- Confirm delimiter, file origin, and data-type options where shown.
- Transform the sample-derived query; the generated helper queries and final output query apply the logic to the files.
- Filter the file list before the combine step if extensions, names, or paths need restricting.
- Add future compatible files to the folder and use Data > Refresh All.
Microsoft’s Combine files overview explains why compatible schemas matter. Columns may be in different orders because matching is based on column names, but materially different layouts should use separate queries rather than one increasingly fragile set of exceptions.
Add source metadata
Keep the source filename, account, entity, and statement period in the result. If the generated file list exposes a Name column, a custom column can be added with:
= Table.AddColumn(PreviousStep, "SourceFile", each [Name], type text)The exact metadata column name depends on the connector. With a predictable filename such as 2026-07-31.csv, a period column could be derived with:
Rank #3
- Designed for Your Windows and Apple Devices | Install premium Office apps on your Windows laptop, desktop, MacBook or iMac. Works seamlessly across your devices for home, school, or personal productivity.
- Includes Word, Excel, PowerPoint & Outlook | Get premium versions of the essential Office apps that help you work, study, create, and stay organized.
- 1 TB Secure Cloud Storage | Store and access your documents, photos, and files from your Windows, Mac or mobile devices.
- Premium Tools Across Your Devices | Your subscription lets you work across all of your Windows, Mac, iPhone, iPad, and Android devices with apps that sync instantly through the cloud.
- Easy Digital Download with Microsoft Account | Product delivered electronically for quick setup. Sign in with your Microsoft account, redeem your code, and download your apps instantly to your Windows, Mac, iPhone, iPad, and Android devices.
= Table.AddColumn(PreviousStep, "StatementPeriod", each Date.FromText(Text.BeforeDelimiter([Name], ".")), type date)Adapt that expression to your naming rule; do not apply it to arbitrary filenames.
Clean and normalize the query
Remove report structure
- Remove blank rows.
- Remove top rows until the actual header is the first row.
- Promote headers only after isolating the real header.
- Remove repeated column headings from later PDF pages.
- Remove page numbers, footers, subtotals, and report-level totals that are not transactions.
- Filter hidden or temporary files before a folder combine.
Imports often create automatic Promoted Headers and Changed Type steps. Review or delete them rather than retaining them blindly; a type step applied before cleanup is a common source of errors.
Clean text and columns
- Trim and clean descriptions.
- Replace non-breaking spaces and unusual minus signs.
- Split combined date, description, and amount fields when the delimiter is reliable.
- Merge wrapped description lines instead of treating continuation lines as transactions.
- Rename columns to stable names.
- Add account, entity, period, and source-file columns.
- Merge a transaction query with a chart-of-accounts or category lookup rather than hard-coding every category in the extraction.
- Unpivot month columns when an income statement presents periods horizontally.
Dates, locales, currencies, and signs
A value such as 01/02/2026 can mean January 2 or February 1. Commas can be decimal separators or thousands separators, and transaction date can differ from posting date. Use Change Type > Using Locale when the source’s regional convention differs from Excel’s. Keep a currency code as a separate field when more than one currency is possible.
First preserve the imported amount and sign. Then create a normalized amount and document the convention:
- A source may provide separate Debit and Credit columns.
- A source may provide one signed Amount column.
- Credits may be positive and debits negative, or the reverse.
- Parentheses, trailing minus signs, or a D/C indicator may encode the sign.
- A displayed balance is not necessarily a transaction amount.
Test a known deposit, withdrawal, fee, refund, and transfer, then reconcile the calculated ending balance. Do not assume that every debit should be negative: bank accounts, liabilities, expenses, revenue, and ledger balances use different conventions.
For a source where credits increase the account and debits decrease it, this example creates a signed value:
The Tool Desk
Outbyte Driver Updater FREEFix the driver behind crashes, sound loss and screen glitchesFind Drivers →Outbyte PC Repair FREEClear out junk files and repair common Windows errorsFree Scan →= Table.AddColumn(PreviousStep, "NormalizedAmount", each (if [Credit] = null then 0 else [Credit]) - (if [Debit] = null then 0 else [Debit]), type number)That formula is an example, not a universal accounting rule.
Convert text amounts carefully
This expression assumes US-style formatting and does not handle every currency or negative convention:
= Table.TransformColumns(PreviousStep, { { "Amount", each Number.FromText(Text.Replace(Text.Replace(Text.Trim(_), "$", ""), ",", ""), "en-US"), type number } })For another locale, change the parsing approach and test decimal and thousands separators against known values. Keep the original imported amount before making a risky conversion.
PDF-specific problems and when to stop
A human-readable PDF can still lack table semantics. Watch for:
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
Best Value
- Fully compatible with Microsoft Office documents, Office Suite is the number 1 affordable alternative. It is compatible with Word, Excel and PowerPoint files allowing you to create, open, edit and save all your existing documents in an easy-to-use professional office suite. Suitable for home, student, school, family, personal and business use, it includes comprehensive PDF user guides to help you get started, plus a dedicated guide for university students to help with their studies. Multilingual - English, Spanish (Español) and more languages supported.
- Professional premier office suite includes word processor, spreadsheet, presentation, graphics, database and math apps! It can open a plethora of file formats including doc, docx, odt, txt, xls, xlsx, xlsm, ppt, pptx and many more, making it the only office suite you will ever need. You can use the ‘Save as’ feature to ensure your files remain compatible with Word, Excel and PowerPoint, plus you can convert and export your documents to PDF with ease.
- Full program included that will never expire! Free for life updates with lifetime license so no yearly subscription or key code required ever again! Unlimited users allow you to install to both desktop and laptop without any additional cost, and everything you need is provided on USB; perfect for offline installation, reinstallation and to keep as a backup. Compatible with Microsoft Windows 11, 10, 8.1, 8, 7, Vista, XP (32/64-bit), Mac OS X and macOS.
- PixelClassics exclusive extras include 1500 fonts, 120 professional templates, 1000's of clip art images, PDF user guides, over 40 language packs, easy-to-use PixelClassics installation menu (PC only), email support and more! Each USB comes complete with our quick start install guide, plus a fully comprehensive PDF guide is provided on USB.
- You will receive the USB (not a disc) exactly as pictured, in protective sleeve (retail box not included). Our slimline USB is 100% compatible with ALL standard size USB ports. To ensure you receive exactly as advertised including all our exclusive extras, please choose PixelClassics. All our USBs are checked and scanned 100% virus and malware free giving you peace of mind and hassle-free installation, and all of this is backed up by PixelClassics friendly and dedicated email support.
- Scanned pages with no text layer.
- Columns extracted in the wrong order.
- Multi-line descriptions.
- Repeated headers and footers.
- Page subtotals imported as transactions.
- Debit and credit columns merging.
- Negative signs separated from amounts.
- Transactions split across pages.
- Different layouts between months.
- Password-protected or encrypted documents.
Try another detected table or page object and inspect a small sample. If rows remain misaligned, obtain a direct CSV/XLSX export or convert the PDF with an approved OCR tool, then validate every row. Adobe’s Export PDF product is one commercial conversion option; it is not a substitute for reconciliation or for protecting sensitive statement data.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.Validate before relying on the output
Make validation a required stage. A query can refresh without an obvious error and still omit rows, misread signs, or import a page total.
Reconciliation checklist
- Count imported rows by source file and statement period.
- Check minimum and maximum transaction dates.
- Compare debit and credit totals with the statement.
- Verify opening balance plus normalized transactions equals the closing balance, allowing for pending items, fees, and statement-specific conventions.
- Find blank dates, blank amounts, conversion errors, and unexpected currencies.
- Check duplicate transaction identifiers. Do not deduplicate solely on date and amount; legitimate transactions can share both.
- Confirm every source file appears in the result.
- Compare PDF page totals with imported totals.
- Confirm known transactions occur exactly once.
- Refresh twice and verify that the result is unchanged.
Control sheet
Add a visible control sheet containing source-file count, imported-row count, error-row count, duplicate-row count, total debit, total credit, latest transaction date, and reconciliation status. Keep the raw query available so an unexpected reporting value can be traced to extraction, cleanup, type conversion, classification, or loading.
Microsoft’s handling data source errors guidance recommends preserving original columns where possible and using copied columns for risky transformations.
Quick wins for a faster PC:
Repair Windows errors before they cause bigger problemsFix Now →Fix the driver behind crashes, sound loss and screen glitchesFind Drivers →Clear out junk files and repair common Windows errorsFree Scan →Load the table and refresh it
- In Power Query Editor, select Home > Close & Load or Close & Load To.
- Choose an Excel table for an ordinary transaction output; choose the Data Model only when your reporting design requires it.
- When a new statement is saved in the configured folder, select Data > Refresh All.
- Review the control sheet and any refresh errors before distributing reports.
- Use query properties to review refresh behavior and preserve a stable source path or parameter.
Refreshing a query is different from merely refreshing an external connection; Microsoft explains the distinction in Refresh an external data connection in Excel. Save an open CSV or workbook before refreshing, because unsaved edits are not included.
Excel for the web supports refresh for some sources and destinations, but capabilities vary; Microsoft’s Power Query in Excel for the web guidance and the version matrix should be checked. Microsoft notes that queries loaded to the Data Model cannot currently be refreshed in Excel for the web.
Troubleshoot common failures
| Symptom | Likely cause | Fix |
|---|---|---|
| Rows or columns change unexpectedly | Unrelated files or subfolders are in the folder | Filter extension, filename, account, or path; keep one schema per folder |
| Refresh errors after one new file | That file has changed headers, columns, or layout | Use source metadata to identify it; repair it or create a separate query |
| Account numbers lose zeros | Automatic type detection made them numeric | Delete or edit Changed Type and set the field to text |
| Dates swap month and day or become null | Locale mismatch | Use Change Type > Using Locale and test known dates |
| Amounts are errors or have wrong signs | Currency symbols, separators, parentheses, or sign rules differ | Preserve the raw value, parse with the correct locale, and test known transactions |
| PDF amounts sit under the wrong column | PDF object is visually formatted rather than structurally tabular | Try another object, OCR/conversion, or obtain CSV/XLSX; reconcile before use |
| Refresh works only on one computer | Hard-coded local path, missing permission, or privacy setting | Use a parameter or configuration table, shared SharePoint/OneDrive path where appropriate, and verify access |
| Recent source edits are missing | File is open or unsaved | Save the source, then refresh |
| Same statement period appears twice | Duplicate source files or repeated downloads | Use stable filenames, remove duplicate files, and add a transaction-key duplicate check |
Privacy and security
- Store raw statements in a controlled location and retain originals for auditability.
- Do not upload financial statements to unknown online converters.
- Use a sanitized sample when testing or publishing a workbook.
- Protect the workbook and exported data.
- Do not embed credentials in M code.
- Review data-source privacy levels when combining sources.
- Follow your organization’s retention, access, and credential policies.
When another tool is better
Use the simplest tool that matches the problem:
| Need | Practical choice |
|---|---|
| Clean CSV or XLSX and a personal workbook | Excel Power Query |
| Scanned or structurally difficult PDF | Approved OCR/PDF conversion followed by Power Query and reconciliation |
| Shared dashboards, semantic models, and scheduled team reporting | Power BI; Microsoft’s US pricing view captured in August 2026 listed Pro at $14 per user per month, paid yearly, but regional and contract terms vary. See Power BI pricing. |
| Centralized, governed, high-volume document processing | Microsoft 365 document-processing services, with licensing, authentication, privacy, and administration considerations; see Document processing for Microsoft 365. |
If your bank supplies a structured export, it is generally safer than a PDF. A dedicated PDF converter can help with OCR, but verify its privacy, retention, accuracy, and pricing terms before sending sensitive statements.
Quick Recap
Operational checklist
- Choose CSV, Excel, OFX, or QFX before PDF whenever available.
- Back up raw files and place only compatible statements in the import folder.
- Define account, period, dates, descriptions, amounts, balances, and source metadata.
- Use Combine & Transform Data for recurring files.
- Inspect automatic header and type steps.
- Clean repeated headings, footers, subtotals, blank rows, and wrapped descriptions.
- Apply locale-aware date and number types.
- Preserve raw signs before creating normalized amounts.
- Reconcile balances, totals, row counts, duplicates, and known transactions.
- Load the table, save source files, and review controls after every refresh.
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
