Sales Dashboard in Google Sheets: Build and Track Results

Yes—a sales dashboard in Google Sheets can summarize revenue, closed deals, sales by representative, and trends in one shareable view. Start with a clean sales table, calculate a few clearly defined metrics, then add charts and filters; the dashboard is only as trustworthy as the data behind it.

What a sales dashboard is for

A sales dashboard turns transaction records into a compact view of business performance. Instead of scanning rows one at a time, a manager can check whether revenue is on target, compare periods, and spot which products or regions account for a change. In Google Sheets, the dashboard can sit in a separate tab from the source data, so charts and summary figures do not interfere with data entry.

It is useful for a small team that needs a lightweight reporting tool, especially when its sales records already live in spreadsheets or can be exported from another system. It is not automatically a live connection to a customer relationship management (CRM) system. Unless you configure an integration or import process, the figures update only when the source data is updated.

Decide what decisions the page should support before choosing charts. A weekly sales meeting may need progress against a target and a list of deals needing attention; a monthly review may focus on revenue by region and product. A page crowded with every available measure is harder to interpret than one designed around a few real questions.

Prepare the source data

Keep transaction records in a tab named Sales, with one row per transaction or closed order. Use a single header row and consistent columns, such as Date, Rep, Region, Product, Units, Revenue, and Status. Dates should be actual date values, not text that merely looks like a date; Revenue and Units should be numeric. Avoid merged cells, blank header rows, and subtotals inside the dataset, because they make sorting, filtering, and charting less reliable.

For example, a small sample could contain four records: Alice has a closed $400 order on January 5; Ben has a closed $250 order on January 12; Alice has a closed $600 order on February 3; and Ben has an open $500 opportunity on February 8. If the dashboard reports closed sales for January, it should show $650—not $1,750—because it excludes the February records and the open opportunity.

Define what each field means. Decide whether Revenue is before or after discounts, whether cancellations are removed or marked with a status, and whether a deal counts when it is signed, invoiced, or paid. A consistent definition matters more than a sophisticated chart: two people using different definitions of “sales” can produce different totals from the same rows.

Choose a layout that is easy to maintain

A practical workbook has at least two tabs: Sales for the underlying records and Dashboard for summaries and visuals. A third tab called Lists can hold approved values for fields such as Region, Status, and Rep. Keeping the source table separate makes it easier to add transactions without accidentally overwriting a chart or headline figure.

Put the reporting period near the top of the dashboard, followed by a row of key performance indicators (KPIs), then charts and supporting breakdowns. Label each figure with its unit and period—for example, “Closed revenue, January” rather than simply “Revenue.” If the workbook has targets, show the target and the actual value together so readers can tell whether a number is good or poor in context.

Use consistent number formats: currency for revenue, whole numbers for deals or units, and percentages for rates. In Google Sheets, select the relevant cells and use Format > Number to choose an appropriate format. Formatting changes how a value appears, not the underlying calculation, so it should not be used to disguise missing or incorrectly typed data.

Build the dashboard in Google Sheets

Create the Sales, Dashboard, and, if useful, Lists tabs. Add one clear header row to Sales and enter dates and numbers as values.
On Dashboard, reserve cells B2 and C2 for the start and end dates. Enter January 1 and January 31 of the same year as actual dates, then label the cells so users know what they control.
Add a small group of summary metrics. For instance, put closed revenue in B4 and the number of closed transactions in B5. Keep the labels beside the results and format B4 as currency.
Check those results against a filtered view or a simple hand calculation before creating charts. For the four-record example above, January closed revenue is $650 and the transaction count is two.
Select the summary data you want to visualize and choose Insert > Chart. Use the Chart editor to select a chart type and adjust its setup and customization options.

Google Sheets saves changes automatically when you are online. Excel has similar spreadsheet capabilities, but its commands and some chart and filter interactions differ; the menu paths here refer to Google Sheets in a web browser.

Select useful sales metrics

Start with a small set of metrics that have clear definitions. Common choices include closed revenue, number of closed deals, units sold, average order value, and revenue by rep, product, or region. A pipeline view may also be useful, but keep open opportunities separate from booked or completed sales so that readers do not mistake a forecast for realized revenue.

For the formulas below, assume Sales!A2:A1000 contains dates, Sales!B2:B1000 contains reps, Sales!C2:C1000 contains regions, Sales!D2:D1000 contains products, Sales!E2:E1000 contains units, Sales!F2:F1000 contains revenue, and Sales!G2:G1000 contains status. Assume Dashboard!B2 and Dashboard!C2 contain the start and end dates. The fixed range through row 1000 works in Google Sheets and Excel, but expand it if the dataset grows beyond that row.

With that layout and the four sample records described above, place this formula in Dashboard!B4 to total closed revenue within the selected date range. With January 1 and January 31 selected, it returns $650: $400 plus $250.

=SUMIFS(Sales!$F$2:$F$1000,Sales!$A$2:$A$1000,">="&$B$2,Sales!$A$2:$A$1000,"<="&$C$2,Sales!$G$2:$G$1000,"Closed")

With the same columns and date selectors, place this in Dashboard!B5 to count closed transactions. It returns 2 for January: the January 5 and January 12 records meet both the date and status conditions.

=COUNTIFS(Sales!$A$2:$A$1000,">="&$B$2,Sales!$A$2:$A$1000,"<="&$C$2,Sales!$G$2:$G$1000,"Closed")

With Dashboard!B4 holding $650 and B5 holding 2, put this in Dashboard!B6 for average revenue per closed transaction. It returns $325, because $650 divided by two is $325. The error-handling function displays zero rather than an error if the period has no closed deals; label that case carefully, since zero average is not the same as missing data.

=IFERROR(B4/B5,0)

Choose charts and filters thoughtfully

Use a line chart when the question is how a metric changes over time, and a bar or column chart when comparing categories such as reps or regions. A pie chart is usually less useful when there are many categories or when values are close together. Give every chart a descriptive title, use readable axis labels, and avoid 3-D effects that make comparisons harder.

For a chart, select the summary table rather than the entire transaction sheet, then choose Insert > Chart. Check the Chart editor’s Setup options to confirm the data range, chart type, and whether the first row or column is being used as labels. A chart built from monthly totals is typically clearer than one plotting every raw transaction as a separate point.

For interactive exploration, Google Sheets offers slicers through Data > Add a slicer. A slicer can filter a table, chart, or pivot table that uses the same data source, but it does not automatically control every independent formula on the dashboard. Test the slicer with the particular charts and summaries you intend it to affect. For simpler source-data exploration, use Data > Create a filter on the Sales tab.

Keep totals accurate as records change

Set rules for how new rows are added, and make sure formulas and charts include the expected range. A formula limited to row 1000 will omit row 1001; a chart based on a manually selected block may also fail to include new categories. Review those ranges as the dataset grows, or use a Google Sheets table or a well-maintained range structure where available.

Standardize entries such as “North” versus “N.” and “Closed” versus “closed.” Inconsistent spellings can split what should be one category in a chart or pivot table. Google Sheets’ Data > Data validation feature can provide a dropdown for fields such as Status or Region, reducing accidental variation. It does not correct old records automatically, so inspect existing data as well.

Check edge cases: blank dates, duplicate transactions, refunds, and deals that change status. A duplicate row can inflate revenue even when every formula is correct. A date stored as text may be excluded by date comparisons. When totals look wrong, inspect the source rows and criteria before changing the formula; a dashboard should make the business rule visible rather than conceal it.

Sharing, access, and privacy

Google Sheets makes it easy to share a dashboard, but sharing should match the sensitivity of the data. Use the Share button to invite specific people or set a link-access level appropriate to the organization. Give view access to readers who only need reports and edit access only to people responsible for maintaining the workbook. Avoid putting personal, payment, or confidential customer information into a widely shared dashboard when aggregated figures will do.

Protecting a range can reduce accidental edits, but it is not a substitute for access control or a secure data system. A person with sufficient access may still copy information, and hiding a tab does not make its contents private. Keep a backup or version history available, and decide who owns the file so reporting does not depend on an unmanaged personal account.

When Sheets is enough—and when to use something else

Google Sheets is a reasonable choice for a small dataset, a quick team report, or a dashboard that people need to discuss and edit collaboratively. It is familiar, flexible, and can turn pasted or exported records into charts without requiring a dedicated analytics platform. The main costs are often staff time spent preparing data and maintaining definitions, rather than dashboard construction itself.

Limits become more noticeable when data arrives from many systems, needs frequent automated refreshes, contains complex permissions, or grows too large for a spreadsheet workflow. In those cases, a CRM’s built-in reports, a connected business-intelligence tool, or a database-backed reporting system may be more suitable. Google Sheets can still serve as a prototype: it helps a team discover which measures matter before investing in a more automated setup.

Sheets is not inherently more accurate than Excel or a reporting platform. Excel may fit teams already working in Microsoft 365, while a dedicated BI product may offer stronger data connections and governed reports. Choose based on the data source, refresh requirements, access needs, and the skills of the people who will maintain the dashboard—not on chart variety alone.

Frequently Asked Questions

Does Google Sheets have a sales dashboard template?

Google Sheets has a template gallery, and third-party providers also offer templates. Availability and suitability can vary, so check the fields, formulas, and sharing settings before relying on one. A template still needs your definitions, source data, and reporting period configured correctly.

Can a Google Sheets sales dashboard update automatically?

It updates when its underlying sheet data changes, but that does not mean an external CRM is being refreshed automatically. Automatic imports require a supported connector, script, or integration, and refresh frequency depends on that setup. Confirm the update process and its failure alerts before treating the dashboard as current.

How many metrics should a sales dashboard show?

There is no universal ideal number. Start with a few measures tied to specific decisions, such as closed revenue, deal count, and performance by month or region. Add a metric only when readers understand its definition and will use it; too many competing figures make the main signal harder to find.

Why does my Google Sheets sales total look wrong?

Check date values, status criteria, duplicated rows, and whether new records fall inside the formula or chart range. Also verify that revenue uses the same definition across the dataset—for example, whether refunds or discounts are included. Comparing the dashboard against a filtered set of source transactions can reveal which rows are included.

Can I use Google Sheets for sales forecasting?

Yes, but distinguish estimates from completed sales. A forecast can use opportunity amounts, expected close dates, and probability assumptions, while actual revenue should come from completed transactions according to your chosen rule. Label forecast figures clearly and review the assumptions; an estimated pipeline is not guaranteed income.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.