NuVentrec

Guides / Board or spreadsheet

Guide · Deals and pipelines

Board or spreadsheet: which pipeline view to use for which job

Most real estate teams start their pipeline in a spreadsheet, then move to a board of cards, then miss the spreadsheet. Both views are right, for different jobs. This guide explains what each one is good at, when to switch between them, and how to set up a pipeline so both stay useful.

By the NuVentrec team · Published October 14, 2026 · Updated October 19, 2026 · Sources last checked October 19, 2026

The short answer

  • Use the board to run the day: what is stuck, what moves next, and how much is sitting in each stage.
  • Use the spreadsheet to find, compare and fix: sort by last contact, filter by owner, scan a column, correct many records quickly.
  • They should be two views of the same records, not two copies. A change in one must show in the other at once.
  • Keep the board's cards short (address, name, next step) and let the spreadsheet carry the detail columns.
  • Export from the spreadsheet, not by copying cards, so the file matches what you filtered.

What a board is good at

A board shows each deal as a card in a column, and each column is a stage: new lead, contacted, appointment, offer, under contract, closed. The Kanban Guide describes this kind of board as a way of visualizing a workflow, and it puts weight on one idea in particular: a team "must explicitly control the number of work items in a workflow from started to finished". On a board, that control is visible. If the "Offer sent" column holds forty cards and "Under contract" holds two, you can see the bottleneck without running a report.

Boards are good at three things:

  • Flow. Where deals pile up, and which stage they leave slowly.
  • Moving one deal. Dragging a card to the next stage is the most natural way to record progress.
  • A shared picture. In a team meeting, everybody understands a board in seconds.

Boards are poor at comparison. You cannot sort a column of cards by the date of the last call, or see fifty phone numbers side by side. Once a stage holds more cards than fit on a screen, the board becomes a long scroll.

What a spreadsheet is good at

Nielsen Norman Group's study of data tables names four main tasks people do with them: find records that fit specific criteria, compare data, view or edit a single row, and take action on records. That list reads like a pipeline manager's afternoon:

  • Find: every deal owned by one caller with no contact in fourteen days.
  • Compare: sort by value, by source or by stage to see which leads are worth the next hour.
  • Edit: fix a wrong owner or a missing phone number without opening each card.
  • Act: export the filtered list, or hand a set of deals to another team member.

The same study notes that a wide row is hard to read and edit, and that a single record often works better in its own panel. That is the case for keeping the full contact page one click away from the table, rather than squeezing every field into columns.

Two views, one set of records

The trouble starts when the board and the spreadsheet are different files. A team keeps the board in its CRM and a spreadsheet "for reporting", and within a week the two disagree. Someone updates the sheet and not the card, and the next caller works from the wrong one.

The fix is to treat the board and the spreadsheet as two views of the same records. Moving a card changes the stage column. Editing a cell in the table changes the card. Filters and searches apply to both. If your tools cannot do that, pick one as the source and make the other read-only.

Setting up a pipeline so both views work

  1. Keep stages few and clear. Each stage should mean one thing a person did or decided. Our guide to pipeline stages for land deals has a worked example.
  2. Choose what a card shows. Address or name, the owner, the last contact and the next step. Anything more makes the board harder to scan.
  3. Choose the spreadsheet's columns separately. Phone, source, value, stage, owner, last contact, next task. The table is where detail belongs.
  4. Make "next step" required. A deal without a next step and a due date is the one that goes cold. Our guide on team follow-up covers how to keep that true.
  5. Save each person's view. A caller and a manager look at different things. Let each one keep their own columns and card fields, so nobody rearranges anyone else's screen.
  6. Decide who may export. A spreadsheet export is a copy of your leads leaving the system. Limit it to the people who need it and keep a record of who exported what. If an export goes into another tool for calling or texting, the opt-outs must travel with it: federal rules require a revoked consent to be honored within a reasonable time of no more than ten business days.

When to switch views

A simple rhythm works for most teams:

  • Morning: the board. Which stages grew overnight, what is stuck, what needs a call today.
  • Working a list: the spreadsheet, sorted by last contact, filtered to your own deals.
  • Cleaning up: the spreadsheet. Fix owners, sources and missing numbers in one pass.
  • Weekly meeting: the board, one stage at a time. Focus on a single column and talk through each card.

Focusing on one stage is worth calling out. A meeting that looks at the whole board talks about the board. A meeting that opens "Offer sent" and goes card by card talks about deals.

Common mistakes

  • Too many stages. Twenty columns turn the board back into a list. Merge stages that nobody acts on differently.
  • Cards that hold everything. If a card needs scrolling, move the detail to the table or the contact page.
  • A separate "master" spreadsheet. It will drift from the CRM. Export when you need a file; do not maintain one.
  • No owner on a deal. In both views, a deal without an owner is a deal nobody calls.

How this fits in NuVentrec today

NuVentrec's Pipeline page has a board and a spreadsheet view of the same deals. The spreadsheet sorts on the server, edits in place, lets each person pick and order their columns, and exports to CSV for the people allowed to export. On the board you can focus on one stage, choose which fields a card shows, and make cards larger or smaller; each person's choices are saved for each pipeline. See what is live, or start now. Still deciding whether you need a CRM at all? See NuVentrec vs a spreadsheet and the one-day move plan; plans are on the pricing page.

Questions people ask

Should a small team bother with a board?

Yes, once more than a handful of deals are open. The board shows where deals stall, which a list sorted by name never will.

Can we keep our spreadsheet and just add a board?

Only if one of them is read-only. Two editable copies will disagree within days. Import the spreadsheet once, then use the CRM's table view instead. Our move checker shows what a file holds before you import it.

Which columns matter most in the spreadsheet view?

Last contact and next step. Sorting by those two tells a caller who to call next. Value and source matter for managers deciding where to spend time.

Is exporting the pipeline safe?

An export is a copy of people's personal details. Limit who can export, keep a record of exports, and delete files you no longer need.

Sources

  1. J. Coleman, D. Vacanti and others, "The Kanban Guide", version 2025.5, May 2025
  2. P. Laubheimer, "Data Tables: Four Major User Tasks", Nielsen Norman Group, April 3, 2022
  3. 47 CFR 64.1200, "Delivery restrictions", paragraph (a)(10) (revoked consent honored within 10 business days), Legal Information Institute

Run the day on the board, work the list in the spreadsheet: same deals, two views.

Try the interactive demoBook a walkthrough
Call now