#FridayHacks Make Excel Recognize The Comma Delimiter In A CSV File

This Month is mostly dedicated to learning Microsoft office. Most of us Zimbos the first App that we install on our machine after a fresh install is Microsoft office and Office comes with it MS Excel.

CSV( Comma Seperated Value, is a common data exchange format that is widely supported by consumer, business, and scientific applications. Because of this any CSV file that we download is automatically associated with the program. The best thing about Excel is that it can open and edit any CSV file, the biggest issue I have with excel is the way it reads the CSV data file.

By evasion, Excel is not set up to identify the comma as a delimiting character. The result is, whenever you open a CSV file, the data looks all wrong. The data in rows is consecutively added to columns as a substitute of staying in its CSV defined layout. It will become very hard even to read and much harder to edit work. Here’s a simple way to get Excel to read and display the CSV data correctly.excel 1

Open a new Excel file and go to the Data tab. Look for the ‘Get External Data’ set of tools and select ‘From Text’. Browse for and select the CSV file you have.excel 2

A dialog box will open up. Skip past the first step but check if the ‘Delimited’ option is selected underneath Original Data Type. In the second step, uncheck ‘tab’ and select ‘Comma’. Click Finish, excel will take time to add the date depending on the file size.
excel 3
I am yet to find a way to make it a default future so that you don’t have to redo the process ever time import data. CVS files can’t be opened first then edited, or change the delimiting character from the Data tab as it can only deal with one column at a time. That said every single time you want to open your CSV file and to have your data displayed correctly, you will have to import it into a fresh Excel file.

Via Techunzipped

Leave a Reply

%d bloggers like this: