Instructions

  1. Go to your Google Docs >> open the document >> click Share >> See who has access >> Change >> Let people edit without signing in >> Save & Close >> Share >> Get the link to share >> copy the link >> click Save >> click Done. 
  2. Get back to your Google Site >> click Edit page >> Insert >> More gadgets >> Add Gadget by URL >> http://hosting.gmodules.com/ig/gadgets/file/117808631063490062819/url.xml >> Add >> customize Width & Height and insert the link to your spreadsheet >> OK >> Save. (This gadget  doesn't work recently so use the method below instead).
  3. Alternative method: Insert >> More gadgets and search for 'iframe'. Insert iframe gadget and configure it with the spreadsheet url.

List View

List view is not available in the new Google Sheets.
  1. Create a spreadsheet at https://g.co/oldsheets
  2. Click Share >> See who has access >> Change >> Let people edit without signing in >> Save & Close >> Share >> Get the link to share >> copy the link >> click Save >> click Done. 
  3. Get back to your Google Site >> click Edit page >> Insert >> Drive >> Select your spreadsheet.Select List under the view options.
  4. Save.


Old format