Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

CSV Export Field Separator Issues

patrick1gleeson's profile image patrick1gleeson posted 2 months 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 2 months 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.

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