Count Rows Using Power Query

Power Query or Get & Transform (From Excel 2016) lets you perform a series of steps to transform your Excel data.  One of the steps it allows you to take is to count the number of rows in your query.

And with just one step, you can get the count very easily!

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 Split the Date Using Power Query

In excel if you want to count the number of rows of your query then you can use power query or get & transform to complete it within some simple steps. 

Here I am going to mention all the steps to follow:

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

Count Rows Using Power Query

STEP2. Now in the second step follow this procedure:

For Office 365 or After 2016: Go to Data > Get & Transform > From Table 

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

Count Rows Using Power Query

STEP3. Now you have your power query editor then follow this:

Go to Transform> Table > Count Rows

Count Rows Using Power Query

STEP 4: Click Close & Load from the Home tab and this will open up a brand new worksheet in your Excel workbook with the row count!

Count Rows Using Power Query