How to import data from google spreadsheet?

[xls_fan]

Hello!

I have a google spreadsheet which is generated from a google bio-data form's responses submitted online. I need to creat individual bio-data format which will import data from that google spreadsheet.

Is it possible to creat a workbook in which each worksheet will import data from each row of that spreadsheet chronologically? So that each worksheet will be a format for individual bio-data.

Or how to creat a master worksheet which can pull data from each row of that google spreadsheet?

Thanks in advance.

[amit.wilson]

X,

are you familiar with google app script? Shouldn't be very hard to write out a script to do what you are saying in google sheets.

Send me a direct message if you'd like me to help.

Cheers

[MarvinP]

Hi xls_fan,

I've been seeing more and more Google spreadsheet questions lately. I wonder if they have a site for all those questions. I also wonder how much different Excel is from Sheets?

I don't think this is really the place to ask Sheets questions. It is similar to asking WordPerfect questions to Microsoft Word experts.

It just doesn't seem right to me. Sorry.

[xls_fan]

Hi MarvinP,

I guess spreadsheet and workbook are the same and It's okay to ask help here.
Please provide me any solution if I want to do the same job that I mentioned above from a worksheet instead of a google spreadsheet.

[MarvinP]

Are you trying to take a Google Sheets workbook with many tabs and pull them into Excel or a single sheet in the Google sheets file?

[xls_fan]

Are you trying to take a Google Sheets workbook with many tabs and pull them into Excel or a single sheet in the Google sheets file?

Either way will work. I need to pull data from a single sheet (other tabs has no data) of a google workbook to either a google worksheet or a excel worksheet.

[xls_fan]

I'm marking this thread as "Solved " because I'm afraid my query may be not clear to all and posting a new question with modification.

New Post: http://www.excelforum.com/showthread...89#post4439989