Opening .CSV Files with Excel - Quick Tip on Delimited Text Files

While opening a .CSV file generated by an Atlas Copco MicroTorque Controller I noticed my excel spreadsheet was a mess. This video tutorial is a quick tip showing how to open any jumbled csv file with Microsoft Excel using the text import wizard and delimiter options.

While older versions required you to use File & Import the newer Excel version got rid of the import option and requires you to manually open the file (rather than double clicking it in your file explorer).

Atlas Copco CSV files generated by the MTF6000 controller use the semicolon as a delimiter, but other CSV files you are opening may use another format. Standard CSV files that use commas to seperate the value should open without having to manually change the delimited option. Good luck out there on organizing your data!

Music: Ambient Gold by Harris Heller

[nubbit]

You can also get the correct data without reopening the file by selecting the column which contains the data(which is the first column when opening a csv from windows explorer) and going to the "Data" tab and press the "text to columns" button which opens the same wizard as shown in the video