Using Embeddable Google Spreadsheets for Group Editing

Sharon Elin asked me to write about the methodology behind how we posted a shared Google Spreadsheet that’s enabling anyone to add their Twitter name and blog link to ISTEconnects. We use Wordpress here on ISTEconnects, so this is a walkthrough specific to that platform:

1) Log into Google Docs (you’ll need a Google Account)

2) Click on New > Spreadsheet

3) Give your spreadsheet a layout (column names, color, etc.)

4) Go to Share > Publish as Web Page > Publish, then go to Share > Publish as Web Page > More Publishing Options > File Formate “HTML to Embed in Webpage” > Generate URL

5) That will give you embed code that looks like this: “<iframe> width=’500′ height=’300′ frameborder=’0′ src=’http://spreadsheets.google.com/pub?key=pVA0ivtry42CKTbgAGw&amp;output=html&amp;widget=true’<iframe>”

6) Create a new blog post, click the “HTML” tab on the post so you’re editing the code rather than post content, and paste in your embed code.

It’s sort of a ridiculously long process to do what should be something very simple, but once you get the hang of it, it’s a great way of enabling people to co-create documents! I haven’t tried this yet with Google Documents or Presentations but I suppose it would work to. Any ideas for what might be a fun thing for what else might be a fun thing for us to create together?

Similar Posts:

None Found