An example is like UbberSuggest or keyword Planner
This is a Seo tool when I enter a keyword then it gives me a different type of reports
I want to merge into a single sheet dashboard.
I wanna do it But confused
Can you suggest me a method or solution how to do?
Hi Ramzan,
Do you want to scrape the data from this site and present it in Excel, or do you want to write your own system where it takes a keyword then goes and retrieves data from somewhere, displaying those results in Excel?
I'll need a lot more detail to understand what you are trying to do.
You can scrape websites using several different approaches
https://www.myonlinetraininghub.com/tag/web-scraping
but either way it sounds like a big project that will need a lot of work.
Regards
Phil
I want to write my own workbook that has a collection of these reports, displaying results in excel
Hi Ramzan,
That is a big task, you should start with the scraping posts I linked to above.
Then maybe check our Dashboards course for presenting our results.
Regards
Phil
