Working with Views

Views let you take a worksheet and transform it, helping you see and work with its data in entirely new ways.

When you’re creating workbooks in, you don’t have to stick with the traditional spreadsheet grid. Adding different Views to a worksheet lets you transform it into something else entirely – like a fully-featured calendar, a Kanban board, or an interactive Gantt chart – in just a few clicks.

Adding a new View gives you a new way of seeing your data while maintaining a single source of truth. When you change information in a View, the underlying data changes in your original worksheet, and vice versa. supports five types of Views: Sheet Views, Kanban Views, Calendar Views, Form Views, and Gantt Views.

Sheet Views

A Sheet View – the traditional spreadsheet grid with’s powerful features layered on top – is the type of View that all new workbooks are created with by default.


Kanban Views

A Kanban View takes your worksheet rows and transforms them into cards laid out on a Kanban board. Cards are “stacked” by the information in a selected worksheet column.


Calendar Views

A Calendar View transforms your spreadsheet into an interactive, fully-featured calendar. Share your calendar using iCal link sharing, and your team can automatically import events into calendar applications like Outlook and Google Calendar.


Form Views

Adding a Form View lets other people add data to your worksheet via a shareable form, even if they don’t have a account. Form responses are automatically added to your worksheet as new rows.


Gantt Views

A Gantt View adds an interactive Gantt chart side-by-side with your worksheet, with support for key project management features like task dependencies and constraints. Gantt Views make the most of’s powerful project management features.


All of the Views shown above are built from the same Sheet View. Views remain linked to their source data – when you make changes in one View or in the original worksheet, the changes are reflected in all other Views.

Worksheets can have any number of Views, and Views can be renamed or deleted at any time.

How to Add a New View to Your Worksheet

  1. Click the View name or Pin Views Sidebar button to open the Views sidebar
  2. From the Views sidebar, click one of the New View… buttons at the bottom
  3. Specify the name and access level of your new View

Learn More: Working with Views

Creating Views in your workbooks can make them more powerful and versatile than any traditional spreadsheet. Learn more about working with Views with these resources:

  • Introduction to Views” – Learn more about’s different Views, including managing your existing Views
  • Kanban Views” – Learn more about working with Kanban Views
  • Calendar Views” – Learn more about working with Calendar Views
  • Form Views” –  Learn more about working with Form Views
  • Gantt Views and Project Management” – Learn more about working with Gantt Views and the full suite of’s project management features

Next, we’ll take a look at organizing your worksheets with filtering, sorting, and grouping rows.