Can you import a CSV file into Quicken?

Yes. Quicken Classic for Windows imports banking transactions from a CSV through File, File Import, Banking Transactions, From (.CSV) File. Quicken Classic for Mac imports a CSV through File, Import, Mint.com File (CSV). Quicken Simplifi imports a CSV in its web app from an account's Import transactions menu. Each one needs its own fixed column layout, and none of them checks for transactions you already have.

What format does Quicken need for a CSV import?

Quicken for Windows reads ten columns by position: Date, Payee, FI Payee, Amount, Debit/Credit, Category, Account, Tag, Memo, Chknum. The first seven must be present on every row even when empty, and Date, Payee, Amount and Account need values. Dates are mm/dd/yyyy and amounts are signed, negative for money out. Leave FI Payee and Debit/Credit blank; they exist for old Mint files.

Is there a Quicken CSV import template?

Quicken for Windows has a Create Sample File button in its CSV import window, and Simplifi offers a downloadable template. Utilly has free templates for all three: Quicken for Windows, Quicken for Mac and Simplifi, each in the right columns and filled with 31 fictional transactions with known totals (29,597.43 in, 28,575.27 out), so you can test an import before using your own rows.

Why did my CSV import create duplicate transactions in Quicken?

Quicken's CSV import does not compare the file with what is already in the register. Every row is added, so importing the same file twice, or a file that overlaps dates you already downloaded, duplicates those transactions. Delete the extra copies and import only date ranges the account does not have yet. A QFX download from your bank does match existing transactions.

Can I import a CSV into Quicken Simplifi?

Yes, in the web app only. Open Transactions, select the account, choose Import transactions from the three-dot menu and pick CSV. Use the columns Date, Payee, Amount, Category, Tags, Notes, Check_No, dates like 3/13/2020, and a minus sign on money out. Each set of transactions can only be imported once, and categories only carry over if they already exist in Simplifi.

Can Quicken import an Excel file?

No. Quicken says it cannot import Excel workbooks, PDF statements or QuickBooks files. Put the transactions in the CSV layout for your version of Quicken and save the sheet as CSV UTF-8 (Comma delimited). If you only have a PDF bank statement, convert it to CSV first, then copy the date, description and signed amount into the template.

Import CSV into Quicken: Windows, Mac & Simplifi

Q: How do I import a CSV file into Quicken for Mac?

Use File, Import, Mint.com File (CSV). The file needs the Mint layout: Date, Description, Original Description, Amount, Transaction Type, Category, Account Name, Labels, Notes, with Date, Amount and Account Name filled in, no dollar signs or thousands commas, and debit or credit in lower case. Quicken for Mac always creates a new account named after the file; move the transactions into your existing account afterwards.

Yes, Quicken imports CSV files — but each Quicken product wants a different, fixed column layout, and a bank's CSV download almost never matches it as is. This guide gives the exact layout for Quicken Classic for Windows, Quicken Classic for Mac and Quicken Simplifi, the menu path for each, what goes wrong, and a free ready-filled template for each one so you can test an import before you touch your own data.

Short answer: on Windows, use File → File Import → Banking Transactions → From (.CSV) File with ten columns in this order: Date, Payee, FI Payee, Amount, Debit/Credit, Category, Account, Tag, Memo, Chknum (the first seven must be there; dates mm/dd/yyyy; signed amounts). On a Mac, use File → Import → Mint.com File (CSV) with the Mint layout Date, Description, Original Description, Amount, Transaction Type, Category, Account Name, Labels, Notes; it always creates a new account named after the file. In Simplifi, open the account in the web app, choose Import transactions and use Date, Payee, Amount, Category, Tags, Notes, Check_No. None of them can open an Excel workbook, and none of them skips transactions you already have, so import each date range once.

Free Quicken CSV import templates

Each template is already in the right columns and filled with the same 31 fictional transactions (Example Community Bank, Business Checking, September 2026): 11 deposits totalling 29,597.43 and 20 payments totalling 28,575.27, net +1,022.16. Import one into a test account first, check the totals, then replace the rows with your own.

Quicken for Windows template Quicken for Mac template Simplifi template PDF statement to CSV

On this page

Which Quicken do you have?
Import a CSV into Quicken for Windows
Import a CSV into Quicken for Mac
Import a CSV into Quicken Simplifi
Turn your bank's CSV (or PDF) into Quicken's layout
When QFX or QIF is the better file
Common CSV import problems
Check the import

1. Which Quicken do you have?

“Quicken” is three different programs with three different CSV importers. Pick the row that matches yours; the column layouts are not interchangeable.

	Quicken Classic for Windows	Quicken Classic for Mac	Quicken Simplifi
Menu	File → File Import → Banking Transactions → From (.CSV) File	File → Import → Mint.com File (CSV)	Web app: Transactions, pick the account, ⋯ → Import transactions
Columns	10, by position: Date, Payee, FI Payee, Amount, Debit/Credit, Category, Account, Tag, Memo, Chknum	9, the Mint layout: Date, Description, Original Description, Amount, Transaction Type, Category, Account Name, Labels, Notes	7, by header: Date, Payee, Amount, Category, Tags, Notes, Check_No
Lands in	The account named in the Account column (or one you pick, or a new one)	Always a new account named after the file	The account you opened before importing
Dates	mm/dd/yyyy	See the note on Mac dates	M/D/YYYY, as in Simplifi's template
Skips duplicates?	No	No	Each set of transactions can only be imported once
Investments	Separate investment CSV import	Not by CSV	Banking and credit card only

Not sure? Quicken Classic is the desktop program with a data file; Simplifi is the web and phone app with no data file. Quicken Classic for Windows and for Mac are different programs even on the same subscription.

2. Import a CSV into Quicken for Windows

Quicken Classic for Windows reads the columns by position, not by their names. The first seven columns must be present on every row, in this order, even when a cell is empty; the last three are optional, but if you use them they must be in this order too. A header row is optional.

#	Column	Required?	What goes in it	In the template
1	Date	Yes	mm/dd/yyyy; leading zeros optional (`5/31/2025` works)	`09/01/2026`
2	Payee	Yes	The name for the register	`ACH DEBIT GUSTO PAYROLL 0912`
3	FI Payee	Column only	Kept for Mint CSV files; Quicken ignores it, but the column must exist	blank
4	Amount	Yes	Signed: negative is money out, positive is money in. An unsigned amount counts as positive. Thousands commas are allowed	`-6420.18`
5	Debit/Credit	Column only	Also for Mint files. Quicken's help says to leave it blank and sign the amount instead	blank
6	Category	Column only	`Category:Subcategory`. A bracketed account such as `[Savings]` does not make a transfer	blank (you categorize after import)
7	Account	Yes	The Quicken account the row goes into	`Business Checking`
8	Tag	Optional	`tag1:tag2` for several tags	blank
9	Memo	Optional	Free text	blank
10	Chknum	Optional	Check number	`2041` on `CHECK 2041`

The first rows of the Windows template:

Date,Payee,FI Payee,Amount,Debit/Credit,Category,Account,Tag,Memo,Chknum
09/01/2026,ACH DEBIT GUSTO PAYROLL 0912,,-6420.18,,,Business Checking,,,
09/01/2026,STRIPE TRANSFER ST-K2M8Q4,,3184.27,,,Business Checking,,,
09/02/2026,CHECK 2041,,-1850.00,,,Business Checking,,,2041

A field that contains a comma goes in double quotes ("Office Supplies, Inc."). Save the file as CSV in UTF-8.

Steps (from Quicken's Windows help):

Back up your Quicken data file, then open it.
Choose File → File Import → Banking Transactions → From (.CSV) File. The same window has Create Sample File if you want Quicken's own example.
Review the format requirements, click Choose .CSV File to Import…, pick your file and click OK. If the layout is wrong, Quicken says what to fix.
If the Account column names an account that isn't in your data file, Quicken asks whether to ignore those rows, add them to an existing account you pick, or add them to a new account (Banking, Cash, Other Asset, Credit Card or Other Liability). To add history to an account you already have, pick the existing account — or simply put that account's exact name in the Account column.
Quicken shows a summary: transactions imported, new accounts, tags added. For a manual account, use the register's gear icon → Update Balance if the balance needs setting.

The banking CSV import covers banking, cash, credit card, other asset and other liability accounts. Investment transactions have their own CSV import (File → File Import → Investment Transactions → From (.CSV) File) with a different, 17-column layout; this guide and its templates are for bank and card accounts.

3. Import a CSV into Quicken for Mac

Quicken Classic for Mac lists its CSV import as Mint.com File (CSV), but Quicken's Mac help says any CSV in the right layout works. The layout is the one Mint used for its exports. Quicken's help shows it as an example sheet with these columns:

#	Column	What goes in it	In the template
1	Date	Must have a value	`09/01/2026`
2	Description	The payee / description	`ACH DEBIT GUSTO PAYROLL 0912`
3	Original Description	Mint's bank text; may be blank	blank
4	Amount	Must have a value. Signed numbers are allowed; no dollar signs and no thousands commas	`-6420.18`
5	Transaction Type	`debit` or `credit`, in lower case — Quicken uses it to show the row as expense or income	`debit`
6	Category	`Category:Subcategory`; may be blank	blank
7	Account Name	Must have a value	`Business Checking`
8	Labels	May be blank	blank
9	Notes	May be blank	blank

Every column has to be present even when it's empty. Quicken's example signs the amount and fills the type (-50 with debit, 8,000.00 with credit); the Mac template does the same, without thousands commas:

Date,Description,Original Description,Amount,Transaction Type,Category,Account Name,Labels,Notes
09/01/2026,ACH DEBIT GUSTO PAYROLL 0912,,-6420.18,debit,,Business Checking,,
09/01/2026,STRIPE TRANSFER ST-K2M8Q4,,3184.27,credit,,Business Checking,,

Steps:

Rename the file to the account name you want to see (for example Business Checking.csv) — the Mac import names the new account after the file.
Choose File → Import → Mint.com File (CSV)…, select the file and click Open.
Quicken creates a new account holding all the imported transactions. Quicken's help is explicit: you can't point a CSV import at an existing account.
To keep the history in an account you already use, select the imported transactions in the new account and move them to your real account (Quicken's support team suggests the same workaround), then delete the empty temporary account. Or keep the new account and rename it or change its type in its account settings.

A note on dates. Quicken's Mac help text says the Date column can be “D/M/YY or DD/MM/YYYY”, while its example sheet and Mint's own exports are month-first (US) dates. The Mac template uses month-first MM/DD/YYYY, like Mint. Because the two readings disagree, import the template (or three of your own rows) first and check that 09/15/2026 landed on 15 September; a day above 12 is the only way to see which order Quicken used.

Investment transactions can't be imported by CSV on the Mac.

4. Import a CSV into Quicken Simplifi

Simplifi imports CSV in the web app only (not the phone app), one account at a time, for banking and credit card accounts. Its downloadable template has seven quoted columns: "Date","Payee","Amount","Category","Tags","Notes","Check_No".

Date, Payee and Amount on every row. Simplifi's template writes dates as 3/13/2020 (M/D/YYYY); its help text asks for M/D/YY (1/1/22).
Money out needs a minus sign (-7); without it the row imports as money in.
Categories only carry over if the category already exists in Simplifi; a blank category imports as Uncategorized.
Each set of transactions can be imported once. If you delete imported transactions, importing the same file into the same account won't bring them back — you'd add them by hand.

Steps: sign in to the web app → Transactions → select the account (create a manual account first if needed) → the three-dot menu next to Filter → Import transactions → choose CSV as the source → confirm the account → drop the file in → Import. The Simplifi template starts:

"Date","Payee","Amount","Category","Tags","Notes","Check_No"
"9/1/2026","ACH DEBIT GUSTO PAYROLL 0912","-6420.18","","","",""
"9/2/2026","CHECK 2041","-1850.00","","","","2041"

5. Turn your bank's CSV (or PDF) into Quicken's layout

A bank download has its own columns — often separate Debit and Credit columns, a running Balance, a description split over two fields, sometimes a summary block above the table. Quicken won't map them for you, so open the bank file in Excel or Google Sheets next to the template and copy column by column:

Date → reformat to month/day/year (in Excel: select the column, Format Cells → Custom → mm/dd/yyyy).
Description → the template's Payee (Windows, Simplifi) or Description (Mac) column.
One signed amount. If the bank splits money in and out, use =Credit-Debit so payments come out negative. Remove dollar signs; on a Mac remove thousands commas too.
Leave the Balance column out. None of the three layouts has one.
Keep the template's header row and column order, delete the sample rows, and save as CSV UTF-8 (Comma delimited). Quicken can't import an .xlsx workbook.

If what you have is a PDF statement, there is no CSV to start from. Utilly's bank statement to CSV converter reads the PDF into a Clean CSV with Date, Description, Amount (already signed) and Balance columns, and checks the rows add up to the statement's ending balance. Its dates are written 2026-09-01, so reformat that column as in step 1, then paste Description and Amount into the template. Utilly doesn't write Quicken's CSV layouts directly; the templates on this page are the bridge. For Quicken for Windows, a QIF of the statement skips the column mapping; which route fits which Quicken is on how to import bank statements into Quicken.

6. When QFX or QIF is the better file

File	Use it when	Watch out for
QFX (Web Connect) from your bank	The bank still offers a Quicken download for those dates. Quicken matches downloaded transactions against what's in the register and puts them in the account you choose	Banks keep only so much history online; a home-made QFX often fails Quicken's bank-ID check
CSV (this page)	Older history, a bank without Quicken downloads, or months that only exist as statements	No duplicate check; layout must be exact; Mac always makes a new account
QIF	Quicken for Windows, into an account that already exists (File → File Import → QIF File); no column layout to get right	No duplicate check either. Quicken for Mac only uses QIF to start a new data file

For the QIF route, convert with CSV to QIF, Excel to QIF or bank statement PDF to QIF. What each QIF line means is on QIF file format, and the formats are compared on QBO vs IIF vs QIF.

7. Common CSV import problems

Problem	Usual cause and fix
Quicken (Windows) rejects the file's format	A column is missing, extra or out of order. All of the first seven columns must exist even when blank — FI Payee and Debit/Credit included. Start from the template rather than the bank file.
Every transaction imported as income	Amounts aren't signed. Money out must be negative (Windows treats an unsigned number as positive; Simplifi too). On a Mac, also check Transaction Type says `debit` in lower case.
Dates wrong or rows missing	Day and month swapped, or ISO `2026-09-01` dates. Use month/day/year and test a row with a day above 12.
Transactions imported twice	CSV imports don't check what's already there; reimporting the same file adds every row again. Delete the second copy and import only date ranges the register doesn't have.
Mac import created a new account	That is how the Mac importer works. Move the rows into your real account and delete the new one.
Transfers show as plain transactions	The Windows CSV import doesn't create transfers, even from `[Checking]` in Category. Link them by hand after import.
“Cannot import” an Excel file	Quicken doesn't import .xls/.xlsx (or PDF, or OFX on Windows). Save as CSV.
Simplifi won't re-import deleted rows	Simplifi only imports a set of transactions once. Re-enter them manually.

8. Check the import

Import one of the templates into a test account first. A correct import shows 31 transactions dated 1–30 September 2026: 29,597.43 in (11 deposits), 28,575.27 out (20 payments, including checks 2041, 2042 and 2043), net +1,022.16. Those are the same totals as Utilly's sample statement files, whose Beginning balance is 12,418.36 and ending balance 13,440.52. If your numbers differ, the sign or date handling is the usual reason. Then, with your own data, compare the register's totals with the statement for the same dates before you reconcile — a clean import doesn't prove the source file is complete.

Utilly isn't affiliated with Quicken. We haven't run these files through a live copy of Quicken; the layouts and steps follow Quicken's help pages.

Sources, checked November 8, 2026: Quicken Windows help, Import transactions from .CSV file and Import investment transactions from a .CSV file; Quicken, How do I import a CSV file into Quicken for Mac? and How do I import data into Quicken for Windows?; Quicken Simplifi help, How to manually import transactions and its CSV template.

FAQ

Related tools

Bank reconciliation checker: compare a bank statement to your books and list missing, duplicate and mismatched transactions.
Receipt to CSV: turn PDF or photo receipts and invoices into CSV, Excel, or QuickBooks and Xero bill imports.

How to import a CSV file into Quicken (Windows, Mac and Simplifi)