export to csv, the separator is ;

niknah posted 7 years ago in Import/Export
When I use tools > export grid data to file.
Pick .csv

The columns aren't opened properly in excel because the separator is ;

It'd be nice to have an option that exports everything, not just limited to 1000 rows.

I'm using v6.0.0.3603
ansgar posted 7 years ago
Set your CSV characters in Tools > Preferences > Export .

To export more than the limited number of rows in a grid just press Ctrl+End to fetch all, before exporting.
niknah posted 7 years ago
Thanks a lot!
This is nice tool, I had tried mysql workbench originally but I couldn't even switch between the tabs without some error message coming up.
ansgar posted 6 years ago
See issue #1499 for enhancements on this feature.
ansgar posted 6 years ago
In the new dialog in r3796 you can simply select "Excel TSV" which sets the right delimiters.

Please login to leave a reply, or register at first.