As mentioned in a previous post of mine, I mentioned an area in Excel 365 named Get & Transform, where we can search for data sources, make connections and then modify the data. In the area Get & Transform, we now have the power to create New Queries from multiple data sources that are now available.
As Microsoft says: We Connect, We Transform, We Combine and then Share. In this post, I will describe how we can Import Data From Facebook in Excel 365. All you need to do is to keep on reading.
We select the Data tab and from the left area of the ribbon named Get & Transform we select the command Get Data as shown below. From the drop-down menu that appears we select the command From Online Services and from the sub-menu that appears on the right we select the command From Facebook as shown in the image below.
Once we select the From Facebook command, the Connecting To A Third-Party Service dialog box appears as shown below. Here we are informed that Facebook connector is a third-party service and that if we are okay by connecting Excel with it. If we agree we just press the Continue button located at the bottom right corner of the dialog box.
Once we select the Continue button the Facebook connector dialog box appears as shown below. Here we have the two following options available which are:
Me, User Name or Object ID: In this case the command available is Me.
Connection: By selecting the drop-down menu, we can select and establish which Connection we want to use. The Connections available are many to choose from where some of them are Books, Comments, Feeds, Friends, Games etc. For this post, I have selected the Connection to be used is Posts. Once selected, we press the Ok button at the bottom right corner in order to proceed.
After a few seconds, all the data that has to do with my Posts in Facebook, has been loaded in the next dialog box as shown below. At the bottom right corner of the dialog box is located the button Load: If we select the arrow next to the Load command, we can either Load the data in the current Worksheet, or Load To the data to a different Worksheet, a Table, a PivotTable Report, a PivotChart or just create a Connection. Next to the Load command is the Transform Data command and then the Cancel button where it will cancel the whole procedure if we select it.
If we select the Transform Data command, the Power Query Editor will appear as shown in the image below where we can do all the necessary adjustments that we want to do.
By following the similar procedure, we can Import Data from Other Online Sources.
Below you check out the video describing how to Load Data From Facebook in Excel 365.
Don’t Forget To Subscribe To My YouTube Channel.