Just a reminder, that in Excel 2010 and 2013 Power Query is an add-in and you can find out how to install it here. In Excel 2016 it comes pre-installed under the Data tab in the ribbon and is called Get & Transform.

Create a Facebook Power Query.

If you’re connecting for the first time, you’ll need to sign into your Facebook account.

The preview query.

In the Editor you will be able to expand columns with a double arrow icon in the right hand corner of the column heading to reveal more data.

Now you can analyse your Facebook data until you feel all warm and fuzzy inside, so many likes 🙂

How To Import All Your Facebook Data With Power Query - 39