Thank you for this video. Is there away to transport data from all pages of the search result if the website does not show json code at the top of the page as this example do?
Is it possible to pull in web data from a site that requires a login (assuming you have the login and password)? So for example, let's say I wanted to pull data from my Twitter analytics dashboard into Excel. I can only access my Twitter data reports when I'm logged into my account. But once I'm in, I can see the latest metrics in tables or as graphs. I'd like to be able to link that data to a real-time Excel spreadsheet. Would you know a way to do this? Many thanks!
What version of Excel is this I have professional + 2016 and I have to open the get Data dropdown to find from web and instead of a prompt with the options basic and advanced it opens a web browser with Msn immediately. I don't get the option to "connect".
@@ExcelGoogleSheets You provided the link to the Power Query download. But you are asked what extension you are using to see parsed json in your browser? And I am asking the same question.
@@sooshil I don't use any extension. Firefox seems to parse it for me. If you're on chrome something like this should do it chrome.google.com/webstore/detail/json-formatter/bcjindcccaagfpapjjmafapmmgkkhgoa?hl=en
This was very easy to follow and I found exactly what I needed at 9:00 when you converted the lists into separate columns.
Finally the video I was looking for! Thanks a ton man! God bless you. 🙏
Excellent explanation!!!!!
in google sheet too, please
Amazing tutorial, thank you!
This was very helpful. Thank you
Very helpful, thanks.
Thank you very much for this detailed overview.
:)
It is not always as easy as you described! Sometimes you have the mix of Records, Text, and lists.
How to get json code is every site having this option?
And is it applicable for search box type website.if s how it is possible
Thank you for this video. Is there away to transport data from all pages of the search result if the website does not show json code at the top of the page as this example do?
Great video! Quick question - Wouldn't the offset need to be 1001 so you are not counting line 1000 twice when you append the table?
Offset will skip those lines. So offset 10 to will skip the first 10 records and start from record 11.
Thank you so much!!!
Is it possible to pull in web data from a site that requires a login (assuming you have the login and password)?
So for example, let's say I wanted to pull data from my Twitter analytics dashboard into Excel. I can only access my Twitter data reports when I'm logged into my account. But once I'm in, I can see the latest metrics in tables or as graphs.
I'd like to be able to link that data to a real-time Excel spreadsheet.
Would you know a way to do this? Many thanks!
Thanks
Great contect as always! Is there a way to import data from API into Google Sheets the same easy way as with Excel?
Not the same but you can ua-cam.com/video/EXKhVQU37WM/v-deo.html
What version of Excel is this I have professional + 2016 and I have to open the get Data dropdown to find from web and instead of a prompt with the options basic and advanced it opens a web browser with Msn immediately. I don't get the option to "connect".
It seems you are clicking on From Web from data section, but not from get & transform section. Try get data->from other sources->from web.
what's the name of the JSON extension you have installed?
It's called Firefox browser :)
What extension do you have installed?
www.microsoft.com/en-us/download/details.aspx?id=39379
@@ExcelGoogleSheets
You provided the link to the Power Query download. But you are asked what extension you are using to see parsed json in your browser? And I am asking the same question.
@@sooshil I don't use any extension. Firefox seems to parse it for me. If you're on chrome something like this should do it chrome.google.com/webstore/detail/json-formatter/bcjindcccaagfpapjjmafapmmgkkhgoa?hl=en