into for finance apps
FileInto converts an Excel bank statement (.xlsx) into a standard .OFX file for Xero, Moneydance, GnuCash and other finance apps.
- Never uploaded, stays on your device
- Free preview
- Opens in Xero and GnuCash
Have a different file, or need a different one? Click or above.
How to import the OFX file
Xero
- Go to Accounting, then Bank accounts.
- On the account, choose Manage account, then Import a statement.
- Select the .ofx file from FileInto and click Import.
- Reconcile the new statement lines.
GnuCash
- Go to File, then Import, then Import OFX/QFX.
- Select the .ofx file from FileInto.
- Pick or create the GnuCash account when asked.
- Match or assign each transaction in the import window, then click OK.
What FileInto looks for in your file
| Column | Examples | Notes |
|---|---|---|
| Sheet | The first sheet in the workbook | Move the transactions to the first sheet if your workbook has several. |
| Date | 10/03/2026, 2026-10-03, Oct 3 2026, 03/10/2026 | Any common date style. If day and month are swapped, change "Dates in your file". |
| Description | STARBUCKS STORE 01234 | Payee or details. Long descriptions are kept in full in the memo. |
| Amount | -5.75, $1,234.56, (12.00), 12.00 DR | One signed amount column, or separate money out and money in columns. |
| Memo, check number, balance | Optional | Used when your file has them. The last balance becomes the statement balance. |
Problems and fixes
- Dates show up as numbers like 46298
- That is how Excel stores dates. FileInto reads real Excel dates, so this only happens when the column is formatted as text. Format the column as Date in Excel and save again.
- Summary rows at the top are counted
- Rows without a valid date are skipped and listed under "rows skipped". Delete totals and notes at the bottom if they have dates.
- The app says the file is invalid
- Some apps want QFX or QIF instead of OFX. Switch "Save as" to the format your app lists and download again.
- Transactions land in the wrong account
- OFX files carry an account number. Enter the last digits of your real account number in Settings so your app links the file to the right account.
- The same lines appear twice
- Each transaction gets a fixed id, so re-importing the same file is skipped by apps that track ids. Overlapping bank exports can still duplicate.
Questions
- What is an OFX file?
- OFX (Open Financial Exchange) is the standard file banks use to send transactions to finance apps. Xero, GnuCash, Moneydance, Banktivity and many others import it.
- Is my spreadsheet uploaded?
- No. FileInto opens it inside your browser tab.
- Which Excel formats work?
- .xlsx and older .xls files. Only the first sheet is read.
- Can I convert a CSV instead?
- Yes. Drop a .csv file into the same converter; it reads both.
- What are the limits?
- Files up to 25 MB. Every file gets a full preview free. Downloads up to 25 transactions are free, no account needed; a Day Pass ($9 for 24 hours) or Unlimited ($7 a month) has no row limit. It works in current versions of Chrome, Edge, Safari and Firefox, on computers and phones.
Related converters
- CSVintoOFXFor Xero, Moneydance and GnuCash
- ExcelintoQBOFor QuickBooks
- ExcelintoQFXFor Quicken
- ExcelintoQIFFor older Quicken and other apps
Guides: What is an OFX file?
Bank-specific steps and quirks: Bank of America, Chase, Wells Fargo, Capital One and American Express.
Pick a converter
Every converter runs in your browser. Nothing is uploaded.
Turn your Excel file into
- CSVExcel and Google SheetsSoon
- QBOQuickBooksCurrent
- QFXQuickenCurrent
- OFXXero, GnuCash and moreCurrent
- QIFOlder QuickenCurrent
Make a OFX file from
- CSVBank or card CSV
- ExcelExcel statementCurrent
- PayPalPayPal activity
- StripeStripe payouts
- SquareSquare sales
- QBOQuickBooks bank downloadSoon
- QFXQuicken bank download
Bank and card files
Payment processors
- PayPalintoQBOFor QuickBooks
- StripeintoQBOFor QuickBooks
- SquareintoQBOFor QuickBooks
- PayPalintoQFXFor Quicken
- PayPalintoOFXFor Xero, Moneydance and GnuCash
- PayPalintoQIFFor older Quicken and other apps
- StripeintoQFXFor Quicken
- StripeintoOFXFor Xero, Moneydance and GnuCash
- StripeintoQIFFor older Quicken and other apps
- SquareintoQFXFor Quicken
- SquareintoOFXFor Xero, Moneydance and GnuCash
- SquareintoQIFFor older Quicken and other apps
Bank downloads
No converter for “” yet. Tell us what you need and we will look at it.