Credit Bundles
One-time purchase
- No monthly commitment
- Credits valid for one year
- Access to all tools
- Full file downloads
Enter your email to receive a sign-in link
Extract all transaction fields from Quicken QFX bank files into a formatted Excel spreadsheet. Every field stays in its own column with proper formatting. Your data never leaves your browser.
Starting from $5 — see pricing & bundlesAccounts → Transaction History → Export
Upload OFX/QFX/QBO Bank Transactions CSV and choose OFX Bank Export (Excel) format
Review converted data, download Excel-ready file
Open the .xlsx file directly in Microsoft Excel or compatible application
Output is in Excel Spreadsheet format — ready to import directly, no manual reformatting needed.
QFX is Quicken's variant of OFX with Quicken-specific headers. Both use the same XML structure. This tool handles both.
Yes! Upload the .xlsx file to Google Drive and open with Google Sheets.
All conversion happens entirely in your browser. Your file is never uploaded to our servers.
256-bit SSL encryption. Same standards as major financial institutions.
Files are processed directly in browser. No calls to our servers.
Full EU data protection compliance. Your privacy rights protected.
How Banking Ofx fields map to Excel Bank Export
| Banking Ofx | Source Value | Excel Bank Export | Target Value | Note | |
|---|---|---|---|---|---|
DTPOSTED |
2025-01-15 12:00:00 |
→ | Date |
01/15 12:00:00/2025
|
OFX date (YYYYMMDD) → MM/DD/YYYY |
TRNTYPE |
DEBIT |
→ | Type |
DEBIT
|
Transaction type (DEBIT, CREDIT, CHECK, etc.) |
TRNAMT |
-50.00 |
→ | Amount |
-50.00
|
Signed amount (negative for debits, positive for credits) |
NAME |
AMAZON PURCHASE |
→ | Payee |
AMAZON PURCHASE
|
Payee/merchant name (kept separate) |
MEMO |
Online order #12345 |
→ | Memo |
Online order #12345
|
Transaction memo (kept separate) |
CHECKNUM |
1001 |
→ | Check Number |
1001
|
Check number if applicable |
REFNUM |
REF123456 |
→ | Reference |
REF123456
|
Bank reference number |
FITID |
202501150001 |
→ | Transaction ID |
202501150001
|
Bank's unique transaction identifier |
Each QFX field gets its own column for maximum analysis flexibility
Bold headers, auto-sized columns, and proper formatting ready for analysis
Converts QFX dates to readable MM/DD/YYYY format
Bank's unique identifiers are kept for reconciliation and deduplication
All processing happens in your browser - your financial data never leaves your computer
Handles all QFX file variants from any bank that provides Quicken downloads
Each OFX transaction becomes one CSV row with all fields separated
XML-based bank transaction
FITID,
DTPOSTED,
TRNAMT,
TRNTYPE,
NAME,
MEMO
Spreadsheet row with all fields in separate columns
Issues you might encounter when importing OFX/QFX/QBO Bank Transactions data to OFX Bank Export (Excel) - and how we solve them
File is not a valid OFX/QFX format
CSV file or corrupted OFX
Valid OFX file from bank download
Ensure you're uploading an OFX/QFX file directly from your bank
Download the OFX file again from your bank's website
OFX file contains no transaction data
OFX file with empty BANKTRANLIST
OFX file with at least one STMTTRN
Ensure the date range in your bank download includes transactions
Download a different date range with transaction activity
Buy bundles and get up to 60% off. Perfect for recurring monthly conversions.
// PRICING //
Just start processing on any tool page
Tools processing starts from 5 credits. Then 1 credit = 1k rows. No sign-up needed.
One-time purchase
Best for professionals and content creators
One-time credit bundles are valid for one year. Subscription credits refresh monthly. You can use credits across any tool, anytime.
Files process entirely in your browser. We're GDPR compliant with TLS encryption.
Yes! Full refund within 14 days if no credits used. Partial refund for unused credits anytime. Contact sup@spreadsheetbroccoli.com.
Terms of service applies. VAT included where applicable.
All available data flows from Banking to Excel
DATE → Date
TRNSTYPE → Type
ACCNT → Account
DTPOSTED → Date
TRNTYPE → Type
TRNAMT → Amount
DTPOSTED → Date
TRNTYPE → Type
TRNAMT → Amount
D → Date
T → Amount
P → Payee
Learn More:
Help us improve—what stopped you today?
Enter your email to claim your welcome bonus