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.
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.
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.
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.
The "CSV target" feature allows to to create the most suitable CSV file from transaction files:
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.
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.