Change Delimiter For Csv Export - Tip

[thomach]

Haven't had occassion to use this, but a colleague passed it on and it looks useful. (Couldn't find it referenced here on Oz.)

If you need Export Excel data to a CSV file but the data have commas in it, you can in Windows change the delimiter used in the export from outside of Excel -- specifally via the Control Panel.

Go to the Control Panel --> Regional and Language Options (or Date, Time and Regional Options --> Regional and Language Option on some machines) --> click the Customize button. In the dialog box that opens you will see and option for "List separator" in which you can change the comma to a different character --> click Apply then Ok and then Apply again. Now when you go into Excel and choose Export as CSV the new character will be used as the delimiter.

[Krishnakumar]

Hi Tom,

Thanks for the tip. I think it should be in Hey! That's cool section.

[Dave Hawley]

Thanks, Tom. Moved to hey that's cool.

[thomach]

One would think I'd know where (and where not) to stick my nose (posts) by now.