0
0
Google Sheetsspreadsheet~10 mins

Publishing to web in Google Sheets - Real Business Scenario

Choose your learning style9 modes available
Scenario Mode
👤 Your Role: You are a content manager at a small online magazine.
📋 Request: Your manager wants you to share the latest article statistics with the public by publishing the data online.
📊 Data: You have a Google Sheet with article titles, authors, publication dates, and number of views.
🎯 Deliverable: Publish the sheet to the web so anyone with the link can see the article statistics in a clean, easy-to-read format.
Progress0 / 7 steps
Sample Data
Article TitleAuthorPublication DateViews
How to Bake BreadJane Smith2024-05-011500
Gardening TipsJohn Doe2024-05-031200
Travel on BudgetMary Johnson2024-05-051800
Home Workout GuideJames Lee2024-05-07900
Photography BasicsLinda Brown2024-05-101100
1
Step 1: Open your Google Sheet with the article statistics data.
Expected Result
You see the table with article titles, authors, publication dates, and views.
2
Step 2: Click on the 'File' menu at the top left corner.
Expected Result
The file menu dropdown appears.
3
Step 3: Select 'Share' and then click on 'Publish to web'.
Expected Result
A dialog box titled 'Publish to the web' opens.
4
Step 4: In the dialog, choose 'Entire Document' to publish the whole sheet or select a specific sheet if you want only part of the data.
Expected Result
The selection is set to publish the desired content.
5
Step 5: Choose the format as 'Web page' to make it easy to view in browsers.
Expected Result
Format is set to 'Web page'.
6
Step 6: Click the 'Publish' button and confirm by clicking 'OK' in the confirmation popup.
Expected Result
The sheet is published and a link is generated.
7
Step 7: Copy the provided link and share it with anyone who needs to see the article statistics.
Expected Result
Anyone with the link can view the published data in a clean web page format.
Final Result
Published Article Statistics

+--------------------+------------+-----------------+-------+
| Article Title      | Author     | Publication Date | Views |
+--------------------+------------+-----------------+-------+
| How to Bake Bread  | Jane Smith | 2024-05-01      | 1500  |
| Gardening Tips     | John Doe   | 2024-05-03      | 1200  |
| Travel on Budget   | Mary Johnson | 2024-05-05    | 1800  |
| Home Workout Guide | James Lee  | 2024-05-07      | 900   |
| Photography Basics | Linda Brown | 2024-05-10     | 1100  |
+--------------------+------------+-----------------+-------+
The data is now accessible to anyone with the link.
Publishing to web creates a simple, clean webpage view of the sheet.
No need for viewers to have Google accounts or special permissions.
Bonus Challenge

Update the published sheet when you change the data in Google Sheets.

Show Hint
After making changes, go to File > Share > Publish to web and click 'Republish'.