Free online XLSX to QIF converter

A finance program may require QIF when transaction records are stored in an Excel workbook and cannot be imported as XLSX or CSV. Converting the data creates an import file for supported personal-finance and accounting software while retaining core fields such as dates, payees, amounts, memos, and categories.

What the XLSX format is

XLSX is the XML-based workbook format used by Microsoft Excel, LibreOffice Calc, Apple Numbers, and spreadsheet-generation software. A workbook can contain multiple worksheets, formulas, formatting, tables, charts, and mixed data types; a transaction sheet commonly has columns such as Date, Payee, Amount, Memo, Category, and Check.

XLSX is designed for spreadsheet editing, not direct financial-data interchange. Select the worksheet containing the transactions, remove blank or summary rows, and replace formulas with calculated values if the converter or destination program cannot read formula results. Dates and amounts should use consistent values rather than display-only formatting.

What the QIF format is

QIF is a plain-text interchange format used by Quicken and other personal-finance applications that support QIF imports. A bank transaction normally contains a date beginning with D, an amount beginning with T, an optional payee beginning with P, memo beginning with M, category or transfer beginning with L, and a record terminator consisting of ^. The file begins with a type line such as !Type:Bank.

QIF is small, human-readable, and useful when the destination does not accept XLSX. It does not preserve spreadsheet formatting, formulas, charts, worksheets, or all modern financial metadata. Import support varies by application and version; some newer programs restrict QIF imports or support them only for particular account types.

Convert XLSX to QIF on 101convert.com

1. Prepare the workbook: keep transaction headers in the first row, remove totals and unrelated rows, and check that every transaction has a valid date and amount.
2. Open the XLSX-to-QIF converter on 101convert.com and upload the workbook.
3. Select the transaction worksheet and map the spreadsheet columns to QIF fields if the converter presents those options. Map withdrawals and expenses to negative amounts and deposits to positive amounts unless the destination application specifies another convention.
4. Choose the account type, commonly bank or credit card, start the conversion, and download the resulting .qif file.
5. In the finance application, use its QIF import command, commonly File → Import → QIF. Select the correct account, then review dates, signs, categories, transfers, and duplicate transactions before accepting the import.

For confidential records, check the service's handling and retention terms before uploading. A local script avoids sending the workbook to a third party.

Create a QIF file locally with Python

Install Python and the XLSX reader with python -m pip install openpyxl. Save the following as xlsx_to_qif.py. It expects a workbook named transactions.xlsx, uses the active worksheet, and requires Date and Amount headers; the other listed columns are optional.

from datetime import date, datetime
from decimal import Decimal
from openpyxl import load_workbook

book = load_workbook('transactions.xlsx', data_only=True)
sheet = book.active
headers = {
    str(cell.value).strip().lower(): i
    for i, cell in enumerate(sheet[1], start=1)
    if cell.value is not None
}

def col(name, required=False):
    value = headers.get(name.lower())
    if required and value is None:
        raise ValueError(f'Missing required column: {name}')
    return value

def text(row, index):
    return '' if index is None or row[index - 1] is None else str(row[index - 1]).strip()

date_col = col('Date', True)
amount_col = col('Amount', True)
payee_col = col('Payee')
memo_col = col('Memo')
category_col = col('Category')
check_col = col('Check')

with open('transactions.qif', 'w', encoding='utf-8', newline='') as out:
    out.write('!Type:Bank\n')
    for row in sheet.iter_rows(min_row=2, values_only=True):
        raw_date = row[date_col - 1]
        raw_amount = row[amount_col - 1]
        if raw_date in (None, '') or raw_amount in (None, ''):
            continue
        if isinstance(raw_date, (datetime, date)):
            qif_date = raw_date.strftime('%m/%d/%Y')
        else:
            qif_date = str(raw_date).strip()
        amount = Decimal(str(raw_amount)).quantize(Decimal('0.01'))
        out.write(f'D{qif_date}\nT{amount:f}\n')
        for prefix, index in (
            ('P', payee_col), ('M', memo_col), ('L', category_col), ('N', check_col)
        ):
            value = text(row, index)
            if value:
                out.write(f'{prefix}{value}\n')
        out.write('^\n')

Run it with python xlsx_to_qif.py, inspect transactions.qif in a plain-text editor, and import it into the destination program. If the account is a credit card, change !Type:Bank to !Type:CCard; other QIF types include Cash and Invst.

Compatibility and data-quality limits

• QIF date syntax and accepted year formats vary by importer. The script writes MM/DD/YYYY; confirm the destination's locale and date requirements when dates are ambiguous.
• Categories use the L field, for example LGroceries. Transfers commonly use account syntax such as L[Checking], while split transactions need multiple category and amount fields and are not generated by the simple script.
• QIF may not carry currency codes, account balances, transaction IDs, opening balances, or complete investment data. Verify currency and account settings in the destination application.
• QIF importers differ in their treatment of duplicate transactions, cleared status, check numbers, encoding, and negative amounts. Legacy software may require a local character encoding instead of UTF-8.
• Keep the original workbook, compare the imported transaction count and total with the source, and reconcile the account after import. Do not rely on a successful file import as proof that every field mapped correctly.