Exporting your reports to spreadsheet applications like Excel gives you the flexibility to incorporate other data with your Quicken report data. Exported files from Quicken Essentials for Mac are compatible with the Mac and Windows versions of Excel. Quicken for Mac Comparison and Summary Reports The Comparison and Summary Reports can be exported to a CSV file, which can be opened in spreadsheet applications like Numbers and Excel or you can Copy to the Clipboard and paste into a spreadsheet application.
Click to expand.2.) You can also select '123 (.PRN) Disk File 3.) You do not need to supply an 'xls' extension, it does not help, nor change the behavior of Excel The only difference between a 'tab-delimited' file and a '123 (.PRN)' file is the 123 file is comma delimited. Both import into Excel with no problem and the only difference you can see during the process is the value in the 'Delimiters' section of the 'Text Import Wizard'. (Ok, if you give the file an 'xls' extension, you can click it and Excel will open it, which it won't do for 'txt' files, but for me, the fact that the file is not in 'xls' format makes this a poor choice: I like to know that my 'xls' files are Excel spreadsheet files, not wonder if maybe they are delimited files.
Once you have gone through the Text Import Wizard, you can save the resulting file as an xls file and have a true spreadsheet.).