Make a table and count your CRM in it

Keep rows and columns in Files as a table, a board, a calendar or cards, open a row as a page with notes and comments, link two tables, and count people in your CRM or work out numbers.

Updated Nov 8, 2026

A table is rows and columns that live in Files, next to your documents. Use one for anything you would keep in a spreadsheet tab: the messages you are testing, a daily log, your numbers for the week. A table can also count people in your CRM, so a row like "LinkedIn, first message B" always shows how many people got it and how many replied.

Make a table

  1. In Files, choose New, then Table.
  2. The table opens with three columns: Name, Status and Notes. Click the name at the top to rename it.
  3. Choose New row and type in the cells.

Already have the data in an Excel or CSV file? Upload it to Files, open it and choose Make editable: each sheet becomes a table, its first row the columns. The table says which file it was made from.

You can also make one inside a page: type /table and choose Table. The table is saved in Files under that page and shows in the page.

Columns

Choose + at the end of the header row to add a column: give it a name and pick a type (Text, Number, Select, Multi-select, Checkbox, Date, URL, Person, Relation, Files, Created by, Edited by, Created or Edited). Click a column's name to rename it, sort by it, change its type or delete it. Columns above the table shows or hides columns, and has Add CRM count and Add formula.

  • Person: people of the table's company, or those it is shared with. Click the cell to pick them; tick One person only when you add the column to keep it to one.
  • Relation: rows of another table of the same company (or of your own files). Pick the table in Links to a table when you add the column. One row only keeps it to one row; Show the link back on that table adds a column there listing the rows here that link to each of its rows (you need to be able to change that table). Click the cell to pick rows, with a search; click a linked row to open it in its table. Someone who cannot open the other table sees the links without their names.
  • Files: files from Files. Add a file uploads one from your computer; the + beside the files adds more or takes one off. Click a file to open it. A files column can also give a gallery its pictures.
  • Created by, Edited by, Created and Edited fill themselves in: who added the row and who changed it last, and when. Rows from before these columns existed have no one in them.

To take the rows with you, choose the download arrow next to Columns: you get a CSV file of the rows you see, with their sort, filters and search, CRM counts and formulas as worked out.

Filter, Sort and Search narrow the rows you see without changing them. Group puts the rows under a heading for each choice of a column (a select, a multi-select, a checkbox or text), with how many rows each holds: click a heading's arrow to fold it, and New row beside it to add a row already in that group. The bar above the table says how many rows the table has, or how many of them you see, for example 12 of 60 rows. They work on the whole table, not only the rows on the screen: a sort puts the right rows first and a search or filter finds matches on every page. There is no Load more: the next rows load by themselves as you scroll down, in the table and in a table inside a page. Each row stays on one line; open a row to read a long cell in full.

Totals in the last row

The last row of a table shows a total under each column, as in the CRM. Click Add calculation under a column and pick one: Sum, Average, Median, Min or Max for number, CRM count and formula columns; Filled, Empty, Percent filled or Percent empty for any column but a checkbox; Unique for text, number, select, date and URL columns; Earliest or Latest for dates; Checked or Unchecked for checkboxes. Click a total to change it, or pick None to remove it.

Totals cover every row that matches your filters and search, not only the rows on the screen, and change as you edit a cell. Everyone who can open the table sees them; only people who can edit it pick them.

Count people in your CRM

A CRM count column shows how many people in one of your pipelines match a sentence you write.

  1. Choose Columns, then Add CRM count (or CRM count in the + menu).
  2. Name the column, for example Replies.
  3. Pick the pipeline after Count people in.
  4. Choose where ... and pick a field, a condition and a value, for example Replied is checked. Choose and ... to add more.
  5. To count each row on its own, pick this row's column as the value, for example Variant is this row's Variant. Each row then counts the people whose Variant matches its own.
  6. Under the sentence, For row shows the number for one row and the first people it counts. Choose Save column.

Counts are worked out live each time the table opens. Only people who can open your CRM see the numbers: anyone else sees a dash, with "Counted from a CRM you can't see". If the pipeline or a field it uses is deleted, the column says Pipeline missing.

Click Open row (the panel button at the start of a row) to see the row in a side panel. Each count shows its number and See people, the list of people it counts, each opening their record in the CRM.

Work out a number with a formula

  1. Choose Columns, then Add formula.
  2. Write the formula with column names in braces, for example {Replies} / {Sends}. The chips under the box add a column's name for you. You can use + - * / and brackets, with number, CRM count and other formula columns.
  3. Pick Percent to show 0.53 as 53%, and how many Decimals. Then choose Save column.

A cell stays empty when a column it uses is empty, or when it divides by zero. A formula cannot use itself, directly or through another formula.

Views: a board, a calendar, cards

The tabs above a table are its views. Table is the table as it is. Choose Add view to add another way to see the same rows:

  • Table: the grid with its own filters, sorts, grouping and shown columns.
  • Board: a column of cards for each choice of a select or checkbox column (Group picks which). Drag a card to another column to change that cell; the arrows beside a column's name fold it to a narrow strip, and + or New adds a card there.
  • Calendar: each row on the day of a date column (Date picks which). The rows without a date are listed on the right: drag one onto a day to give it that date. + on a day adds a row on it.
  • Gallery: the rows as cards with their name and first filled cells. Picture picks a files column for a picture across the top of each card.

Each view keeps its own filters, sorts, grouping, folded columns and shown columns (Columns, called Fields on a board or a gallery), saved as you change them. Everyone who can open the table sees its views; whoever can edit it adds, changes and deletes them. The arrow beside the open view's tab has Rename, Duplicate and Delete view; deleting a view keeps every row. A board, a calendar and a gallery show up to 1,000 rows: use a filter to find the others. Click a card or a row to open it in the side panel.

A row as a page

Click a row's open button, a card or a calendar entry to open the row beside the table. It shows the row's fields as a list you can change, then Page: notes, a checklist or a plan for this row, written as in any page, saved a second after you stop typing. Under it, Comments: write one, reply in a thread, Resolve it when it is done, and type @ to mention someone, who is then told. Everyone who can open the table reads a row's page and comments; whoever can edit the table writes the page.

The expand button at the top opens the row as a page of its own, with its own address to share; the button beside it puts it back beside the table. The arrows go to the row before or after. If someone else changed a row's page while you had it open, your words are not saved over theirs: choose Load their version to see it.

Charts of a table

Choose the Dashboard tab above the table to see the table's rows as charts: count rows by a column, add up a number column, or follow a date over time. Ask AI for a chart in plain words, or set a card up yourself. It works like the CRM's dashboards: see See your CRM and tables as charts. A table has no funnel, and its number cards cannot compare with the period before.

A table's dashboards are there for everyone who can open the table, and whoever can edit the table adds, changes and deletes them. Click a bar to see its rows, and Open as table to come back to the table with that filter. The Table tab takes you back to the rows.

Tables inside pages

Type / in a page to see the Tables group:

  • Table makes a new table and shows it here.
  • Link to a table shows a table you already have in Files, with the same rows. Search for it, or pick one of your recent tables.
  • Simple table is a plain grid of text, with no column types or counts.

A table shown in another page says Linked from Files. Open as page opens the table on its own, with its side panel. Who can open a table is decided by the table itself in Files, not by the page: someone who can read the page but not the table sees "You don't have access to this table." Deleting the block from a page keeps the table. When the table is in the trash, the block says so, and its owner can choose Restore.

On the phone

Open Files and tap +, then New table, or tap a table to open it. Rows show as cards, with each row's counts and formulas under its name; the button at the top switches to a grid. Tap a row to change its cells, then Done; a count opens its pipeline in the CRM. A person or relation cell shows its choices as chips to tap (a relation after Change), a file opens in the phone's viewer, and who and when are filled in. Under the cells, the row's Page is there to read (it is written on a computer) and its Comments to read and add to, with Reply on a thread. Row adds a row, and more rows load as you scroll. The menu has Columns, where you show, hide or edit columns and Add column (CRM counts and formulas included), Filter and sort, Dashboards, Connect (a company table: the Claude address and the table's id to copy), and Rename. A line above the rows counts them and gives the totals picked on a computer, for example 12 rows · Sum of Amount 1,015. The views made on a computer are chips above the rows: a board or a grouped table shows its cards under a heading for each group, a calendar under each day with the rows without a date last, a gallery as cards. To move a card to another group, open it and change its cell. Views are added and arranged on a computer.

With an API key or an AI tool

Every table in Files can be reached from your own tools, not only the CRM: a website form, Zapier or Make, your own code, or an AI tool like Claude or ChatGPT. On a company table, Connect in the toolbar shows the address to give Claude and the table's id to give your other tools, each with Copy.

  • With a key: tick Read tables in Files or Change tables in Files: rows and columns when you make a key, then see the tables part of the CRM API reference.
  • With Claude: connect StartupCorners in claude.ai once. Claude can then find your tables, read them, add and change rows, add or change columns, rename a table or move it to another folder, and make new ones. It can also list a table's views, read the rows a view shows (a board's groups with their counts too), and add, change or delete a view.

A key or a connected app acts as the person who made it: it reaches the tables that person can open, and changes only the ones they can edit. Moving a table to another folder or to the trash is for its owner or a file manager, as on the screen. A table in the trash can be restored from the trash in Files.

The assistant can do the same in the app: ask it to add a column, set a column's total, rename a table or move it to a folder, or make a view, for example "a board of my posts by status" or "a calendar by publish date". It reads the totals and a view's rows too.

Did this answer your question?

Related

Upload files and make foldersCRM API referenceMove a contact to the next stageSee your CRM and tables as charts