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. 

Previously in Power QueryHow to Import Data from XML Using Power Query?

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:

Import Data from CSV

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

Import Data from 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.

Import Data from CSV

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.

Import Data from CSV

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

Import Data from CSV
By this, you will get the correct Column Headers in your Excel table.

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.

Import Data from CSV

There you go with your new table from the csv file:

Import Data from CSV