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.

Related Conversations
Pulling data from one tab to another
krysphares in Excel on
6 Replies
How to export Office 365 mailbox to PST?
alainajodi in Office 365 on
8 Replies
Decimal separator after CSV import
Luca Rivoira in Excel on
6 Replies
Maps Data for Scotland
Chris Nicol in Excel on
19 Replies