Make Google Docs, Sheets, Slides & Forms public

To make a document, spreadsheet, or presentation available for a large audience to see, publish the file. After you publish your file you can send a new URL to anyone or embed into your website.

Publish file

  1. In Google Docs, Sheets, or Slides, open a file.
  2. At the top, click File and then Publish to the web.
  3. Choose a publishing option:
    • Spreadsheet: Publish the entire spreadsheet or individual sheets. You can also choose a publishing format.
    • Presentation: Choose how quickly to advance the slides.
  4. Click Publish.
  5. Copy the URL and send it to anyone you’d like to see the file. Or, embed it into your website.

Note: When you publish a chart to the web, people can see the data used to create it. Be careful when publishing a chart with private or sensitive info.

Turn off automatic updates

When you make changes to a published Docs or Sheets file, it will automatically publish the changes. To turn off automatic updates:

  1. Open a file in Google Docs or Sheets that you’ve already published to the web.
  2. Click File and then Publish to the web.
  3. Click Published content & settings.
  4. Uncheck the box next to "Automatically republish when changes are made."
  • To turn automatic publishing back on, check the box.

Note: You can't turn off automatic updates in Google Slides.

Stop publishing a file
  1. Open a file in Google Docs, Sheets, or Slides.
  2. At the top, click File and then Publish to the web.
  3. Click Published content & settings.
  4. Click Stop publishing.
How published files look when you share them

If you send someone the URL of a published file, they’ll see a version they can’t edit that looks different from yours. Here’s what others will see:

  • Documents: A version with no toolbar.
  • Spreadsheets: A version with no toolbar. People with "view" permissions can see charts, cell formatting, and the values of cells, but can’t view or edit formulas.
  • Presentations: A view-only version or a version in presentation mode with full-screen slides.
Control who can publish a file

File owners and editors can publish files. If you're the owner of a file and want someone else to publish the file, give them "edit" access.

If you’re the owner and don’t want anyone else to publish the file:

  1. Open a file in Google Docs, Sheets, or Slides.
  2. At the top right, click Share.
  3. At the bottom right, click Advanced.
  4. At the bottom, check the box next to "Prevent editors from changing access and adding new people."
  5. Click Save.

Embed files

You can make a document, spreadsheet, presentation, or form available to view on an existing website by embedding it in your site or blog.

Embed a document, spreadsheet, or presentation
  1. Open a file in Google Docs, Sheets, or Slides.
  2. At the top, click File and then Publish to the web.
  3. In the window that appears, click Embed.
  4. Choose a publishing option:
  • Spreadsheet: Choose to publish the entire spreadsheet or individual sheets.
  • Presentation: Choose a presentation size and how quickly to change the slides.
  1. Click Publish.
  2. Copy the HTML in the text box and paste it into your site or blog.
Edit embedded spreadsheets

If you’re embedding a spreadsheet, you can show or hide parts of the spreadsheet after you publish to the web.

  1. Open a file in Google Sheets.
  2. At the top, click File and then Publish to the web.
  3. In the window that appears, click Embed.
  4. Click Publish.
  5. Copy the code in the text box and paste it into your site or blog.
  6. To show or hide parts of the spreadsheet, edit the HTML on your site or blog.
  • gid=: The sheet ID.
  • range=: The rows and columns that are published to the web. For example, A1:B14.
  • widget=: True or false. If true, the sheet tab is displayed at the bottom.
  • headers=: True or false. If true, row numbers and column letters are displayed.
  • chrome=: True or false. If true, the title and footer are displayed.
Embed a form
  1. In Google Forms, open a form.
  2. At the top right, click Send.
  3. At the top of the window, click Embed.
  4. To copy the HTML that appears, click Copy.
  5. Paste the HTML into your site or blog.

Related article:

 

Was this article helpful?
How can we improve it?