How To Open Transaction Files In Excel

You may have transactions downloaded as QBO, QFX, OFX, QIF, PDF, MT940. Online banking sites, online credit card sites or investment brokers provide “accounting downloads”. Excel cannot open these formats. Can I open these files as text in Notepad or Excel? Yes, but they are easy to edit or read.

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

Download transaction files and convert to CSV/Excel in three steps:

Supported Account types to convert

Extract transactions from PDF files

PDF files are great to view and print documents, but hard to copy transactions from a statement. The ProperConvert app extracts transactions from such files. Other 'noise' details as small prints, legal paragraphs are left out.

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

The financial formats are great to store transactions and import into accounting software. Many accounting products prefer to work with the financial formats. Such files provide only one way to store transaction details, so there are fewer errors in parsing these files.

For human beings, these formats are not good to view, read or work with. The files in these formats are better when converted to a spreadsheet format like CSV.

Extract from multicolumn CSV files

Some CSV files like PayPal transaction downloads or Stripe transaction export have too many columns to work with.

Usually only details like date, amount, description, check number are needed. Accounting software like Xero or Quickbooks Online/SelfEmployed or Quicken for Mac may support CSV import, but may refuse to work with multi-column CSV files.

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

Choose the CSV target

The "CSV target" feature allows to to create the most suitable CSV file from transaction files:

Access MS Money MNY files and convert to CSV or Excel

Look for the Microsoft Money Sunset Edition (on Windows). It should open .mny files. Once you have them opened, export to the QIF format and then use the ProperConvert app to convert CSV or Excel.

Extract data from a Quicken QDF file

You need to get a Quicken installed on your computer and then use it to open a QDF file. Once you have a QDF file opened, export data as a QIF file and use the ProperConvert app to export your data to CSV or Excel/XLS/XLSX format.

Related articles