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.
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.
The "CSV target" feature lets you pick the best output layout:
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.
QIF files are Quicken Interchange Format files containing details about transactions:
Excel and Google Sheets cannot open QIF files directly. Use ProperConvert to convert QIF to CSV or Excel first.
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.
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.
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.
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.
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.
The converter converts files on your Windows or macOS desktop options. This way your data stay on your computer.
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.
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.
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.
You need Quicken installed to open a QDF file. Once open, export data as QIF. Then use ProperConvert to convert to CSV or Excel.