How to Convert a PDF to an OFX
Your bank or credit card statements may only be available online in the PDF format. Fortunately, you can convert your PDF statements to the OFX, or Open Financial Exchange, format to use with some money management programs. The OFX format works with Microsoft Money, Mint.com, Sage Accounting, GnuCash and Apple Numbers. To convert a PDF to OFX, you must first convert your PDF to a tab-delimited file. The tab-delimited, or TDF, file is then converted to a comma-separated values, or CSV, file and then the CSV file is converted to the OFX file format.
Things You'll Need
- Microsoft Excel
Convert the PDF File to TSV
Right-click on the PDF file that you wish to convert.
Click on "Open With" and select "Adobe Acrobat."
Click on the "File" menu at the top and select the "Export" option.
Choose "Text" from the "Export" menu.
Click on "Text (plain)."
Type the new name for your TSV file and click on the "Save" button.
Convert the TSV File to CSV
Click the "Start" button on your computer.
Click on "Programs" and then choose "Microsoft Office." Select the "Microsoft Office Excel" program from the list.
Click on the "Office" button at the top-left side of the screen and select "Open."
Click on your TSV file and click the "Open" button.
Click on the "Delimited" option under the "Original data type" heading and then click on the "Next" button.
Select the "Tab" option under the "Delimiters" heading and then "Finish."
Click on the "Office" button at the top of the screen.
Click on "Save as" and select "Other Formats."
Enter a new file name and select "CSV (Comma delimited)" in the "Save as type" box. Click on the "Save" button.
Convert the CSV File to OFX
Visit the CSV Converter home page to convert your CSV file to OFX.
Click on the "Convert Now" button.
Click on the "Open CSV" button at the top-left of the screen.
Select the file and click on the "Open" button.
Map the fields by selecting the correct date, category, amount, memo, credit and debit columns.
Click on the "Save as OFX" button to save the file to your desktop. The newly create OFX file can now be imported into your favorite money management program.