My CSV import will not work into Quicken Business & Personal

Question

It seems like there are hundreds of different instructions for creating the CSV file for import.

Can someone tell me the exact column order?

Also, should they be text columns or general or number?

And for the "F1" - is the second digit a one, a capital i, a capital l?  This is crazy.

Chris_QPW · Answer

Here is a description:

https://info.quicken.com/win/import-transactions-from-csv-file

As for the types of fields, CSV files are purely text.  In a program like Excel it was field types, but when saving to CSV it will be turned into text.

q_lurker · Answer

F1?  Are you referring to when people abbreviate Financial Institurion as “FI”?

NotACPA · Answer

What type of account are you trying to import into?

What's happening when you try?