Home

Import data from the web in Excel Online

%3CLINGO-SUB%20id%3D%22lingo-sub-393913%22%20slang%3D%22en-US%22%3EImport%20data%20from%20the%20web%20in%20Excel%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-393913%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20import%20data%20in%20Excel%20Online%20just%20like%20I%20can%20do%20it%20on%20Excel%20on%20desktop%20%3A%20data%20%26gt%3B%20from%20the%20web%20%26gt%3B%20url.%20It%20works%20fine%20in%20Excel%2C%20but%20then%20I%20tried%20to%20open%20it%20in%20Online%20version%20and%20I%20get%20a%20error%20message%20%22actualisation%20of%20external%20data%20fails%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20are%20using%20a%20lot%20of%20these%20importations%20in%20G-sheet%20with%20the%20formula%20%22IMPORTDATA%22%20and%20would%20like%20to%20migrate%20these%20G-sheets%20to%20Excel%20Online.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks%20for%20you%20help%2C%3CBR%20%2F%3ERobin%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-393913%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-807548%22%20slang%3D%22en-US%22%3ERe%3A%20Import%20data%20from%20the%20web%20in%20Excel%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-807548%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F313491%22%20target%3D%22_blank%22%3E%40robin12%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20feel%20I'm%20the%20opposite.%20After%20having%20extensively%20used%20Google%20apps%2C%20I'm%20now%20at%20a%20small%20business%20using%20Office%20365.%20They%20upload%20documents%20to%20Sharepoint%20so%20the%20obvious%20thought%20to%20collate%20is%20to%20use%20Excel%20online%20with%20something%20similar%20to%20%22IMPORTDATA%22%20and%20this%20is%20just%20another%20thing%20I've%20discovered%20Excel%20online%20doesn't%20provide.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWonder%20if%20they%20would%20be%20interested%20in%20changing%20to%20Google%20Apps%20for%20Business.%20Haha.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-394440%22%20slang%3D%22en-US%22%3ERE%3A%20Import%20data%20from%20the%20web%20in%20Excel%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-394440%22%20slang%3D%22en-US%22%3EThe%20Online%20version%20of%20Excel%20is%20limited%20-%20think%20of%20it%20as%20a%20stripped-down%20version%20of%20Excel%20-You%20are%20unlikely%20to%20get%20this%20to%20work%20with%20using%20the%20Online%20version.%3C%2FLINGO-BODY%3E
robin12
Occasional Visitor

Hi,

 

I would like to import data in Excel Online just like I can do it on Excel on desktop : data > from the web > url. It works fine in Excel, but then I tried to open it in Online version and I get a error message "actualisation of external data fails".

 

We are using a lot of these importations in G-sheet with the formula "IMPORTDATA" and would like to migrate these G-sheets to Excel Online.

 

Many thanks for you help,
Robin

2 Replies
The Online version of Excel is limited - think of it as a stripped-down version of Excel -You are unlikely to get this to work with using the Online version.

@robin12 

I feel I'm the opposite. After having extensively used Google apps, I'm now at a small business using Office 365. They upload documents to Sharepoint so the obvious thought to collate is to use Excel online with something similar to "IMPORTDATA" and this is just another thing I've discovered Excel online doesn't provide.

 

Wonder if they would be interested in changing to Google Apps for Business. Haha.