by Jack Dougherty, last updated March 1, 2017
To share live spreadsheet data with other people, use Google Sheets (https://www.google.com/sheets/about/). Requires a free Google Drive account.
1) Sign in to your Google Drive (http://drive.google.com), and in the New menu, select Google Sheets.
2) New spreadsheets are private by default. Only the owner can view and edit.
3) To open your spreadsheet to others, click the blue Share button.
4) To share data with specific individuals, enter their Google usernames.
5) Or, to share data more widely, click the Advanced button on the next screen. (I wish Google made this button larger!)
6) Click the Change button and decide on Link Sharing settings:
- Public on the web (anyone can find your data)
- Anyone with the link (similar to an unlisted phone number)
- Off (only specific people you list by Google usernames)
Below those settings, select the Access level:
- Can view
- Can comment
- Can edit (for co-authored data)
7) Select Save, and scroll down on the next screen to select Done.
Tip: To avoid sending a long Google Sheets link to others, use a free link-shortening service such as Bit.ly (http://bit.ly). Requires a free account.
- "Share Files from Google Drive," Google help page, https://support.google.com/docs/answer/2494822
- Jack Dougherty, "How to Co-Author and Peer Edit with Google Docs," Web Writing: How and Why for Liberal Arts Teaching and Learning, (2015), http://epress.trincoll.edu/webwriting/chapter/how-to-google-docs
Improve this book: Donate to DataViz students and add comments or revisions.