Views let you visualize and work with data in different ways – like Kanban and Gantt views – or capture data with Forms.

Spreadsheet.com allows you to showcase your workbook's data in different ways. We refer to these different layouts for your data as Views. Spreadsheet.com supports a number of different view types like Sheet views, Kanban views, Gantt views, and Form views for capturing data.

Views let you visualize and work with data in different ways, or capture data in the case of forms. Most views also provide the ability to filter and sort data however you wish, changing what data you show, how the data is visualized, and more. The underlying data stays the same, but Spreadsheet.com lets you break out of one fixed layout to best showcase your information. 

This article features Spreadsheet.com's Product Launch Plan template. Explore the Template Gallery to find ready-to-use templates in over 20 different categories, or learn more about starting a new workbook from a Spreadsheet.com template.

Views Overview

Views provide different ways to look at and work with data in a worksheet. With Spreadsheet.com, you are always looking at a worksheet's data through a view. To see all views in a workbook, open the Views sidebar from the Views toolbar clicking on the name of your current view . You can switch to a different view by clicking on its name in the sidebar. You can also rename, copy, and delete views from here.

You can pin the Views sidebar to the left side of your screen by clicking the sidebar icon  or the pushpin icon

Worksheets start with a Primary View, which is indicated as such here. The Primary View is a sheet view created by default whenever a worksheet is created, always has the same name as the worksheet, and cannot be deleted. From there, Spreadsheet.com supports different types of additional views. The default view type is a sheet view, which is identical to the traditional spreadsheet grid, but with Spreadsheet.com's extra capabilities.

All views, regardless of their type, work with the same underlying data in your worksheet. When you change your data in one view, all other views will immediately reflect those changes.

All views allow you to see, update, and add data to the current worksheet. Plus, when you close and reopen a workbook, you will default to your most recent view.

Creating and Managing Views

You can manage each view from the Views sidebar by clicking on the three-dot icon to the right of each view name. Use the secondary menu to Rename, Copy, or Delete the view, as well as Lock the view and manage its Permissions.

To create a new view, click one of the + View buttons at the bottom of the sidebar. The new view will appear at the bottom of the Views list. Each view type has unique configuration settings accessible from the view navigation bar.

Sheet Views

New worksheets are automatically configured with a Sheet view as the primary view. Sheet views are traditional spreadsheet grids with columns, cells, and rows, but also include unique features like the table header region, custom data types, and related rows.

For more information about working with and configuring your Sheet views, check out our article on Sheet Views.

Kanban Views

Kanban views allow you to layout your data like spreading out stacks of note cards. Based on your worksheet's primary view, Kanban views provide an alternative to managing your data in the traditional spreadsheet grid. The cards that Kanban views show correspond to every row in the table region of your worksheet. The title of each row card is the value of the primary column cell value in that row.

Kanban views are a great way to see data differently, letting you sort, filter, and move cards and stacks.

For more information about working with and configuring your Kanban views, check out our article on Kanban Views.

Form Views

Form views allow you to quickly create shareable and embeddable forms, where each form submission becomes a new row in the worksheet.

When creating a form, each column in your worksheet can be used as a form field. You can choose whether fields are hidden and if they should have a default value. You can also configure column data types within the form designer, and add new columns as needed without switching back to a Sheet view.

For more information about working with and configuring your Form views, check out our article on Form Views.

Gantt Views

Gantt views add an interactive Gantt chart to the right of your worksheet showing taskbars corresponding to each row in the table region. Gantt views allow you to view task dependencies, identify a project's critical path, and quickly see whether or not a project is running on time.

Gantt views have the same set of configuration settings as Sheet views, with a few extra options housed in the upper right corner of your workbook.

Gantt Views are a premium feature available on Standard, Premium, and Enterprise plans. To learn more about Spreadsheet.com's paid plans, see our suite of articles on Billing, Payment, and Credit

For more information about working with and configuring your Gantt views, check out our article on Gantt Views and Project Management.

Calendar Views

Calendar views let you view your data laid out on a calendar instead of the typical spreadsheet grid. Calendar views take Date or Date and time columns into account, and calendar events can be colored according to different criteria.

When you create a new Calendar view, you will first be asked to select the Date or Date and time columns used to put your events on the calendar. Then, you can continue configuring your Calendar view, including specifying event colors and selecting a zoom level.

For more information about working with and configuring your Calendar views, check out our article on Calendar Views.