Rename a Column Using Power Query or Get & Transform

Excel in Office 365 has a new set of a feature known as Get & Transform. We will rename a column using it.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 take is to rename a column by using multiple methods. 

You can also browse our Power Query Tutorial Catalog here.

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.

Previously in Power Query: How to perform Case Insensitive Filtering Using Power Query

STEP1. Firstly, select your data and press the shortcut Ctrl + T or by going to Insert > Table then it will turn into Excel Table.

How to Rename a Column Using Power Query 1

STEP2. Now in the second step follow this procedure:

For Excel 2016: Go to Data > Get & Transform > From Table 

For Excel 2013 & 2010: Power Query > Excel Data > From Table

How to Rename a Column Using Power Query 2

STEP3. After completing the second step you will open up the Power Query Editor.

Now we will try our first method.

Before following this step make sure your first name column is selected in your excel or double click the column name also you can press F2 too

We will change it to “Full Name

How to Rename a Column Using Power Query 3

STEP4. In the fourth step, we will show the second method of renaming.

So, right-click on that Last name column and select the Rename option.

How to Rename a Column Using Power Query 4

STEP5. Now from home option-click the Close & Load,

this will open up a new worksheet in the excel workbook with all the updated records.

How to Rename a Column Using Power Query 5

Now successfully you have your renamed columns.