WHY CAN'T I IMPORT DATA FROM WEB ON EXCEL (WEB APP/SERVICE)

I'm sure you know Microsoft but the question is how well do you know Microsoft? You'd be amazed about the number of Apps and Services you ain't taking advantage of (really!) 

Microsoft 365 (which includes Office Apps; Word, Excel, Powerpoint...) can be categorized into; 

• Microsoft/Office Desktop (the one you install on your PC) 
• Microsoft/Office Web App/Services (when you use it via your browser) 

Is the above clear? as it will help you continue. 

There are some features that aren't available yet on the web version (Microsoft/Office services/Web App), meaning you can only access them when you download and install Microsoft packages (say Excel) on your PC, unfortunately, the "import from web" is one of them. 

You may checkout Microsoft documentation to figure out the differences between the WEB (version) of EXCEL and the DESKTOP (version) here;

https://support.microsoft.com/en-us/office/differences-between-using-a-workbook-in-the-browser-and-in-excel-f0dc28ed-b85d-4e1d-be6d-5878005db3b6 

 

https://support.microsoft.com/en-us/office/data-import-and-analysis-options-3ea52160-08bc-45ac-acd9-bc4a11bcc2a2

Interested in becoming a Data Analyst? 

Join the #30DaysOfLearning