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 Spreadsheet.com, 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.

Spreadsheet.com 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 Spreadsheet.com’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 Spreadsheet.com 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 Spreadsheet.com’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.

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