Re: Exporting resultset to EXCEL with carriage returns

[Marcin Marek]

Hello Marco,

I will suggest use XML import wizard instead of opening csv file in excel. Microsoft Excel makes it easy to import Extensible Markup Language (XML). Save your result from workbench as XML and use this file. Use the XML Source task pane to open and map XML.

Second option is to change the CSV file extension to TXT (when you open a TXT file with Excel it will start the text file import wizard where you can choose the delimiters and column types).

I hope this helps you.

--
Marcin Marek
MySQL Developer Tools

MySQL Workbench on Github: https://github.com/mysql/mysql-workbench
MySQL Workbench on Twitter: https://twitter.com/MySQLWorkbench
Report bugs to http://bugs.mysql.com
MySQL documentation can be found here: http://dev.mysql.com/doc/refman/5.7/en/