How To Open Transaction Files In Excel

Banks, credit card sites, and brokers offer transaction downloads in formats like QBO, QFX, OFX, QIF, PDF, and MT940. Excel cannot open these formats. You can open them as text in Notepad or Excel, but they are hard to read or edit.

Use the ProperConvert app to convert transaction files to CSV or Excel format.

Open a transactions file in Excel

Transaction files in QBO, QFX, OFX, QIF, and MT940/SAT formats are good for processing but hard to review. Use ProperConvert to open these files and convert them to a standard table format like CSV or Excel.

Download transaction files and convert to CSV/Excel using these steps:

Step 1: Log into your bank, credit card, or broker site and look for a transaction download.
Step 2: Download and install ProperConvert.
Step 3: Browse for a file with transactions such as a PDF, QFX, QBO, OFX, QIF, CSV, or MT940 file.
Step 4: Set the output target (all columns, Xero, QuickBooks Online, CSV Mint, etc.) and create a CSV file. A clipboard option is also available to paste directly into a spreadsheet.

Supported Account types to convert

Bank (Checking/Savings/Credit Line) (PDF, QFX, QBO, OFX, QIF, CSV, MT940).
Credit Card (PDF, QFX, QBO, OFX, QIF, CSV).
Investment (QFX, QBO, OFX, QIF).

Choose the CSV target

The "CSV target" feature lets you pick the best output layout:

Regular CSV or Excel XLSX or XLS (all details).
Excel XLS (all details included).
QuickBooks Online CSV (date, description, amount).
Xero CSV (date, description, amount, payee, reference, check number).
Quicken for Mac (CSV Mint) (date, amount, description).
Clipboard (all details, no file saved, paste directly into Excel).

Open QBO/QFX/OFX Format in Excel

QBO/QFX/OFX files are available in online banking for transaction downloads. OFX files include date, amount, payee/payer, memo, check number, and investment details. OFX files are also called "Microsoft Money" files.

Open QIF in Excel

QIF files are Quicken Interchange Format files containing details about transactions:

Downloaded from your bank, credit card company, or investment broker.
Created as an export file by Quicken.
Created as an export file by some personal finance apps.

Excel and Google Sheets cannot open QIF files directly. Use ProperConvert to convert QIF to CSV or Excel first.

Open MT940 file in Excel

MT940 (also SAT) files are provided by many banks for transaction downloads. They are not readable when opened in Notepad or Excel. Use ProperConvert to convert them to CSV or Excel first.

Extract transactions from PDF Bank Statements files to Excel

PDF files are easy to view and print, but hard to copy transactions from. ProperConvert extracts transactions from PDF statements. It leaves out noise like fine print and legal text.

Convert your bank statements to Excel without manual data entry:

Extract data from a PDF and create an Excel or CSV file.
Get the data from your bank or credit card statements and process it quickly.
Works with statements in many layouts. Pulls date, amount, description, and check number.
Works on your computer without uploading files online.
If your accounting app does not support CSV import, convert to OFX instead.
Free trial available. Contact us for help before or after your order.
Convert your own and your clients' documents without uploading to the cloud.
Import from text-based, image, or scanned PDFs using OCR (optical character recognition).
Customize the data fields, save as CSV or Excel, or copy to the clipboard.

Avoid manual entry by extracting transactions data from statements

ProperConvert extracts transaction data from your bank statements. This saves time and reduces errors. You get your data in a format that is easy to manage, without typing each transaction by hand.

Use ProperConvert on your desktop to convert bank statements to Excel

ProperConvert converts PDF bank statements to Excel files. You do not need to enter data by hand. Text-based PDFs work best, but OCR is included for scanned documents as well.

You can create Excel spreadsheets from your statements. This is useful for financial analysis, budgeting, and tax prep. With your data in an editable format, you can sort, filter, and review it easily.

Step-by-step instructions to convert bank statements to Excel

Download the conversion tool (free download).
Launch ProperConvert on your desktop and click Browse.
Select a bank or credit card statement file and click Open.
Select the output layout and format (CSV, Excel).
Convert and save to a location of your choice.

Open ProperConvert and click Browse to import your PDF. Select the fields to extract, such as date, description, and amount. Click Convert. Review the output on screen and save the file.

Is there an option to use the online converter version?

The converter converts files on your Windows or macOS desktop options. This way your data stay on your computer.

Extracting transactions from OFX, QFX, QBO, QIF, MT940 files

Financial formats like OFX, QFX, QBO, QIF, and MT940 are good for storing transactions and importing into accounting apps. They store data in one fixed way, so parsing errors are rare. But these formats are hard for people to read. Converting them to CSV makes them much easier to work with.

Extract from multicolumn CSV files

Some CSV files, like PayPal or Stripe exports, have too many columns. Most accounting apps only need date, amount, description, and check number. Apps like Xero, QuickBooks Online, or Quicken for Mac may support CSV import but may reject files with too many columns.

Use the ProperConvert app to extract specific transaction details. Once details are extracted, create a simplified CSV file that is ready to import.

Access MS Money MNY files and convert to CSV or Excel

Look for the Microsoft Money Sunset Edition on Windows. It can open .mny files. Once open, export to QIF format. Then use ProperConvert to convert to CSV or Excel.

Extract data from a Quicken QDF file

You need Quicken installed to open a QDF file. Once open, export data as QIF. Then use ProperConvert to convert to CSV or Excel.

Learn More

QBO - What is QBO (web connect) file format?
QFX - What is QFX file/format and how to open it?
OFX - What Is OFX File Format and How to Open it?
QIF - What is QIF file/format and how to open it?
Quicken - How To Import QIF or QFX into Quicken
QuickBooks - How to import transactions into Quickbooks