Quicken Import CSV: Column Format for Windows and Mac

Quick Answer: Yes, Quicken imports CSV files, but each edition wants its own column layout. Quicken for Windows uses File > File Import > Banking Transactions > From (.CSV) File and needs seven columns in a fixed order starting with Date, Payee and FI Payee. Quicken for Mac uses File > Import > Mint.com File (CSV) with a different eight-column order. If you are adding to an existing account, a QFX file is usually the cleaner route.

A bank CSV almost never imports into Quicken as downloaded. Quicken expects specific columns in a specific order, with exact header behavior and date formats, and the requirements differ between Windows and Mac. The fix is to rearrange the bank's file into Quicken's layout in a spreadsheet, save it as CSV and import. This guide gives both layouts.

Can Quicken import a CSV file?

Both current desktop editions can import banking transactions from CSV:

• Quicken for Windows: File > File Import > Banking Transactions > From (.CSV) File, documented in Quicken's CSV import article for Windows.
• Quicken for Mac: File > Import > Mint.com File (CSV). Despite the menu name, Quicken's Mac CSV article says any CSV in the right format can be imported this way.

Neither edition imports Excel workbooks directly; save the sheet as CSV first. Quicken's import overview for Windows also lists Excel, QuickBooks, PDF and OFX files among the formats Quicken cannot import.

What is the Quicken for Windows CSV format?

The file must contain the first seven columns below, in this exact order, even when some are empty. The last three are optional but must follow in this order if used.

Text that contains a comma, such as "Office Supplies, Inc.", must be wrapped in double quotes. A header row is optional, but if you include one it must follow the same structure.

A minimal Windows file looks like this:

Date,Payee,FI Payee,Amount,Debit/Credit,Category,Account,Tag,Memo,Chknum
3/02/2026,Harper LLC,HARPER LLC ACH CREDIT,2500.00,,Income:Consulting,Business Checking,,,
3/04/2026,Office Depot,OFFICE DEPOT #1142,-84.17,,Office:Supplies,Business Checking,,,
3/05/2026,Rent,CHECK 1031,-1800.00,,Rent,Business Checking,,,1031

Importing on Windows

1. Open your Quicken data file and choose File > File Import > Banking Transactions > From (.CSV) File.
2. Read the format reminder in the dialog, then select Choose .CSV File to Import… and pick your file.
3. Select OK.
4. If an Account name in the file does not match a Quicken account, choose whether to ignore those rows, add them to an existing account or create a new account.
5. Review the import summary.
6. For a new or manual account, open the register, select the gear icon and choose Update Balance so the balance matches your statement.

Two behaviors to plan for: CSV imports do not detect or match transactions already in the account, so importing an overlapping date range creates duplicates; and transfers are not created automatically, so a payment to your credit card arrives as a plain withdrawal in one account only.

What is the Quicken for Mac CSV format?

The Mac layout is different, with eight columns in this order:

All eight columns must be present even when blank. On a Mac, importing a CSV always creates a new account named after the file; you cannot point it at an existing account. You can rename the new account afterward (right-click it and choose Account Settings…) and change its type. Investment transactions cannot be imported by CSV on the Mac.

The date rule on the Mac page is worth testing with a few rows before a large import, because US bank files normally use month-first dates.

How do you convert a bank CSV to Quicken's format?

Open the bank's CSV in Excel or Google Sheets and rebuild it:

1. Delete any rows above the header and any totals or balance rows below the data.
2. Insert or rename columns so they match your edition's order exactly, adding empty columns where needed.
3. If the bank uses separate withdrawal and deposit columns, combine them into one signed Amount: deposits positive, withdrawals negative. A formula such as =IF(D2<>"",D2,-C2) does it when C is withdrawals and D is deposits.
4. Strip currency symbols. On the Mac, remove thousands separators too.
5. Fill the Account column on every row with the exact Quicken account name.
6. Reformat dates to your edition's format and check a few by eye.
7. Save as CSV (comma delimited), keep the original, and import a few rows first as a test.

People searching for a "CSV to Quicken converter" are usually trying to skip these steps. Small free utilities exist that rearrange columns, and the steps above are what they do.

When is converting to QFX the cleaner path?

QFX is the Web Connect format banks provide for Quicken, and Quicken for Windows imports it through File > File Import > Web Connect File. Choose QFX over CSV when:

• you are adding transactions to an account that already has history; a QFX file comes in the same way as a download from your bank, rather than through the CSV path that cannot detect duplicates;
• you are on a Mac and want the transactions in an existing account rather than a new one;
• you have many statements and do not want to rebuild column layouts each time.

Check first whether your bank offers a Quicken (.QFX) download in online banking; that is free and needs no conversion. If you only have a CSV, the guide to converting CSV to QFX covers the options. If you have only PDF statements, QuickBankConvert reads the statement and can write a QFX file on its Plus plan, or a CSV you then lay out as above on any account; the Quicken integration page shows what the QFX contains.

For a checking-account walkthrough that starts from an Excel register, see importing checking transactions into Quicken from Excel, and for statement imports generally, importing bank statements into Quicken.

Troubleshooting a Quicken CSV import

Related guides

• Checking transactions from Excel into Quicken
• Statements into Quicken by format
• Turning a CSV into a QFX file
• Statement PDF to QFX