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.
Important: Based on your account’s settings, when you publish a file, you can make it visible to everyone on the web, everyone in your organization, or
a group of people in your organization. Be careful when publishing private or sensitive info.
Publish file
Important:
- 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.
- Any changes you make to the original document will be
updated in the published version. The automatic update might take a few minutes.
- To remove a file from the web, you must stop publishing it. Learn how to stop publishing a file.
- To stop sharing a file with collaborators, learn how to change sharing permissions.
- In
Google Docs, Sheets, or Slides, open a file.
- At the top, click File Share Publish to web.
- 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.
- Click Publish.
- Copy the URL and send it to anyone you’d like to see the file. Or, embed it into your website.
Publish a file from a shared drive
Important: If you’re using an account through work or school, your administrator might have turned off the ability to publish
a file. If you can’t publish a file, contact your administrator.
- On your computer, go to drive.google.com.
- On the left, click Shared drives
double-click one of your shared drives.
- At the top, next to the name of your shared drive, click the Down arrow
Shared drive
settings.
- Next to “Sharing with non-members,” click Edit.
- Click “Non-member of this shared drive can be given access to files in this shared drive.”
- Click Apply.
- Follow the steps to publish a file.
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:
- Open a file in Google Docs or Sheets that you’ve already published to the web.
- Click File
Share Publish to web.
- Click Published content & settings.
- 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.
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:
- Open a file in Google Docs, Sheets, or Slides.
- On the top right, click Share.
- Click Settings .
- Uncheck Editors can change permissions and share.
- Click Done.
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.
Edit embedded spreadsheets
If you’re embedding a spreadsheet, you can show or hide parts of the spreadsheet after you publish to the web.
- Open a file in Google Sheets.
- At the top,
click File Share Publish to web.
- In the window that appears, click Embed.
- Click Publish.
- Copy the code in the text box and paste it into your
site or blog.
- 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
- In Google Forms, open a form.
- At the top right, click Send.
- At the top of the window, click Embed.
- To copy the HTML that appears, click Copy.
- Paste the HTML into your site or blog.
Related article:
- Embed a file in Google Sites
Was this helpful?
How can we improve it?
How do I import HTML into Google Sheets?
Let's now see how we can quickly and seamlessly import an HTML table referenced in a Wikipedia article into a Google sheet..
Step 1:Copy the URL. Image Source: Wikipedia..
Step 2: Select the table to be imported. ... .
Step 3: Add the formula in the Google Sheet..
Can I use HTML in Google Sheets?
Google Sheets offers a function called ImportHTML that imports data from a table or list within an HTML page. You can use this function to automatically pull data into a Google Sheet and then into Geckoboard. The first step is getting the data you need in Google Sheets using ImportHTML.
How do I embed HTML into Google Docs?
Add HTML, CSS, or JavaScript code to your site.
On a computer, open a site in new Google Sites..
At the right, click Insert. Embed. ... .
Click Embed code..
Add your code, then click Next. JavaScript code must be within <script> tags. ... .
Click Insert..
To publish your changes, at the top right, click Publish..
How do I embed code in Google Sheets?
If you're embedding a spreadsheet, you can show or hide parts of the spreadsheet after you publish to the web..
Open a file in Google Sheets..
At the top, click File Share. ... .
In the window that appears, click Embed..
Click Publish..
Copy the code in the text box and paste it into your site or blog..