Free Excel to IIF Converter for QuickBooks Desktop
Upload the .xlsx or .xlsm workbook itself. There is no save-as-CSV step first and no renaming a .txt to .iif afterwards: pick the sheet, choose the QuickBooks Desktop record type, confirm the column mapping, download the file.
The workbook is read where it sits, inside your own browser, so nothing is uploaded and there is no sign-up. What comes back is a QuickBooks Desktop import file built from your own header row.
Embed this converter on your website for freeChoose your file
Drop your CSV or Excel file here
Your file is never uploaded. We never receive it or store it.
The Three-Step Workaround You Were About to Do
To create an IIF file from Excel, nearly every guide, including Intuit's own community answers, describes the same route: save the sheet as CSV, open it again and save as tab-delimited .txt, then rename the .txt to .iif. It exists because QuickBooks Desktop cannot read a workbook and Excel cannot write IIF. This page removes all three steps and reads the workbook itself.
The round trip is not only inconvenient. It is where a workbook quietly loses things: the sheets you did not save, a real date turned into whatever your regional settings write, a formula flattened into the text it happened to be showing at the time.
So there is nothing to save as anything first. An .xlsx is a ZIP file, and this IIF file converter opens four parts of it where they sit: the workbook, its relationships, the shared strings and the styles. Reading those directly is what lets you convert Excel to IIF with the sheets, the values and the dates all still intact.
| In the .xlsx | What the converter reads |
|---|---|
| <c r="B2" t="s"><v>12</v></c>A shared string. The cell holds an index, not the text. | ACME SUPPLY COLooked up in the shared-strings table |
| <c r="C2"><f>D2*E2</f><v>1250</v></c>A formula, and the value Excel last calculated. | 1250The cached value. The formula is read past |
| <c r="A2" s="2"><v>46085</v></c>A day count, and a style that says "date". | 03/04/2026Converted from the serial, and month-first |
An .xlsx is a ZIP, and four parts of it are opened: the workbook, its relationships, the shared strings and the styles. The last two are what make these three rows resolve, and they are exactly what a saved-as-CSV copy of the sheet no longer has.
What the Converter Reads Out of the Workbook
Four things a workbook stores that a CSV of the same sheet would not.
Every Sheet, and You Pick One
The file is read whole and every sheet in it is listed by name, with a count. Where a workbook holds several, a picker sits above the column mapping and the first sheet is loaded by default. Switching re-reads the file and runs the automatic mapping again against the new header row.
Formulas Arrive as Their Values
A cell holding =D2*E2 arrives as the number Excel last calculated and stored beside the formula. The formula text is read past entirely, so nothing recalculates and nothing is re-derived on the way through. What the workbook was showing is what the IIF line carries.
Real Date Cells, Not Five-Digit Numbers
Excel does not store a date as a date. It stores a day count, and the cell's number format is the only thing that makes 46085 look like 03/04/2026. A converter that reads the raw value and skips the format turns a whole ledger into 45000-something. This one reads the styles, works out which formats mean a date, and converts the serial.
.xlsm Yes, .xls No
A macro-enabled workbook is read like any other, because the file is a ZIP and only four parts of it are opened: nothing in it runs. The old .xls is a different binary format entirely, and it is refused by name rather than silently. Open it in Excel, save as .xlsx, and come back.
How to Create an IIF File From Excel
The widget's four steps, and not one of them asks you to save the sheet as something else.
Drop the Workbook
The .xlsx or .xlsm itself, not a CSV of it. The first two bytes of the file decide how it is read, so a CSV that somebody renamed .xlsx is read as plain text rather than refused as a broken workbook.
.xlsx · .xlsm
Choose the Sheet
A workbook holding one sheet goes straight through and never shows a picker. Where there are several, they are listed by name above the mapping with the first already loaded, so choosing is a correction rather than a step you have to take.
only when there is more than one
Say What the Rows Are
A QuickBooks Desktop transaction type, or a list import such as a chart of accounts. Your header row is matched to IIF fields automatically and every guess is badged, so a wrong match is visible on screen before anything is written.
transactions or lists
Download the .iif
Already tab-delimited and already named correctly, so there is nothing to rename. That rename is step three of the workaround above, and it is the step that never made the file importable on its own anyway.
nothing to rename
Convert the Workbook. Replace the Export.
One workbook is a job. The export that produces one every month is a different job.
| What you need | This converter | Autymate |
|---|---|---|
| One workbook turned into an IIF | Free, now, and nothing to sign up for | Not what it is for |
| The same workbook every month | The same sheet picked and the same columns mapped, every time | Read from the system the workbook was exported out of |
| The export that produces the workbook | Someone opens the source system and runs it | Not run at all, where the source can be read directly |
| QuickBooks Online as the destination | IIF cannot go there, whatever wrote it | Through the API instead, where the access allows |
What the Workbook Can Still Get Wrong
The honest limit here is not the IIF. It is what Excel was holding when you picked it.
Only the Sheet You Picked Travels
The totals tab, the notes tab and the other twelve months are not in the file you download. If the wrong sheet was picked, the IIF is complete and wrong, and nothing about it will say so. Check the preview against a row you already know before you take the file anywhere.
A Stale Value Is Still a Value
The number read out of a formula cell is the one Excel last calculated and cached there. A workbook written by a tool that never calculated leaves that cell empty, and a formula that has since broken carries whatever was written last. Neither reads any differently from a figure that is current.
A Date Typed as Text Is Still Text
A real date cell is converted from its day count and written month-first, whatever your regional settings say. A date somebody typed by hand was never a date cell, so no style marks it as one and it travels exactly as typed. Both then meet the Date format control together, which is worth setting before you convert.
For QuickBooks Online, Nothing Here Helps
QuickBooks Online has never imported IIF and no converter changes that, because IIF is a QuickBooks Desktop format. A file QuickBooks Desktop accepts is not a file QuickBooks Online has a door for. Nothing on this page is a route into it.
Common Questions
What people ask before they trust a converter with their accounting system.
No. The .xlsx goes in as it is. What the save-as route costs you is easiest to see in one place: a workbook stores repeated text once in a shared-strings table and points every cell at it by number, so the cell itself holds an index rather than a word. Saving to CSV flattens that back out and hands the result to whatever opens it next. The converter follows the pointer instead, which is why a supplier name arrives as a name and not as the number 12.
Excel has no IIF export of its own, so it takes a converter either way. Here: upload the workbook, pick the sheet, choose the QuickBooks Desktop record type, confirm the column mapping, download the file. The manual answer to how to convert Excel to IIF is to save the sheet as CSV, save it again as tab-delimited text and rename the extension, which leaves you holding a file with IIF's extension and your own column headings inside it.
The one you pick. When a workbook holds more than one sheet a picker appears above the column mapping, lists them by name and says how many there are, with the first already loaded. Switching re-reads the file and runs the automatic mapping again against the new sheet, so a mapping built for the wrong sheet is replaced rather than carried across to it.
Because Excel does not store a date as a date. It stores a day count, and the cell's number format is the only thing that makes 46085 look like 03/04/2026. The count runs from 30 December 1899, which is a day earlier than you would expect, because Excel deliberately keeps a 1900 leap-year error inherited from Lotus 1-2-3. A converter that reads the raw number and skips the format gets the five digits. One that reads both gets the date.
It is not supported, and the tool says so by name rather than handing back an empty result. An .xlsx or .xlsm is a ZIP file and the converter looks inside it for the workbook part; the old .xls is a different binary format entirely and has no such part in it. What you get back is the message: that does not look like an Excel workbook, and if it is an old .xls file, open it in Excel and save as .xlsx or CSV first. That message is also the fix.
No. IIF is a QuickBooks Desktop format and QuickBooks Online has never imported IIF files, so the real question is which route exists rather than which converter to pick. Spreadsheet data reaches QuickBooks Online through the API, which is what an integration does and what a file cannot. Searches for getting Excel into QuickBooks usually turn out to mean QuickBooks Online, and this page is honestly not that.
Free, with no sign-up, and the workbook is never uploaded. It is read inside the browser tab and the IIF is written there too, so there is no copy on a server for anyone to receive, store or delete. That matters more here than for most formats: a workbook usually holds far more than the one sheet you are converting, and the rest of it does not go anywhere either.
Offer the Excel to IIF Converter on Your Website
Your clients convert their files right on your site, free, without ever leaving it.
Free, with no sign-up
Copy the code and paste it. No account, no API key.
Client files stay private
Every file is converted in your visitor’s browser and never uploaded, not even to us.
Always up to date
Improvements reach your page automatically, and it sizes itself to fit.
Paste it into
Webflow
WordPress
Squarespace- Any HTML page
<div class="autymate-embed" data-tool="excel-to-iif-converter">
<p>Excel to IIF Converter · Powered by
<a href="https://www.autymate.com/tools/excel-to-iif-converter">Autymate</a></p>
</div>
<script async src="https://www.autymate.com/embed/v1.js"></script>Paste it where you want the converter to appear.
Written and maintained by The Autymate integrations team. We build and run accounting integrations for multi-location franchises, ISVs and bookkeeping firms: QuickBooks Desktop and Online, POS, payroll and ERP. These converters exist because we kept writing the same ones for customers, and there was no reason to keep them to ourselves.
Last reviewed
The Workbook Came From Somewhere
Converting one workbook is a job this page finishes in a couple of minutes. A workbook exported from the same system every month, saved to the same folder and mapped the same way each time is not a file problem, it is a routine with a file in the middle of it. Tell us which system the export comes out of, which QuickBooks Desktop company file receives it, and how many locations produce one.
Exact source access, fields, permissions, QuickBooks behaviour and service scope are confirmed during discovery.