CSV Export Field Separator Issues

patrick1gleeson's profile image patrick1gleeson posted 5 years ago in General Permalink

Unfortunately, my CSV exports to Excel have suddenly had formatting distorted. Separate columns displayed in SQL are mashed together into the same Excel column. One of my coworkers is having no such issues. I believe the problem stems from our field separators: mine is "\t" while theirs is ","

It doesn't seem as though I am able to adjust the field separator the desired value. Any help here would be deeply appreciated, and I can elaborate further if necessary!

ansgar's profile image ansgar posted 5 years ago Permalink

You could post a screenshot of the export dialog here. By the way you can press Ctrl-V here for pasting an image.

danish's profile image danish posted 3 years ago Permalink

I am not able to change field separator when export to csv. Any reason? image description

1 attachment(s):
  • Screenshot_3
ansgar's profile image ansgar posted 3 years ago Permalink

These fields are disabled in Excel mode, as HeidiSQL should know how Excel wants it :)

If you need a custom CSV file, please use the "Delimited text" option instead.

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