We launched a new IT training category! Check out the 140+ courses now.

Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member

Publishing a spreadsheet to the web

From: Google Sheets Essential Training

Video: Publishing a spreadsheet to the web

Google Sheets allows you to publish your spreadsheet to a web page with Click OK to confirm.

Publishing a spreadsheet to the web

Google Sheets allows you to publish your spreadsheet to a web page with a single click. Publishing your spreadsheet to the web allows you to share your spreadsheet for viewing with the URL address. Keep in mind that when you publish a spreadsheet, you're making that spreadsheet available to anyone on the web who has the URL. It doesn't matter if you've set the visibility to private in your Google Drive. Once it's published to the web, it's publicly accessible. Others will only be able to view the spreadsheet from the shared URL. They will not be able to edit or revise the published spreadsheet.

The original version of the spreadsheet that resides in your Google Drive will still be editable by you, and by other editors. Let me show you how quick and easy it is to publish a spreadsheet to the web. With your spreadsheet open, select File from the menu and select Publish to the web. Keep the Automatically republish when changes are made check box checked if you'd like to keep the revisions in sync with the published version. Then click the button labeled Start publishing. Click OK to confirm.

Now that you've published the spreadsheet, you'll see a link to the published document. From here, you can click and copy that link to your clipboard, and send or post it anywhere you wish. Let's see how this looks on the web. I'll copy the link, open a new browser tab, and I'll enter it in my browser address bar. Now, we see the viewable spreadsheet in a web page. The first thing you notice is that my spreadsheet had three tabs, but I see those three tabs up along the top of the screen rather than the bottom.

I can click through these tabs to see the different sheets. You'll also notice that even if I click somewhere on the spreadsheet it's not editable or selectable. I can only view the data. Editing is not possible in the published web view. Let's return to our original spread sheet by clicking the tab. And let's take a look at our sharing options for this published spreadsheet. I can copy this URL and send it to people in an email or an instant message. Or I could post this link on a webpage or blog. I could also use this embed code to embed a view of the spreadsheet on my website.

To do that, I'd copy and paste the code in to my HTML editor for my blog or website. I could also share this link quickly using Google Plus, Gmail, Facebook, or Twitter by clicking one of these icons. Once you're done publishing and sharing the spreadsheet, click the Close button. To find the link in sharing settings at a later time, or to turn off publishing the spreadsheet, click File > Publish to the web, once again. To turn off publishing and remove the spreadsheet from the web, click the Stop Publishing button. Click OK to confirm. The spreadsheet will be removed from its web page location.

If your spreadsheet is confidential or contains personal information, be cautious about publishing the spreadsheet to the web. As soon as you click Start Publishing, the data becomes publicly available for anyone with the URL

Show transcript

This video is part of

Image for Google Sheets Essential Training
Google Sheets Essential Training

50 video lessons · 1119 viewers

Sally Norred
Author

 
Expand all | Collapse all
  1. 4m 44s
    1. Welcome
      46s
    2. Importing exercise files to Google Sheets
      1m 29s
    3. What's new in Google Sheets
      2m 29s
  2. 14m 44s
    1. What is Google Sheets?
      2m 31s
    2. Accessing Google Sheets with your account
      2m 3s
    3. Understanding common Google Sheets terminology
      4m 17s
    4. Navigating Google Sheets
      5m 53s
  3. 22m 15s
    1. Creating, naming, and saving a spreadsheet
      3m 28s
    2. Renaming a spreadsheet
      1m 59s
    3. Copying a spreadsheet
      3m 9s
    4. Moving a spreadsheet
      3m 10s
    5. Deleting a spreadsheet
      2m 15s
    6. Importing and converting Excel or OpenOffice spreadsheets
      4m 20s
    7. Importing and converting .csv, .tsv, .tab, and .txt data files
      3m 54s
  4. 28m 46s
    1. Entering and editing cell content
      4m 2s
    2. Inserting, deleting, and clearing rows and columns
      3m 26s
    3. Moving rows, columns, and cells
      2m 25s
    4. Working with multiple sheets
      4m 14s
    5. Using keyboard shortcuts
      3m 43s
    6. Creating a series of numbers or dates
      3m 13s
    7. Using Find and Replace
      2m 30s
    8. Entering hyperlinks
      1m 58s
    9. Inserting images into spreadsheets
      3m 15s
  5. 14m 31s
    1. Using the View menu
      3m 2s
    2. Freezing rows and columns
      1m 58s
    3. Hiding rows, columns, and sheets
      3m 45s
    4. Publishing a spreadsheet to the web
      3m 6s
    5. Printing a spreadsheet
      2m 40s
  6. 18m 46s
    1. Formatting cell, row, and column data
      6m 6s
    2. Google Sheets formatting tips
      3m 35s
    3. Using conditional formatting
      5m 6s
    4. Creating a spreadsheet from a template
      3m 59s
  7. 36m 12s
    1. Sorting data on a spreadsheet
      3m 37s
    2. Using Quick Sum
      3m 14s
    3. Using formulas and functions
      6m 23s
    4. Using IF functions and nested functions
      4m 33s
    5. Referencing data from other sheets
      3m 43s
    6. Creating charts in Google Sheets
      5m 28s
    7. Using filters and creating filter views
      4m 55s
    8. Using pivot tables
      4m 19s
  8. 20m 37s
    1. Sharing a spreadsheet file with other people
      5m 40s
    2. Working with Google Sheets that are shared with you
      4m 19s
    3. Working with spreadsheet revisions
      3m 2s
    4. Commenting on a spreadsheet
      3m 26s
    5. Emailing spreadsheet collaborators
      1m 47s
    6. Collaborating simultaneously and using Google Chat
      2m 23s
  9. 8m 54s
    1. Installing the Google Sheets mobile app
      2m 3s
    2. Navigating the Google Sheets mobile app
      3m 21s
    3. Working with spreadsheets on the Google Sheets mobile app
      3m 30s
  10. 47s
    1. Helpful resources
      47s

Start learning today

Get unlimited access to all courses for just $25/month.

Become a member
Sometimes @lynda teaches me how to use a program and sometimes Lynda.com changes my life forever. @JosefShutter
@lynda lynda.com is an absolute life saver when it comes to learning todays software. Definitely recommend it! #higherlearning @Michael_Caraway
@lynda The best thing online! Your database of courses is great! To the mark and very helpful. Thanks! @ru22more
Got to create something yesterday I never thought I could do. #thanks @lynda @Ngventurella
I really do love @lynda as a learning platform. Never stop learning and developing, it’s probably our greatest gift as a species! @soundslikedavid
@lynda just subscribed to lynda.com all I can say its brilliant join now trust me @ButchSamurai
@lynda is an awesome resource. The membership is priceless if you take advantage of it. @diabetic_techie
One of the best decision I made this year. Buy a 1yr subscription to @lynda @cybercaptive
guys lynda.com (@lynda) is the best. So far I’ve learned Java, principles of OO programming, and now learning about MS project @lucasmitchell
Signed back up to @lynda dot com. I’ve missed it!! Proper geeking out right now! #timetolearn #geek @JayGodbold
Share a link to this course

What are exercise files?

Exercise files are the same files the author uses in the course. Save time by downloading the author's files instead of setting up your own files, and learn by following along with the instructor.

Can I take this course without the exercise files?

Yes! If you decide you would like the exercise files later, you can upgrade to a premium account any time.

Become a member Download sample files See plans and pricing

Please wait... please wait ...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.


Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ .

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

Are you sure you want to mark all the videos in this course as unwatched?

This will not affect your course history, your reports, or your certificates of completion for this course.


Mark all as unwatched Cancel

Congratulations

You have completed Google Sheets Essential Training.

Return to your organization's learning portal to continue training, or close this page.


OK
Become a member to add this course to a playlist

Join today and get unlimited access to the entire library of video courses—and create as many playlists as you like.

Get started

Already a member ?

Become a member to like this course.

Join today and get unlimited access to the entire library of video courses.

Get started

Already a member?

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

The classic layout automatically defaults to the latest Flash Player.

To choose a different player, hold the cursor over your name at the top right of any lynda.com page and choose Site preferences from the dropdown menu.

Continue to classic layout Stay on new layout
Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.

Are you sure you want to delete this note?

No

Your file was successfully uploaded.

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.