How to Convert Format Excel to CSV with Semicolon Delimited

How to Convert Format Excel to CSV with Semicolon Delimited

Short Trick
In default if converting Excel (.xls or .xlsx)  to CSV the result is comma delimited. This is because setting list separator in your control panel.


If we want to convert excel to csv with semicolon delimited, the easy way is the changing list separator in control panel.
1. Control Panel
2. Region, Region and Language Option
3. In Tab Format, click customize this format
4. List separator, change from comma (,) to semicolon (;)
5. Ok, -Finish-

And we can try again convert to CSV the result is semicolon delimited.


Sort by: Published Date | Most Recent | Most Useful
Comments
  • Wow, I did NOT know this! I love learning something new every time I come to TechNet!

Page 1 of 1 (1 items)