Spreadsheets

Organize your data in spreadsheets, and view it in context in Quip documents.

• Edit and Format Cell Values
  Change the look of spreadsheet cells, and update cell content.
• Use Data Validation in Spreadsheets
  Apply data validation to a cell or series of cells to keep data in your spreadsheets consistent.
• Apply Conditional Formatting in Spreadsheets
  Automatically highlight cells that meet certain conditions or match specific values.
• Reference Data in Spreadsheets
  Show the values in a cell, range of cells, or sheet from one spreadsheet in another spreadsheet. Referenced data retains the source formatting, and it refreshes automatically when you load the spreadsheet or when the source data is updated.
• Lock Data in Quip Spreadsheets
  Lock individual cells, a spreadsheet tab, or an entire spreadsheet to prevent accidental edits to spreadsheet data. Locking spreadsheet data prevents you and other users from making edits.
• Sort and Filter Spreadsheet Data
  See only the data that you want to see with filters and filter views. Sort to see your data how you want to see it.
• Add Lists in Spreadsheet Cells
  Format a Quip spreadsheet cell as a bulleted list, a numbered list, or a checklist. You can include one list type per cell.
• Add Formulas and Functions to a Spreadsheet
  Use functions to create formulas and perform calculations on your data.
• Create Charts with Spreadsheet Data
  Turn any range of your spreadsheet data into a chart. Charts dynamically update to reflect changes to your spreadsheet data.