IMPORTDATA(URL) in google doc

[mrzoogle]

Hi All,

Hope this message finds you well.

I was going through google spreadsheet and found this formula and would like to use it in
excel instead of using in google doc.

Is there something similar in excel 2010?

Thanks for your time.

Regards,

Z.

 

[Debraj]

Hi Z..

So do you think.. this is better than
Get External Data option in Excel..

or you want something like.. write GetExternalData("Chandoouserlist.html") and it will fill your file with all data..

think again.. which one is more user friendly..

 

[Hui]

Mr Zoogle

You didn't post a file or formula ?
or
A link where we can see what sort of data that you require

 

[mrzoogle]

Thanks for the reply.

@Debraj I am a big excel fan so no, excel is the best :D
I was hoping something like =GetExternalData("URL")

@Hui apologies, my bad...
I am posting the link which I found on web and the formual I am looking after is =importdata(URL) and I was hoping to have something similar in excel.
http://bit.ly/spreadsheet
Kind Regards,

Z.

 

[SirJB7]

Hi, mrzoogle!
AFAIK apart from what Debraj (ex-Roy) told you, there's no Excel function like Google Spreadsheets' IMPORTDATA
Regards!

 

[mrzoogle]

Hi SirJB7,

Thanks for the reply.

Is there anyway to achieve the results in cell C5 of this http://bit.ly/spreadsheet in excel ?

A workaround maybe?

Thanks for your time.

Kind Regards,

Z.

 

[bobhc]

Good day mezoogle

For a long time members have been asking for the ability to upload files so that they do not need to go to share sites and log in/watch the adds/download rubbish. When you post a question there is the facility to upload. The first most post explains this.

http://chandoo.org/forum/threads/file-upload.11644/

 

[SirJB7]

Hi, mrzoogle!
I don't know what do you want to retrieve from the 2 URLs of betaworks and cnn.
Follow b(ut)ob(ut)hc's advise and upload a sample file including the output required.
Regards!

 

[NARAYANK991]

Hi Bob ,

I think the issue here is not of an upload ; the poster has created a file in Google Spreadsheets , which he would like to transfer to Excel ; the whole point here is that transferring this outside of Google Spreadsheets will make the functions which are available within GS and which are not available in Excel just errors.

If you see the file in GS , there are just 4 columns :

A contains HTML links , B contains the link to the link shortener website https://bitly.com/, with the text in column A being passed as a parameter to the website. The website shortens the link which has been passed to it , and returns it , which is now available in column C.

The advantage may not be apparent in the links which have been used as examples in A5 and A6 , but if you see the links returned by websites such as DropBox or SkyDrive , they can certainly do with some shortening.

The functions which are made use of in this application are :

IMPORTDATA

CONTINUE ( though I don't understand what this does )

What the OP wants is the same functionality from within an Excel worksheet , if that is possible.

Narayan

 

[mrzoogle]

Hi NARAYANK991,

Thanks for explaining this in detail.

I will be more careful next time to explain what I am trying to achieve in details as much as possible.

Kind Regards,

Z.

 

[bobhc]

Good day Narayan

I was unaware that it was a Google file, I wrongly thought that an Excel sheet was made with the formulas in.