csv and Excel encoding
I often use Excel for sending queries results to others.
But when exporting from Heidi to csv file and opening it in Excel (2010) i get wrong encoding.
My table is filled with UTF-8 data.
There is an option in Excel to import file - in this way I can choose encoding (ex. UTF-8), but it is much more uncomfortable then just opening Excel file.
Can anything be done?
Whatever, good old Mysql-Front used to have a broken though practical ODBC import/export feature. I don't know if ODBC is still a mainstream technology but it has the benefit of being more generic since you have ODBC drivers for almost any data source, including Excel.
I'd particularly prefer ODBC :)
If I will save file as csv, excel won't open it correctly (without importing file)
If I will save ( manualy ext. change! ) as .tsv, and then manualy assign excel to this file types - it's working. But this is still very complicated solution.
We need xls(x) export :)
Excel tweak, see http://www.heidisql.com/forum.php?t=8226
depending on the system's regional settings, it may expect a semicolon as a separator instead of a comma, since in some languages the comma is used as the decimal separator
So, the solution in Heidi should be to use comma by default and semicolon if decimalseparator is comma (which is the case in Germany).
Use semicolon separator for Excel if system decimal separator is comma. See http://www.heidisql.com/forum.php?t=8226
Of course, it's not clear whether Microsoft Excel cares about it and Excel behaviour is what actually matters to almost everyone.
Please login to leave a reply, or register at first.