Sharing limited data without sharing the whole spreadsheet

Recently a friend asked me how he could share some data that he was working on with colleagues. The problem is that he can’t share the entire spreadsheet.

My suggestion is to use Google Spreadsheets and the ImportRange function to share limited ranges with another spreadsheet. What’s great about this method is that you can then share the second spreadsheet with other people without sharing the spreadsheet you’re working on.

To do this, create a second spreadsheet and wherever you would like your data to show up, enter =Importrange(“key”, “range”). The key is you need is in the URL of the spreadsheet that holds your original data (look for “key=…”), and the range is the group of cells that you need to import into your dependent spreadsheet (e.g. “A1:B7”).

I use this a lot to break very large spreadsheets into smaller, more manageable sizes for various teams. The dependent spreadsheets your colleagues will update every 30 seconds or so, so once you’ve set it up, go ahead and work off the original one and they’ll see the changes almost immediately.

About Finn Smith

Oregon... some places.... SF. Working in education, technology, and social impact (or some combination of the three).
This entry was posted in Google Apps Script, International Education and tagged , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s