Import Data from CSV
Excel in 2016 has a new set of features known as Get & Transform or in earlier versions, it is known as Power Query. It provides a platform to perform a series of steps to help you to transform your Excel data. There is one step which will allow you to Import data from CSV if your data source is available at your desktop instead of Excel spreadsheet.
If your data is in inside a CSV (Comma Separated Values) which get written as .csv file. In this type of file, columns get separated by commas. It is very easy to import data from CSV direct into your Power Query by the following steps given below.
NOTE 1: You can create random excel workbook online here for practice purposes as I did in this tutorial.
NOTE 2: If You use Microsoft Excel Prior to 2016 Version, then You Need to download Power Query Separately.
Take this set of data of CSV file as an example for this blog:
STEP 1: Follow the Instruction below for your version of Excel
If you are Using Excel 365 then follow this:
Go to Data > Get Data > From File > From Text/CSV
Or if you are Using Excel 2013 or Excel 2010
then go for this: Go to Power Query > From File > From CSV
Select the CSV file that contains the data. Click Open.
STEP2. Hereafter following the first step you will be shown a preview of the CSV data,
if you found it good then press the Transform option.
STEP 3: After pressing the transform option, it will open a Power Query Editor for you.
Right then follow this;
Go to Home > Transform > Use First Row as Headers.
STEP 3: Now to open a new worksheet in your Excel workbook with the imported table,
Go to the Home tab and choose the Close & Load option.
There you go with your new table from the csv file: