Live Examples

Sheetcast can be used for any purpose you want.


Here are just some example end result web apps, that you could build.

Simple:

Calendar Application

Calendar App »

Effortlessly craft a personalized calendar within minutes, providing you with a seamless solution to manage and monitor dates and events in your application.

  1. Open Sheetcast

  2. Open Excel with the Sheetcast Add-in and start with a spreadsheet like this one and then click to upload it.

  3. Create a Calendar page:
    • Select “Calendar”.
    • Set “Start Dates” to column “B (Start Date)”.
    • Set “Titles” to column “A (Meeting Title)”.
    • Set “What to Show When Hovering” to column “G (Hover Notes)”.
    • Set “End Dates” to column “D (End Date)”.
    • Set “Colors” to column “F (Colors)”.
  4. You’re done! Click “View App Online”.

    5. Try building this app live »
Map Application

Map App »

Effortlessly generate a detailed map in minutes, providing your organization with the capability to view key locations within your custom application.

  1. Open Sheetcast

  2. Open Excel with the Sheetcast Add-in and start with a spreadsheet like this one and then click to upload it.

  3. Create a Map page:
    • Select “Map”.
    • “Locations” will show set to column A (Location).
    • Set “Titles” to column B (Title).
    • Set “Descriptions” to column C (Description).
    • Set “Colors” to column D (Color).
    • Click “Save” and back.
  4. Create an Insert Page:
    • Click “Add Page” and select “Insert”.
    • Set “Title” to “Add New Pin”.
  5. You’re done! Click to view app online.

    6. Try building this app live »
Survey Application

Survey Response App »

Effortlessly craft a survey tailored to your needs in just minutes. Elevate your data collection game with swift and user-friendly survey creation.

  1. Open Sheetcast

  2. Open Excel with the Sheetcast Add-in and start with a spreadsheet like this one.

  3. Create a Details Report page:
    • Select “List-Management”.
    • Set “Title” to “List of Feedback”.
    • Click “Save” and back.
  4. Create a Text page:
    • Click “Add Page” and select “Text”.
    • Set “Title” to “Survey Thanks”.
    • In the text box write “Thank you for your feedback. We value this and will make sure your opinion is heard.”
    • Click “Save” and back.
  5. Create an Insert page:
    • Click “Add Page” and select “Insert”.
    • Set “Title” to “Survey Form”.
    • Under the “More” tab, set “Redirect or Refresh” to “If Form Successfully Submitted”, and set “To” to “To a Page”, and select “Survey Thanks”.
    • Click “Save” and back.
  6. You’re done! Click to view the app online.
Try building this app live »

Complex:

Dashboard application

Dashboard App »

Unleash the power of data visualization in your application with utmost ease! In just a few minutes, fashion a captivating and interactive dashboard.

  1. Open Sheetcast

  2. Open Excel with the Sheetcast Add-in and start with a spreadsheet like this one.

  3. Create a Solo Form page:
    • Go to sheet “Calc”, click “Upload as New App and Add Page” and select “Solo Form”.
    • Set “Title” to “Client Dashboard”.
    • Set “Source” to “Range of Cells”. Then, select the range $A$1:$M$33 in “Calc” sheet, and click the green icon button below “Range of Cells”.
    • Set “Editable Cells Mode” to “Specific Cells”. Then, type C3 next to the green icon button below “Range of Cells”.
    • In the More tab, uncheck “Show Page Title.”
    • Under “Experimental Content” on More tab put a check mark on “Hide Save Button”.
    • Click “Save” and back.
  4. Create a List-Management page:
    • Go to “Data” sheet, click “Add page” and select “List-Management”.
    • Set “Title” to “Change Client Data”.
    • Set “Source” to be the table “Client_List”.
    • In More tab, expand “Details Drilldown Screen” and set “Details Template” to “Sheet” and select “EditAddClientData”. Do the same for “Add-Record” Template.
    • Click “Save” and back.
  5. Create an Insert page:
    • Click “Add Page” and select “Insert Page”.
    • Set “Title” to “Client Input Page”.
    • In More tab, expand “Details Drilldown Screen” and set “Insert Template” to “Sheet” and select “EditAddClientData”.
    • Click “Save” and back.
  6. Create a Tabs Container page:
    • Click “Add page” and select “Tabs Container”.
    • Set “Title” to “Dashboard”.
    • Select “Client Dashboard (Solo Form)”, “Client Data (List)”, “Change Client Data (List)”, and “Client Input Page (Form)” in the drop-down list.
    • Click “Save” and back.
  7. Create a Menu Page:
    • Click “Add page” and select “Menu”.
    • Click the “None” button close to “Menu Template”, select “Auto Create New” and click “Yes”.
    • Go to the new worksheet “MenuLayout” and delete the content from all the cells except the one that says “Dashboard”. Drag that cell to cell A1.
    • Click “Save” and back.
  8. Optional: For each page go to the "More" tab and uncheck “Show Page Title” box.
  9. You’re done! Click “View App Online”.
Try building this app live »
Plant watering schedule application

Plant Watering App »

Your plant care assistant. Monitor watering, capture growth, and schedule care with ease in your own app!

  1. Open Sheetcast

  2. Open Excel with the Sheetcast Add-in and start with a spreadsheet like this one.

  3. Create a Calendar page:
    • With the “Plants” sheet open, click the “Upload as New App and Add Page” button.
    • Select “Calendar”.
    • Set “Title” to “Schedule”.
    • Set “Start Dates” to column E (Water On).
    • Set “Titles” to column B (Plant).
    • Set “What to show when hovering” to column H (Notes).
    • Set “End Dates” to column E (Water On).
    • Set “Colors” to column I (Color).
    • Click “Save” and back.
  4. Create a Filter and Slicer page:
    • With the “Plants” sheet open click “Add-Page” and select “Filter and Slicer”.
    • Set “Title” to “Filter Data”.
    • Under “More” tab, uncheck “Show Page Title” box.
    • Set “Filter Template” to “FilterByLayout” sheet.
    • Set “Matching Required” box to “Exact Match”.
    • Click “Save” and back.
  5. Create a List-Management page:
    • With the “Plants” sheet open, click “Add-Page” and select “List-Management”.
    • Set “Title” to “Edit / Add / Remove”.
    • Click “Save” and back.
  6. Create a Layout Container page:
    • Click “Add-Page” and select “Layout Container”.
    • Set “Title” to “Dashboard”.
    • Set “Columns” to 1.
    • Select “Filter Data (Filter and Slicer)”, “Schedule (Calendar)” and “Plant List (Details Report)” in the drop-down list.
    • Click “Save” and back.
  7. Create a Menu page:
    • On the list of pages, click “Recommended: Add Menu Page” and then click the green button in it.
    • On the newly created worksheet, delete all the cells except the ones with “Dashboard” and “Add / Edit / Remove”.
    • Move “Dashboard” to cell A1 and “Add / Edit / Remove” to B1, then adjust column width in columns A and B.
    • Click “Upload Changes”.
  8. You’re done! Click to view app online.
Try building this app live »
London Trip Diary Application

London Trip Diary App »

Quickly craft your ultimate vacation application: Explore, capture, map, rate, and check off bucket list adventures!

  1. Open Sheetcast

  2. Open Excel with the Sheetcast Add-in and start with a spreadsheet like this one.

  3. Create a Map page:
    • With the “Attractions” sheet open, click “Upload as New App and Add Page” and select “Map”.
    • Set “Source” to Table and select “Attractions” table.
    • Set “Locations” to F (Location).
    • Set “Titles” to D (Attraction).
    • Set “Values” to I (# Visits).
    • Set “Descriptions” to J (Category).
    • Set “Colors” to L (Pins).
    • Click “Save” and back.
  4. Create a List-Details page:
    • With the “Attractions” sheet activated, click “Add-Page” and select “List-Details”.
    • Set “Title” to “Attraction Details”.
    • Set “Source” to Table and select “Attractions”.
    • Set “Enter Details Drilldown Screen” to “Enter When Selected”.
    • Under the “More” tab, expand “Details Drill Down Screen” and set “Details Template” to “DetailsLayout” sheet.
    • Click “Save” and back.
  5. Create a List-Management page:
    • With the “Attractions” sheet open, click “Add-Page” and select “List-Management”.
    • Set “Title” to “Attraction Editor”.
    • Set “Source” to “Table” and select the “Attractions” table.
    • Set “Enter Details Drilldown Screen” to “Enter When Selected”.
    • Under the “More” tab, expand “Details Drill Down Screen” and set “Details Template” to “EditLayout” sheet.
    • Click “Save” and back.
  6. Create a Layout Container page:
    • Click “Add-Page” and select “Layout Container”.
    • Set “Title” to “Trip Details”.
    • Set “Columns” to 1.
    • Select “Map Page (Map)” and “Attraction Details (List)” in the drop-down list.
    • (Optional) Under the “More” tab uncheck “Show Page Title”.
    • Click “Save” and back.
  7. Create a Menu Page:
    • Click “Add page” and select “Menu”.
    • Change “Menu Template” from “None” to “Auto Create New” and click “Yes”.
    • Go to the new worksheet “MenuLayout” and delete the content from all the cells except “Trip Details” and “Attraction Editor”. Drag these to cells A1 and B1 respectively.
    • Click “Save” and back.
  8. Optional: hide the column pins column by clicking the grouping feature button and edit all the pages to uncheck “Show Page Title” under the More tab.
  9. You’re done! Click “View App Online”.

Try building this app live »
Daily Trivia App

Daily Trivia App »

Deliver a new question each day with this dynamic trivia app. Perfect for testing knowledge or creating a fun daily habit.

  1. Open Sheetcast

  2. Open Excel with the Sheetcast Add-in and start with a spreadsheet like this one.

  3. Create a Report page
    • Click “Add Page” and select “List-Management”.
    • Set “Title” to “Questions”
    • Click the “Sheet” button to change the “Source” and choose the “Tbl_Questions” Table.
    • Change the “Enter Details Drilldown Screen” to “Enter When Selected”
    • Click on the “More” tab.
    • Under the List Screen, change the “Template for Each Item” to the “QuestionsItemLayout” sheet.
    • Under the “Details Drilldown Screen”, change the “Details Template” to “QuestionsDetailsLayout” screen.
    • Click on the “Field Rules”
      1. Set the “Question ID” field to “Restrict User Input” and choose “Auto-Increment”
    • Under Experimental Content:
      1. Select “Add Nested Child”
      2. Change the title to “Answers”
      3. Set the Source to the “Tbl_Answers” table
      4. Set the ID to “A (Question ID)”
      5. Click “Close”
      6. Set the ID Field on the main sidebar to “A (Question ID)”
    • Click Save
    • Click the Back Arrow
  4. Create a Text Page
    • Click “Add Page” and select “Text”.
    • Set the Title to “Win”
    • Set the Text to “Correct!”
    • Click Save
    • Click the Back Arrow
  5. Create a Text Page
    • Click “Add Page” and select “Text”.
    • Set the Title to “Lose”
    • Set the Text to “Wrong!”
    • Click Save
    • Click the Back Arrow
  6. Create a List Management Page
    • Click “Add Page” and select “List-Management”.
    • Set the Title to “Test”
    • Set the Source to the “Tbl_Test” Table
    • Click on the “More” tab
    • Under the “Details Drilldown Screen”, change the “Details Template” to the “TestDetailsLayout” sheet
    • Click on “Field Rules”
      1. Add a rule to the “TestID” and select “Restrict User Input”. Select “Auto-Increment” from the dropdown menu.
      2. Add a Rule to “QuestionID” and select “Fill on Save”. In the first dropdown menu, select “Fill with value computed by this formula” and input the formula: RANDBETWEEN(MIN(Tbl_Questions[Question ID]),MAX(Tbl_Questions[Question ID])) into the input box. Select “Add” from the second dropdown menu.
      3. Add a rule to “Submitted” and select “Fill on Save”. Select “Logical” from the first dropdown menu, choose “FALSE”, and select “Add” from the second dropdown menu.
      4. Add a rule to “Submitted” and select “Fill on Save”. Select “Logical” from the first dropdown menu, choose “TRUE”, and select “EDIT” from the second dropdown menu.
    • Click on “None” next to “Redirect or Refresh” and select “If Form Successfully Submitted”
      1. Choose “Custom Formula”
    • Add the formula: IF(CASTLASTVALUELOCATION(Tbl_Test[Submitted]),IF(CASTLASTVALUELOCATION(Tbl_Test[Correct]),CASTPAGELINK(,CastPages[Win]),CASTPAGELINK(,CastPages[Lose])),CASTPAGELINK(,CastPages[Test])) to the input box.
    • Click “Save”
    • Click the Back Arrow
  7. Add a Menu Page
    • Click “Add Page” and select “Menu”.
    • Change your Source and select “Auto Create New”
    • Remove all of the values from the MenuLayout sheet except “Daily Trivia” and “Questions”
    • Click Save
    • Click the Back Arrow
  8. You’re Done! Click “View App Online”.

Showing Off:

Tic Tac Toe

Tic Tac Toe »

Challenge friends and build this classic two-player game, built entirely from an Excel sheet!

  1. Open Sheetcast

  2. Open Excel with the Sheetcast Add-in and start with a spreadsheet like this one.

  3. Create a Report page
    • Set “Title to “Game Over!”
    • Click the “Sheet” button to change the “Source” and choose “Range of Cells”.
    • Highlight Cells: TicTacToe!$B$1:$F$4 and click the “Use Current Selection” button.
    • Click Save
    • Click the Back Arrow
  4. Create a Solo Form page:
    • Click “Add Page” and select “Solo Form”.
    • Set “Title” to “Tic Tac Toe”
    • Click the “Sheet” button to change the “Source” and choose “Range of Cells”.
    • Highlight Cells: TicTacToe!$B$1:$F$4 and click the “Use Current Selection” button.
    • Click the “Specific Cells” button to change the “Editable Cells Mode” and select “Color Matching”.
    • Highlight Cell: TicTacToe!$A$2 and click the “Use Current Selection” button.
    • Click on the “More” tab
    • Click on “None” to change the Redirect or Refresh
    • Select “Conditional Excel Formula”
    • In the Input Box enter the formula: “OR(TicTacToe!I2:I3=TRUE)”
    • Click the Dropdown and set it to the “Game Over” page
    • Click Save
    • Click the Back Arrow
  5. You're Done! Click "View App Online".