Thanks for your help. I got hung up because the file extension is wrong. I created an 'excel' file and tried importing data from MD but got rejected the file extension is wrong. I know excel will accept the 'CSV' format but how do I change the MD format to CSV? Also, where do I find the file extension within MD?
No somethings wrong. I think I'm missing a step. Heres what I did.
Created a blank XL file to receive the MD data.
Selected the MD report I needed to export.
Changed the file extension to 'COMMA'
Selected the blank XL file from my Documents
. . . Nothing happened.
I'm doing something wrong but don'rt know what. I can't help wondering why it's so hard to exxport a MD file into XL.Most software make it easy. You just hit a button and . . . voilla!
That approach will not work. Moneydance, and for that matter Quicken, do not have the ability to write Excel files, it is necessary to take effectively data through an intermediate stage.
One method is to use the "Copy to Clipboard" Function that is at the top of the report window, then use the past function in Excel to place the data in a spreadsheet. Alas I do not expect this to work satisfactorily since the spreadsheet software cannot know where fields start and finish because there are no delimiters in the data.
The other method is to use the "Save" button at the top of the report window, then choose "comma delimited" from the format list and ensure that the filename chosen has a .csv extension.
Within Excel choose, if I recall correctly, the open function (I have not used Excel in a number of years I now use LibreOffice) and select the .CSV file that was saved. Excel should take you through an import dialog.