Are you social marketeer and you want to get deep insights of your competitor or page related to your niche? But the problem is you’re no programmer! Well, we got you covered and I’m here to help you extract/scrape ANY public Facebook Page Posts Data to Excel using Facebook Graph API without programming and yes, it’s free!
You can insights to and Data you can extract/scrape ANY public Facebook Page Posts Data to Excel using Facebook Graph API without programming are:
- The number of likes,shares, and comments for each post
- The number of Facebook reactions (Like,Love,Haha,Wow,Sad,Angry) for each post
- The message of each post (Facebook status messages)
- Facebook IDs for the users who have liked, commented on or shared a post
- Facebook post comments for each post
So what are we waiting for? Let’s get going!
Step-by-Step process to extract/scrape ANY public Facebook Page Posts Data to Excel using Facebook Graph API without programing
Step 1: Get an access token from Facebook Graph API Explorer
This is a must step before you initiate scraping. You need to:
- Login to your personal Facebook Account
- Go to Facebook Developers Tools
- And then you’ll get an access token as shown below
This token expires after 2 hours and if you are in search of never expiring access token, you need to setup your own Facebook Developers Account (don’t worry, I repeat, you need no coding knowledge )
To get an Access token that never expires:
- Go to Facebook Apps
- Click Add a New app
- You will be asked to fill up the details (words like Facebook, FB are prohibited in an App name)
- Go to Settings → Basic
- There you get App ID and App Secret
This is it, put in this format App ID|App Secret and it is your never expiring access token.
Step 2: Get the Page ID of the Facebook page you’re trying to get insights of.
- Get the Page URL like https://www.facebook.com/futurism
- Note the Page-username, for above URL, its “futurism”
- Put the page username and Access token in the URL
- like https://graph.facebook.com/futurism?access_token=EAACE (truncated)
Note: You must enter your own access token, above is just an example and you get Page ID like shown in the screenshot.
Step 3: Extract/scrape ANY public Facebook Page Posts Data to Excel using Facebook Graph API
- Go to
Note: You can get 1st 100 posts insights in every page in chronical order
I put like
Scroll to the bottom of the page, you’ll see pagination
Scraping between Specific Dates:
The data you obtain via above link needs to be converted so for that follow next step:
Step 4: Converting JSON file to CSV/Excel Sheet
- Go to Online JSON to CSV/Excel Converter
- Copy the data from Step 3
- Paste it and you’ll automatically receive CSV table
- Click Download the entire CSV
If you still want to extract more data, scroll to the bottom of the JSON response and copy like below URL
Unfortunately,if you enter this URL into your browser as it is,it will bring an error.Reason being it has these values(\u002528,\u002529) which can’t be interpreted by the browser.Actually,these values represent the ( and ) respectively.
So we need to clean the URL before entering into the browser.Copy and paste the URL into Notepad text editor for Windows.Then use the find and replace all feature.Find ‘\u002528’ and replace all with ‘(‘ then find ‘\u002529’ and replace all with ‘)’.(everything without quotes)
And we final URL like
Paste it in URL box and you’ll get next 100 JSON data and go through Step 4 again to get CSV file.
Step 5: Analysis
As you have received CSV file, now you can sort which posts received the most likes in descending order
Same procedure can be repeated for the Comments and Shares.
Step 6: Extracting the Facebook ID of Users who commented, liked or shared:
You need to get the post ID of which you are trying to extract data:
Step 6a: Extracting the Facebook ID of users who liked:
- Go to https://graph.facebook.com/post-id/likes?limit=2000&access_token=EAACEdE (Truncated)
- Copy the JSON data and follow Step 4
Step 6b: Extracting the Facebook ID of users who commented:
- Go to https://graph.facebook.com/post-id/comments?limit=900&access_token=EACEdE (Truncated)
- Copy JSON data and follow Step 4
Step 6c: Extracting the Facebook ID of users who shared:
- Go to https://graph.facebook.com/post-id/sharedposts?limit=2000&access_token=EAACEdE (Truncated)
- Copy JSON data and follow Step 4
Step 7: Extracting the Reactions for every post
- Go to Quintly
Note: A free trial account will enable you to try all the packages for 14 days without putting in a credit card. You will be able to export data into Excel/PowerPoint format, or alternatively, you can sign up for a totally free account which allows you to analyze a maximum of 3 Facebook profiles and 1 month of data. However, the free account does not enable you to export data into Excel or PPT format – you can only export data from your free account into PDF/PNG/JPG format.
- Sign up and Add profile
- Analyse the Reactions data
With all this above knowledge, you are about to get very deep insights of your competitor and this might help you in your marketing. So, what do you think of this SUPER-POWER being able to extract/scrape ANY public Facebook Page Posts Data to Excel using Facebook Graph API.