Microsoft Regional settings

When busy with a data migration where I needed to export Microsoft Excel workbook data to CSV for import into MySQL, I ran into some issues with export options, or rather the lack thereof.

I was extremely surprised that there are no options from within Excel to change delimiters and so forth. The solution is cumbersome and involves changing Windows operating system settings which apply to more than just Excel, so would almost certainly have to be changed back again after the exercise.

Additionally, I see no obvious way of defining any other settings I might want to change, for instance, I may want to escape column values with quotations.

Navigate like so in Windows 10: Control Panel » Clock, Language and Region » Change date, time or number formats » Additional settings

I found the answer here: http://www.howtogeek.com/howto/21456/export-or-save-excel-files-with-pipe-or-other-delimiters-instead-of-commas/

By foxbeefly

PHP / MySQL Developer

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.