Facebook analytics using Excel 2013 Power Query: Without programming!


Efficiency 365

In few minutes you can analyze any public FB page data.
Here we see how to analyze the likes and comments – instantly.

You need Excel 2010 or Excel 2013 (Professional Plus edition) or Office which is installed from Office 365.

  1. Close Excel if it is open 
  2. Download a new, extremely powerful tool Power Query for Excel
  3. Install the tool
  4. Open Excel
  5. You should now see a tab called Power Query
  6. Open Power Query tab and open the From Other Sources dropdown
  7. Choose Facebook

    image

  8. Choose me and Statuses (you can choose other types as well)

    image

    Remember that you can type any username or object id which has information accessible to you

  9. Click Ok
  10. Sign in to your Facebook account
  11. Save the credentials
  12. Now it will open a query result window and extract status update information from FB
  13. At this stage it shows few results. Later it will fetch all possible…

View original post 217 more words