From spreadsheet to pipeline in an afternoon

Most sales teams start in a spreadsheet, and for a while it works. Then it doesn't — you cannot tell who owns what, two people edit the same row, and "the pipeline" is really three sheets nobody trusts. Moving to a real CRM sounds like a project you need to schedule. It isn't. Here is a practical path from a messy sheet to a working pipeline you can run the same afternoon.

First, tidy the sheet, not the data. You do not need it perfect — you need the columns to mean one thing each. One column for the person's name, one for email, one for company, one for status. If your sheet mixes contacts and companies in the same rows, that is fine; you will split them on the way in. Spend fifteen minutes here and the rest goes faster. Spend zero and you will pay it back later untangling a field that meant two things.

Second, decide what each row actually is. This is the one concept worth pausing on. In a CRM, a person you are selling to is a contact, a person who has not yet been qualified is often a lead, and the business they belong to is a company. A spreadsheet blurs all three into one row. Before you import, decide which of your rows are leads (early, unqualified) and which are contacts (real people at real accounts you are actively working). You can import both — just know which is which.

Third, import. Propel imports contacts and leads from CSV, so export your sheet to CSV and bring it in. During import you map your columns to Propel's fields — your "Full Name" column to name, your "Work Email" to email, and so on. One thing to handle deliberately here: marketing consent. If you intend to email these people as marketing, you need their opt-in, and Propel captures marketing opt-in at import time so that consent is recorded from the start rather than assumed. Do not skip it and backfill later; recorded consent is what keeps your sending compliant.

Fourth, fill in the companies. You will find some contacts arrived without a company, or with a company that does not exist yet. Propel lets you quick-create companies and contacts on the spot, so you do not have to bounce back to a spreadsheet — create the company from the contact, and the relationship is set. A few minutes of this and your people are attached to real accounts instead of floating loose.

Fifth, set up your pipeline and stages. This is the part a spreadsheet genuinely cannot do. A pipeline is the path a deal travels — your stages, in your language, from first conversation to closed. Propel ships with sensible defaults, but make them yours: rename the stages to match how your team actually talks about deals. If you say "demo booked," call the stage that. The pipeline is the shared vocabulary your whole team works from, so it should sound like your team.

Sixth, create deals and assign owners. Now turn the accounts worth pursuing into deals, drop each into the right stage, and assign an owner. Ownership is the single thing a spreadsheet is worst at and the single thing that matters most on a team: everyone should be able to see, at a glance, whose deal is whose. Once every open deal has a stage and an owner, you have a pipeline — not a sheet that looks like one.

That is the whole afternoon. Tidy the columns, decide what your rows are, import with consent captured, attach companies, shape the pipeline to your language, and assign owners. You will not have every field perfect on day one, and you do not need to. You will have something a spreadsheet can never be: a shared, owned, moving picture of your pipeline that the whole team is looking at together.

Start there. Refine as you go. The best time to leave the spreadsheet is before it becomes the thing you are managing instead of the deals.