I recently ran into a problem with the CSV transaction importer in Quicken for Windows Canada.
Quicken was giving me:
“File selected does not have the required format.”
At first I assumed I had created the CSV incorrectly. I checked the required columns and created several versions of the file, but Quicken continued to reject it.
Then I discovered something interesting.
I went into:
File → File Import → Banking Transactions → From (.CSV) File
and used Create Sample File.
I then tried to import the sample file that Quicken itself had just created.
It rejected its own sample file with exactly the same error.
I was running Quicken Canada R67.8 (Build 27.1.67.8), and I subsequently updated Quicken to the latest available release. The problem remained.
The workaround
The Quicken sample file contained dates such as:
02/15/2026
which agree with Quicken's documentation specifying mm/dd/yyyy.
I changed the dates in the sample file to:
26/02/15
(yy/mm/dd)
and tried importing it again.
It worked!
I was then able to convert my actual Wise CSV transactions to the same date format and successfully import 166 transactions into my Quicken account.
So, at least on my Canadian installation, the CSV importer appears to reject the documented mm/dd/yyyy date format but accepts yy/mm/dd.
I thought I'd post this in case other Canadian Quicken users encounter the same “File selected does not have the required format” error.
Quicken's documentation says mm/dd/yyyy, but my installation would only accept yy/mm/dd.
Hopefully this helps someone else avoid the several hours of head-scratching that I went through! 😄
[Edited - Readability]
