CSV (Comma Separated Files) formats are used to store and transfer different types of data, the most common of which are contact data and statistical data. While the Excel sheet automatically recognizes and reads CSV files, most of the time, a CSV file opens with all encoded data when opened in Excel. This can be annoying, especially if you're trying to open crucial office data.
Fortunately, however, there isn't much to worry about as you can transfer or import data from CSV files to MS Excel quite easily. Let's see how.
Also Read: 14 Best Free CSV Editors For Windows 10
Solution: via the data tool in Excel
Step 1: Open a blank space MS Excel and click Data tab on the toolbar. Now click Get external data in the upper left corner and select From the text.
Step 2: From archive location, select the file CSV file you want to convert and click import on background. For example, let's select the file FL_insurance_sample (file csv) Here.
Step 3: A Text import wizard, check if the Delimited option is selected and then click The next.
Step 4: In the next window, under the file Delimiters section, check the box next to Eat and click The next.
Step 5: In the next window, let everything be as it is and click To finish.
Step 6: A Import data dialog box, let the Existing spreadsheet marked and click ok.
That is. Your CSV file is now imported into MS Excel and now all you can see is your comma separated file.