CSV Tools

Convert QIF to QBO

Convert legacy QIF files into QBO format for QuickBooks

Need the reverse? Use the QBO to QIF converter. Just want a spreadsheet? Convert QIF to CSV. See all personal finance converters.

QIF Input

Account Details

Filled in automatically from your QIF file where possible — edit anything that needs correcting.

QBO Output

QBO output will appear here...

More Options

Financial Institution

How to Use This Tool

This tool converts legacy QIF files into QBO format. It runs directly in your browser — your financial data is never uploaded anywhere.

QIF is Quicken’s older plain-text format; QBO is what QuickBooks imports today. Dates, amounts, payees, memos, and check numbers carry over, with transaction IDs generated for clean importing.

  1. Provide your QIF file — Paste the file content or drop your .qif file onto the File tab.
  2. Enter account details — QIF files don’t include them, so add your account number and institution info.
  3. Download the QBO file — Then import it into QuickBooks (Banking → Upload transactions).

FAQ

5 questions
Does this tool upload my financial data?
No. The conversion runs entirely in your browser using JavaScript. Your bank transactions never leave your device — no server receives, stores, or processes them.
Why would I convert QIF to QBO?
QuickBooks has never imported QIF. Converting to QBO (Web Connect) lets you bring QIF exports from old Quicken or other legacy apps into QuickBooks.
Why do I have to enter account details?
QIF files carry almost no account information, but the QBO format requires an account number, type, and institution details. Fill them in once and the converter builds a complete file around your transactions.
How are transaction IDs handled?
QIF has no transaction IDs, so the converter generates stable FITIDs from each transaction's date, amount, and payee. Duplicate detection works within this file, but converting overlapping QIF exports separately can still produce duplicates on import.
What happens to QIF categories?
They're dropped — the QBO format has no category field. Categories are a Quicken-side concept; you can re-categorize after importing.

More Personal Finance Formats Tools

21 tools

CSV to YNAB

Convert CSV bank statements into YNAB-compatible import format

CSV to Xero

Convert CSV bank statements into Xero-compatible import format

CSV to QBO

Convert CSV bank transactions into QuickBooks format

QBO to CSV

Export QBO to CSV — convert QuickBooks Web Connect files into clean CSV

CSV to QFX

Convert CSV to Quicken QFX format for direct import

QFX to CSV

Convert Quicken QFX files into CSV format

CSV to OFX

Convert CSV financial data into Open Financial Exchange format

OFX to CSV

Convert OFX financial files into CSV format

CSV to QIF

Convert CSV financial data into Quicken Interchange Format

QIF to CSV

Convert Quicken QIF files into CSV format

QFX to QBO

Convert QFX files into QBO format for QuickBooks

QBO to QFX

Convert QBO files into QFX format for Quicken

OFX to QBO

Convert OFX files into QBO format for QuickBooks

QBO to OFX

Convert QBO files into OFX format for most finance apps

OFX to QFX

Convert OFX files into QFX format for Quicken

QFX to OFX

Convert QFX files into OFX format for most finance apps

QFX to QIF

Convert QFX files into QIF format for older Quicken versions and legacy apps

QIF to QFX

Convert legacy QIF files into QFX format for Quicken

QBO to QIF

Convert QBO files into QIF format for older Quicken versions and legacy apps

OFX to QIF

Convert OFX files into QIF format for older Quicken versions and legacy apps

QIF to OFX

Convert legacy QIF files into OFX format for most finance apps

More CSV Tools

115 tools

Add Header Row

Add a header row to a CSV that doesn't have one

Anonymize Columns

Anonymize CSV data by replacing sensitive column values with fake data

Compare Files

Compare two CSV files and highlight the differences

Column Counter

Count the number of columns in your CSV

CSV to Excel

Export CSV data to .xlsx spreadsheets

CSV to YNAB

Convert CSV bank statements into YNAB-compatible import format

CSV Viewer

View and explore CSV files in a sortable table

Extract Email Addresses

Find and extract all email addresses from your text or CSV

Filter Rows

Filter CSV online — keep only rows that match your criteria

GeoJSON to CSV

Convert GeoJSON features to CSV rows

Merge CSVs

Combine multiple CSV files into one

Remove Columns

Delete one or more columns from your CSV

Transpose CSV

Swap rows and columns in your CSV

Column Stats

Get data type, null count, unique count, and common values per column

CSV to Xero

Convert CSV bank statements into Xero-compatible import format

Excel to CSV

Import .xlsx files and convert to CSV

Extract Columns

Keep only the columns you need from your CSV

Extract Phone Numbers

Find and extract all phone numbers from your text or CSV

Find Missing Rows

Find rows in one file that are missing from another

KML to CSV

Extract placemarks from KML files into CSV

Redact Columns

Mask or remove sensitive values from selected columns

Remove Header Row

Remove the header row from your CSV

Sort CSV

Sort CSV online — order rows by any column, ascending or descending

Split CSV

Break large CSVs into smaller chunks

Calculate Dimensions

Get the row count, column count, and size of your CSV

Change Header Case

Switch headers between camelCase, snake_case, kebab-case, and more

CSV to JSON

Convert CSV files to clean, structured JSON

CSV to QBO

Convert CSV bank transactions into QuickBooks format

Extract URLs

Find and extract all URLs from your text or CSV

Find Common Rows

Find rows that appear in both CSV files

KMZ to CSV

Convert zipped KMZ map files to CSV

Remove Duplicates

Find and eliminate duplicate rows

Rename Columns

Change the header names of your CSV columns

Split by Column Value

Split a CSV into multiple files based on column values

GPX to CSV

Convert GPX waypoints and tracks to CSV

JSON to CSV

Convert JSON arrays to downloadable CSV

QBO to CSV

Export QBO to CSV — convert QuickBooks Web Connect files into clean CSV

Remove Empty Rows

Delete rows that are completely empty

Reorder Columns

Rearrange the column order in your CSV

Row Counter

Quick count of rows, columns, and empty cells

Sample Rows

Pick a random sample of rows from your CSV

Add Column

Add a new column with a default value to your CSV

Count Values

Count the number of non-empty values in each column

CSV to QFX

Convert CSV to Quicken QFX format for direct import

CSV to XML

Transform CSV into well-formed XML documents

Fill Missing Values

Replace empty cells with a default value

First N Rows

Extract the first N rows from your CSV

Shapefile to CSV

Convert zipped shapefiles to CSV with attributes and coordinates

CSV to GeoJSON

Convert CSV coordinates to GeoJSON features

Find and Replace

Search for values in your CSV and replace them

Last N Rows

Extract the last N rows from your CSV

One-Hot Encode Column

Convert categorical values into binary columns

QFX to CSV

Convert Quicken QFX files into CSV format

Summary Statistics

Get count, mean, min, max, and percentiles for numeric columns

XML to CSV

Convert XML data with repeating elements into CSV

CSV to KML

Generate KML placemarks from CSV coordinates

CSV to OFX

Convert CSV financial data into Open Financial Exchange format

CSV to TSV

Convert comma-separated values to tab-separated format

Extract Date Parts

Pull year, month, day, and more from date columns

Slice Rows

Extract a range of rows by start and end position

Split Column

Split one column into two columns by a delimiter

Sum Column

Calculate the total of all values in each numeric column

Trim Whitespace

Remove leading and trailing spaces from all cells

Add Row Numbers

Add a sequential row number column to your CSV

Average Column

Calculate the average of all values in each numeric column

CSV to KMZ

Create compressed KMZ map files from CSV coordinates

Merge Columns

Combine two columns into one using coalesce logic

OFX to CSV

Convert OFX financial files into CSV format

Remove HTML Tags

Strip HTML tags from cell values in your CSV

TSV to CSV

Convert tab-separated data into comma-separated CSV

Count Unique

Count the number of distinct values in each column

CSV to GPX

Convert CSV coordinates to GPX waypoints for GPS devices

CSV to HTML

Generate HTML tables from CSV data for easy web embedding

CSV to QIF

Convert CSV financial data into Quicken Interchange Format

Map Column Values

Replace column values using a visual mapping table

Remove Comments

Remove comment lines from your CSV

Reverse Rows

Reverse the order of rows in your CSV

HTML to CSV

Extract table data from HTML and convert to CSV

QIF to CSV

Convert Quicken QIF files into CSV format

Remove Whitespace

Strip all unnecessary whitespace from your CSV

Running Total

Add a cumulative sum column to your CSV

Shuffle Rows

Randomly reorder all rows in your CSV

Uppercase Column

Convert all values in a column to uppercase

Compress CSV

Minify your CSV by removing unnecessary whitespace and formatting

CSV to YAML

Convert CSV to YAML — clean, readable documents

Lowercase Column

Convert all values in a column to lowercase

Percentage of Total

Add a column showing each row's share of the total

QFX to QBO

Convert QFX files into QBO format for QuickBooks

CSV Validator

Check your CSV for formatting errors and structural issues

QBO to QFX

Convert QBO files into QFX format for Quicken

Rolling Average

Calculate a moving average over a sliding window of rows

Swap Column Data

Swap the data between two columns in your CSV

YAML to CSV

Convert YAML lists into CSV format

CSV to Markdown

Convert CSV to Markdown table format — GitHub-flavored, with aligned columns

Duplicate Column

Create a copy of an existing column

OFX to QBO

Convert OFX files into QBO format for QuickBooks

Parquet Viewer

View parquet files online — sortable table plus full schema, types, and row counts

Markdown to CSV

Convert Markdown tables into CSV format

QBO to OFX

Convert QBO files into OFX format for most finance apps

CSV to JSONL

Convert CSV rows into JSONL — one JSON record per line, also known as NDJSON, JSON Lines, or newline-delimited JSON

OFX to QFX

Convert OFX files into QFX format for Quicken

JSONL to CSV

Convert JSONL (NDJSON / JSON Lines) data into CSV format

QFX to OFX

Convert QFX files into OFX format for most finance apps

CSV to SQL

Generate SQL INSERT statements from CSV data

QFX to QIF

Convert QFX files into QIF format for older Quicken versions and legacy apps

CSV to Fixed Width

Convert CSV data into fixed-width column format

QIF to QFX

Convert legacy QIF files into QFX format for Quicken

Fixed Width to CSV

Convert fixed-width column data into CSV format

QBO to QIF

Convert QBO files into QIF format for older Quicken versions and legacy apps

CSV to LaTeX

Generate LaTeX table markup from CSV data

OFX to QIF

Convert OFX files into QIF format for older Quicken versions and legacy apps

QIF to OFX

Convert legacy QIF files into OFX format for most finance apps

Parquet to CSV

Convert Apache Parquet files to CSV format

Feather to CSV

Convert Apache Feather/Arrow files to CSV format

CSV to Parquet

Convert CSV into columnar Parquet format for efficient storage