{"id":13075,"date":"2026-09-19T15:09:04","date_gmt":"2026-09-19T15:09:04","guid":{"rendered":"https:\/\/templacity.com\/?post_type=product&#038;p=13075"},"modified":"2026-11-09T09:56:11","modified_gmt":"2026-11-09T09:56:11","slug":"sales-crm-pipeline-spreadsheet","status":"publish","type":"product","link":"https:\/\/templacity.com\/zh\/product\/sales-crm-pipeline-spreadsheet\/","title":{"rendered":"Sales CRM &#038; Pipeline Spreadsheet (Google Sheets + Excel)"},"content":{"rendered":"<p><span class=\"eyebrow\">\u2116 \u00b7 Will the month land?<\/span><\/p>\n<h2 id=\"a-sales-crm-spreadsheet-with-a-pipeline-board-follow-up-dates-and-a-forecast-you-can-trust\">A sales CRM spreadsheet with a pipeline board, follow-up dates and a forecast you can trust<\/h2>\n<p>The Sales CRM &amp; Pipeline is for a freelancer, a founder or a small sales team that has outgrown a list of names but does not want a CRM subscription. Put your monthly target on Settings and, if you sell as a team, the owners. Every opportunity is one row on Deals: company, contact, owner, source, stage, value, expected close, next step and a follow-up date.<\/p>\n<h3>The follow-up date runs it<\/h3>\n<p>Every open deal should carry one, and a deal without it says &#8220;No date&#8221; until it does. Each morning the Dashboard lists the follow-ups due and overdue, and the Board lays the pipe out as a column per open stage, biggest deals first. Contacts pulls each person&#8217;s last contact from the Activities log, and anyone quiet for 30 days with an open deal turns red.<\/p>\n<h3>Calls before they are contacts<\/h3>\n<p>Calls come before deals, so the Call Log keeps them: date, name, phone, source and what happened (talked, appointment set, voicemail, no answer, not interested, wrong number), with a call back date that flags itself overdue and a column that tells you once the person is in Contacts. The top of the tab counts calls and conversations over the last seven days, appointments set over thirty, and the call backs due.<\/p>\n<h3>A forecast weighted by stage<\/h3>\n<p>Stages run Lead, Qualified, Proposal and Negotiation, then Won or Lost, each with a chance of closing (10, 25, 50, 75%) you can set to your own history. Weighted value, value times chance, is the steadier forecast. What If says where the month lands at your own win rate, the day you cross the target at this month&#8217;s pace, and what a better win rate or a few more deals would be worth.<\/p>\n<p>The download is a short PDF with two Google Sheets buttons, one for a blank copy in your own Drive and one for a copy filled with an example, the same workbook as blank and example Excel files, and a one-page Quick Start for each.<\/p>\n<p>Planning on a tablet or on paper instead? <a href=\"\/find-your-planner\/\">Find your planner in 60 seconds<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Deals as a kanban board by stage, a weighted forecast against your monthly target, a call log with call backs that flag themselves, and contacts that turn red when a live deal goes quiet.<\/p>\n","protected":false},"featured_media":13273,"comment_status":"open","ping_status":"closed","template":"single-product-bundle.html","meta":{"rank_math_title":"Sales Tracker and CRM Spreadsheet for Sheets and Excel | Templacity","rank_math_description":"A sales CRM and pipeline tracker for Google Sheets and Excel: kanban deal board, weighted forecast, follow-up flags and win rate by source.","rank_math_seo_score":"14","_templacity_copy_live":"1","_templacity_faq":[{"q":"How does it remind me to follow up?","a":"Every deal has a follow-up date. The Dashboard lists the ones due today and those overdue, and Contacts turns anyone red who has an open deal and no contact for 30 days."},{"q":"What is weighted value?","a":"The deal's value times its stage's chance of closing, 10% for a Lead up to 75% at Negotiation to start. Change the chances on Settings to match your own record."},{"q":"Why are there two win rates?","a":"The Dashboard counts deals; What If weighs money. A month's target is money, so the forecast uses the money one."},{"q":"Can a team use it?","a":"Yes. Add each seller as an owner on Settings. The Dashboard shows who is winning, and in Google Sheets everyone can work in the same copy."},{"q":"Can I rename the stages?","a":"Yes, but keep six, with Won and Lost last. The first four count as open."},{"q":"Does it work in Excel?","a":"Yes. The download carries native .xlsx files, one blank and one filled with an example, for Excel 2010 and later, Excel for Mac and Microsoft 365. Every formula is ordinary Excel, with no macros to enable."},{"q":"Is there a year printed in it?","a":"No. No year is printed anywhere in the files, so it starts the day you do and keeps working next year."}]},"niche":[337],"template_type":[],"templacity_topic":[],"product_brand":[],"product_cat":[24],"product_tag":[44],"class_list":["post-13075","product","type-product","status-publish","has-post-thumbnail","niche-spreadsheets","product_cat-spreadsheets","product_tag-google-sheets","first","instock","downloadable","virtual","purchasable","product-type-simple"],"_links":{"self":[{"href":"https:\/\/templacity.com\/zh\/wp-json\/wp\/v2\/product\/13075","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/templacity.com\/zh\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/templacity.com\/zh\/wp-json\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"https:\/\/templacity.com\/zh\/wp-json\/wp\/v2\/comments?post=13075"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/templacity.com\/zh\/wp-json\/wp\/v2\/media\/13273"}],"wp:attachment":[{"href":"https:\/\/templacity.com\/zh\/wp-json\/wp\/v2\/media?parent=13075"}],"wp:term":[{"taxonomy":"niche","embeddable":true,"href":"https:\/\/templacity.com\/zh\/wp-json\/wp\/v2\/niche?post=13075"},{"taxonomy":"template_type","embeddable":true,"href":"https:\/\/templacity.com\/zh\/wp-json\/wp\/v2\/template_type?post=13075"},{"taxonomy":"templacity_topic","embeddable":true,"href":"https:\/\/templacity.com\/zh\/wp-json\/wp\/v2\/templacity_topic?post=13075"},{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/templacity.com\/zh\/wp-json\/wp\/v2\/product_brand?post=13075"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/templacity.com\/zh\/wp-json\/wp\/v2\/product_cat?post=13075"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/templacity.com\/zh\/wp-json\/wp\/v2\/product_tag?post=13075"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}