# Views

Create views for:

* Books of business for different account managers or CSMs
* Accounts that are at risk or have upsell opportunities based on a wide array of signals
* Customers with revenue > $5,000 who onboarded in the last month and their progress against the onboarding [project-templates](https://docs.usepylon.com/pylon-docs/account-intelligence/tasks-and-projects/project-templates "mention")

## Spreadsheet

Use the spreadsheet view to quickly make edits to fields on accounts and visualize account fields. 

Customize your columns by choosing fields you've set up on your Accounts to display. Columns can be reordered or resized. Finalize your view before saving into a view for yourself or your team. 

You can also manipulate your view with Account-based filter fields, similar to how you would with Issue [#filters](https://docs.usepylon.com/pylon-docs/support-workflows/issues/views#filters "mention").

Here's an example of a custom Accounts view set to filter for current customers:

<figure><img src="https://982123570-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F9hXBoCTTNw5flARlUVJf%2Fuploads%2FpptVogkaZZyxuUiMQ46E%2FCleanShot%202025-03-24%20at%2021.40.59%402x.png?alt=media&#x26;token=9dd51230-b656-4cc1-a41f-de1bd3f16c94" alt=""><figcaption></figcaption></figure>

### Aggregations

Add column level aggregations, for example to sum revenue across a book or count the number of accounts that have a field filled.

<figure><img src="https://982123570-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F9hXBoCTTNw5flARlUVJf%2Fuploads%2FgmsVxsUEXRoY5MIOP2e2%2FCleanShot%202025-08-10%20at%2020.57.08%402x.png?alt=media&#x26;token=1ed2c804-693d-4c13-9a5a-eb706bc84f63" alt="" width="167"><figcaption></figcaption></figure>

### Formatting

Create conditional formatting rules to change font color cell color based on a range of conditions.

<figure><img src="https://982123570-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F9hXBoCTTNw5flARlUVJf%2Fuploads%2FSzN4iGnRdw3hlBEOJChs%2FCleanShot%202025-08-10%20at%2020.42.33%402x.png?alt=media&#x26;token=4f609315-2278-47ac-baf4-0ee04cb2c593" alt=""><figcaption></figcaption></figure>