Power Query or Get & Transform (In Excel 2016) lets you perform a series of steps to transform your Excel data.

But what if your data source is not in your Excel spreadsheet but located on your desktop?

If it’s inside a CSV file – Comma Separated Values which is denoted by a .csv file extension & where the columns are separated by commas – it’s very easy to import data from csv and right into Power Query! 

It’s very common nowadays to get data in the comma-delimited format.

Let’s suppose you have this set of data from the csv file:

Import Data from CSV Using Power Query

DOWNLOAD EXCEL WORKBOOK AND SOURCE FILE

STEP 1:

Using Excel 2016 (screenshot below)

Go to Data > New Query > From File > From CSV

Using Excel 2013 or Excel 2010

Go to Power Query > From File > From CSV

Import Data from CSV Using Power Query

 

Select the csv file that contains the data.  Click Import.

Import Data from CSV Using Power Query

 

A preview of the csv data will be shown.  If it looks good, press Edit.

Import Data from CSV Using Power Query

 

STEP 2: This will open up the Power Query Editor.

Go to Home > Transform > Use First Row As Headers

This will give your table the correct Column Headers.

Import Data from CSV Using Power Query

 

STEP 3: Click Close & Load from the Home tab and this will open up a brand new worksheet in your Excel workbook with the imported table.

Import Data from CSV Using Power Query

You now have your new table from the csv file!

Import Data from CSV Using Power Query

Import Data from CSV in Excel

Import Data from CSV Using Power Query

 

HELPFUL RESOURCE:

Import Data from CSV Using Power Query

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Create Index Columns Using Power Query Power Query lets you perform a series of steps to transform your Excel data. One of the most common steps I do, is I want to add an index column that serves as a row counter of my data. There is the alternative method of using the ROW formula in Excel. However if we simply ...
Reverse Rows Using Power Query Power Query lets you perform a series of steps to transform your Excel data.  One of the steps it allows you to take is to reverse the order of rows very easily. DOWNLOAD EXCEL WORKBOOK   To provide a quick comparison, it's not straightforward to reverse rows in Exc...
How To Install Power Query in Excel 2010   Power Query is a new add-in that was introduced in Excel 2013 by Microsoft and was that popular that they made it backward compatible with Excel 2010. CLICK TO SEE THE TUTORIAL ON HOW TO INSTALL POWER QUERY IN EXCEL 2013   So what is Power Query? We...
Split First & Last Name Using Power Query There are times when you receive a data set of employee full names in one column and you want to separate the full name into first name and surname in separate columns. This is a common task and most people may refer to complex formulas to do this and waste lots of time in the...