OFXCSV / Practical guide

Move Quicken or bank OFX transactions into Excel

Use an OFX/QFX export when available and keep transaction IDs and memo fields for review.

Check your available export formats

Finance applications and versions offer different exports. Use CSV directly if the application already provides the fields you need. OFXCSV accepts an existing OFX, QFX or QBO file; it cannot open a Quicken data file, log into Quicken or produce a bank export that the application does not offer.

Keep a reference copy

Save the original export and note its account and date range. Upload one file at a time. Bank and credit-card activity are supported; securities and holdings need a different export. The free first ten rows show whether this tool reads your file before you buy a one-time pack.

Check IDs, signs and descriptions

A debit is usually a negative TRNAMT and a credit positive, but use the original file as authority. Name and Memo remain separate columns rather than being merged. FITIDs and check numbers remain text in XLSX. Corrections are flagged and retained without modifying the original transactions.

Use the result deliberately

Create categories in your workbook after reviewing transactions. The tool does not reconstruct Quicken splits, investment cost basis, attachments or categories absent from the OFX. Download XLSX for account balance sheets and CSV for a flat transaction-only import. Neither replaces the original application backup.

Try a real free conversion See one-time packs

Written by Zijian Xiao. Examples are synthetic. Review all extracted results against your original source file.