Import Data from Webpage in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1661198%22%20slang%3D%22en-US%22%3EImport%20Data%20from%20Webpage%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1661198%22%20slang%3D%22en-US%22%3E%3CP%3EHello...%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20import%20a%20table%20from%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fcoinpaprika.com%2Ftag%2Fgaming%2Fhome-overview%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fcoinpaprika.com%2Ftag%2Fgaming%2Fhome-overview%3C%2FA%3E%26nbsp%3Binto%20Excel.%20When%20i%20use%20the%20Import%20Data%20from%20Web%20option%2C%20no%20table%20is%20detected%20by%20Excel.%20If%20I%20try%20to%20transform%20the%20data%2C%20it%20takes%20me%20down%20a%20rabbit%20hole%20and%20still%20I%20am%20not%20able%20to%20retrieve%20the%20data.%3CBR%20%2F%3E%3CBR%20%2F%3EHowever%2C%26nbsp%3B%26nbsp%3Bwhen%20I%20tried%20the%20same%20with%20Power%20BI%20Desktop%2C%20the%20same%20worked%20perfectly.%3CBR%20%2F%3E%3CBR%20%2F%3ECan%20anyone%20tell%20me%20how%20to%20import%20such%20data%20in%20excel%3F%20(Screenshots%20Attached)%3C%2FP%3E%3CP%3EThank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1661198%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1661621%22%20slang%3D%22en-US%22%3ERe%3A%20Import%20Data%20from%20Webpage%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1661621%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F545848%22%20target%3D%22_blank%22%3E%40Jodhvir%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPower%20Query%20for%20Excel%20is%20bit%20behind%20the%20one%20for%20Power%20BI%20Desktop.%20That's%20only%20wait%20when%26nbsp%3BWeb.BrowserContents%20will%20be%20added%20to%20Excel%20version.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1661644%22%20slang%3D%22en-US%22%3ERe%3A%20Import%20Data%20from%20Webpage%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1661644%22%20slang%3D%22en-US%22%3EThank%20you.%3CBR%20%2F%3EIs%20there%20still%20any%20other%20method%20via%20which%20I%20can%20import%20this%20data%20in%20Excel%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1661778%22%20slang%3D%22en-US%22%3ERe%3A%20Import%20Data%20from%20Webpage%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1661778%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F545848%22%20target%3D%22_blank%22%3E%40Jodhvir%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESorry%2C%20I%20don't%20know%20the%20way%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

Hello...

I am trying to import a table from https://coinpaprika.com/tag/gaming/home-overview into Excel. When i use the Import Data from Web option, no table is detected by Excel. If I try to transform the data, it takes me down a rabbit hole and still I am not able to retrieve the data.

However,  when I tried the same with Power BI Desktop, the same worked perfectly.

Can anyone tell me how to import such data in excel? (Screenshots Attached)

Thank you.

4 Replies

@Jodhvir 

Power Query for Excel is bit behind the one for Power BI Desktop. That's only wait when Web.BrowserContents will be added to Excel version.

Thank you.
Is there still any other method via which I can import this data in Excel?

@Jodhvir 

Sorry, I don't know the way

thank you once again Sergei.