Solved Export Quicken to Excel 2010

When exporting some of the reports generated in Quicken 2010 to Excel 2010, some headers appear with chinese/japanese characters. i.e. http://img5.imageshack.us/img5/4139/chinesetext.jpg. Anybody seen this before??

Hi Meebers,

Are you exporting to CSV from Quciken? How does the CSV look if you open it in a text editor?

Golden said:

Hi Meebers,

Are you exporting to CSV from Quciken? How does the CSV look if you open it in a text editor?

Click to expand...

When exporting data from quicken, the choice of "report to excel compatable format" is a tab delimited txt file. This looks normal when viewed in a txt editor. However, when I started the delimiting process in Excel, I noticed that Excel thought it was a "936 chinese simplified (GB2312)" type text. I then selected 20127 US-ASCII as the default and that produced normal results. Have been doing excel for 10 yrs and still learn something everyday. I then generated a simple txt type tab delimited file in notepad, opened that file in Excel and it correctly identified the text as a 437:OEM United States File Origin. Why Excel thinks that Quicken reports are chinese type txt file is a question. (Maybe Quicken is writen by Chinese programers) Tx for giving me a path to find the solution.

Cool. I find this kind of problem often when trying to export to Excel compatible formats with lots of other software. I now always go to CSV/ASCII, and then import that into XLX.

Regards,
Golden