Sales

How to Fill a CRM Worksheet

A CRM worksheet fillable in Excel is a list of customers, the next step, and the deal stage. Harbor Service Co. keeps fifteen customers in the sample. Deal values are in dollars. Won and lost rows stay on the list so you can see history, but they are not part of the open pipeline.

Free fillable CRM worksheet

The free fillable CRM worksheet uses names you would say on a call. Harbor Street Apartments and Lena Ortiz are customers. Harbor Street Apartments is Won at $256.50, so it is not in the open pipeline. Jordan Hale is Lost at $0. Priya Shah Design is New at $0, which means the work is not priced yet. Change a stage from Quote sent to Won and that value leaves the open total.

This is the same workbook as the free fillable CRM worksheet page. The free CRM Excel template and the free CRM spreadsheet template are the longer contact lists if you need phone, email, and the next date on every row.

What the sheet will not do

It will not email the customer. It works offline in Excel. Google Sheets needs a connection unless Drive is set to offline. When the price is ready, send it with the free quote template.

  1. Download the free fillable CRM worksheet.
  2. Type the customer, the next step, and the stage.
  3. Keep Won and Lost on the list, and read the open total without them.
  4. Filter by stage when you review the week.
  • Clearing a Won row because it left the pipeline.
  • Leaving the next step blank.
  • Expecting a spreadsheet to send reminders.

Open the free fillable CRM worksheet. The other sales guides are on the blog.

Common questions

Is the CRM worksheet fillable?

Yes. The free fillable CRM worksheet is a spreadsheet. You type the customer, the next step, and the stage.

Is it a hosted CRM?

No. Contacts stay in your file. Nothing is emailed for you.

Which rows stay out of the open pipeline?

Won and Lost stay on the list so you can see history. They are not part of the open total.