WorldServer - how to open an exported Term Database in CSV format in Microsoft Excel and display the content as columns

After exporting my Term Database in Delimited File: Simple Format or CSV: Advanced Format, when I open it in Microsoft Excel, the text displays all in one line and is not easily readable.

How do I get it to display in columns?

Follow these steps:

1- Open the exported Term Database in CSV format in Microsoft Excel
2- Go to the Data tab
3- Click on Text to Columns 
4- Select Delimited as the file type in Step 1 and click Next



5- Select Comma as a Delimiter and click Finish.



Now your Term Database will display in columns.

These articles might be relevant:

SDL WorldServer - how to export Term Databases and export options
How do I prevent the import of duplicated terms into my WorldServer Term Database?
How to add a new entry in a Term Database in WorldServer
When exporting a Term Database from WorldServer in Tab delimited or CSV format, the translated terms have character corruption