Learn
Guides and reference articles for legacy business file formats.
What Is an OFX File? (And QFX — Open Financial Exchange Explained)
OFX is the format banks use for downloadable statements, and QFX is Quicken's branded twin. Here's what's inside one — the header, SGML tags, STMTTRN blocks — explained in plain English.
How to Convert OFX or QFX to CSV (Free, In Your Browser)
Downloaded an .ofx or .qfx file from your bank and need it in a spreadsheet? Here's how to convert OFX to CSV or Excel free, without installing Quicken or paying for a converter.
What Is an MT940 File? SWIFT Bank Statements Explained
MT940 is the SWIFT message format banks worldwide use for end-of-day statements. Here's what's inside one — :20:, :61: transaction lines, :86: details — explained in plain English.
How to Convert MT940 to CSV or Excel
Got an MT940 statement file from your bank and need the transactions in a spreadsheet? Here's how to convert MT940 to CSV or Excel free, right in your browser.
What Is a CAMT.053 File? ISO 20022 Bank Statements Explained
camt.053 is the ISO 20022 XML statement format replacing MT940 under SEPA. Here's what's inside one — BkToCstmrStmt, Ntry blocks, bank transaction codes — explained in plain English.
CAMT.053 vs MT940: What Changes When Your Bank Switches
Banks are replacing MT940 statements with ISO 20022 camt.053. Here's how the two formats map to each other, what extra data camt.053 carries, and what to watch when you migrate.
What Is a QIF File? Quicken Interchange Format Explained
QIF is the plain-text export format used by Quicken, Microsoft Money, and GnuCash. Here's what's inside one — !Type headers, single-letter field codes, ^ separators — explained in plain English.
How to Convert QIF to CSV (Without Quicken)
Got a .qif export from Quicken, Microsoft Money, or GnuCash and need it in a spreadsheet? Here's how to convert QIF to CSV or Excel free, right in your browser.
What Is an LDIF File? LDAP Directory Exports Explained
LDIF is the plain-text format for exporting LDAP and Active Directory data. Here's what's inside one — dn lines, attributes, base64 values, change records — explained in plain English.
How to Convert LDIF to CSV (Free, In Your Browser)
Exported users or contacts from LDAP or Active Directory as an .ldif file? Here's how to convert LDIF to CSV or Excel free, without command-line tools.
What Is an MBOX File? Email Archives Explained
MBOX is the single-file mailbox format used by Thunderbird, Google Takeout, and Apple Mail. Here's what's inside one — From_ separators, headers, MIME parts — explained in plain English.
How to Convert MBOX to CSV (Without Thunderbird)
Got an .mbox archive from Google Takeout or an old mail client and need a spreadsheet of every message? Here's how to convert MBOX to CSV free, right in your browser.
What Is a VCF File? vCard Contacts Explained
A VCF (vCard) file is the plain-text format phones and email clients use to export contacts. Here's what's inside one — folded lines, TYPE params, QUOTED-PRINTABLE — and how to read it.
How to Convert VCF Contacts to Excel or CSV
Exported your contacts as a .vcf file and need them in a spreadsheet? Here's how to convert VCF to CSV or Excel free, without installing a contacts app.
What Is a NACHA File? ACH Batch Files Explained
A NACHA file is the fixed-width format banks use to move ACH payments. Here's what's inside one — batches, entries, addenda, control totals — explained in plain English.
NACHA Return Codes Explained (R01, R02, R03...)
An ACH payment came back with a return code like R01 or R29. Here's what the common NACHA return reason codes mean and what to do about each one.
What Is an IIF File? QuickBooks Desktop Import/Export Explained
IIF is the tab-delimited format QuickBooks Desktop uses to import and export lists and transactions. Here's what's inside one — TRNS, SPL, ENDTRNS — explained in plain English.
How to Convert QuickBooks IIF to CSV (Without QuickBooks)
Got a QuickBooks Desktop IIF export and need it in a spreadsheet, but don't have QuickBooks handy? Here's how to convert IIF to CSV free, right in your browser.
What Is a DBF File? dBase/FoxPro Data Explained
A DBF file is the binary table format behind dBase and FoxPro. Here's what's inside one — the header, field descriptors, and fixed-width records — explained in plain English.
How to Open a DBF File Without dBase or FoxPro
Got a .dbf file and no dBase or FoxPro installed? Here's how to open a DBF file and convert it to CSV or Excel free, right in your browser.
How to Import a CSV Into QuickBooks Desktop (Without Paying for a Converter)
QuickBooks Desktop won't open CSV files — but you don't need a $60/year converter. Turn your bank's CSV into a Web Connect (.qbo) file and import it free.
What Is an EDI 850? Purchase Orders Explained in Plain English
An EDI 850 is the X12 transaction set trading partners use instead of a PDF purchase order. Here's what's inside one — BEG, N1 loops, PO1 line items — explained in plain English.
EDI 856 (ASN) Errors That Trigger Retailer Chargebacks, and How to Catch Them First
Big retailers fine suppliers for bad advance ship notices — wrong pack hierarchy, mismatched quantities, missing HL nodes. Here's what triggers EDI 856 chargebacks and how to catch them before you ship.
What Is a BAI2 File? (And How to Open One in Excel)
BAI2 is the plain-text format banks use to report balances and transactions to businesses. Here's what's inside one, why it looks like gibberish, and how to open it in Excel.