How to turn a spreadsheet into a dashboard

1. Get the data into shape

Dashboards need tidy data: one header row, one row per record, one kind of value per column.

• Remove merged cells, blank rows and subtotal rows
• Use real dates, not text like 'Jan-ish'
• Keep numbers as numbers (no 'Rs' or commas typed in)
• Use consistent names (not 'Colombo', 'colombo' and 'CMB')

2. Decide the question and the reader

Write one sentence: 'Our sales manager needs to see which regions are behind target this month.' The reader and question decide everything else. A dashboard for everyone is useful to no one.

3. Pick three to six numbers

Put the most important numbers in large cards at the top: totals, averages, rates. If a number would not change anyone's decision, leave it out.

4. Choose charts that fit

Trends over time: line chart. Comparing categories: bar chart. Parts of a whole with few parts: a simple share chart. Exact values: a table. See our guide on which chart to use.

5. Lay it out in reading order

People read top-left to bottom-right. Headline numbers first, then the main trend, then breakdowns, then the detail table. Add filters so readers can answer their own follow-up questions.

Do it in minutes with DashForge

Upload your Excel or CSV and DashForge detects column types, plans numbers and charts for your question, and lays them out with filters and a table. Your file is read in your browser, and you can try a free sample dashboard first.

Do I need Power BI or Tableau?

Not for most small dashboards. A spreadsheet or a tool like DashForge is enough.

How many charts should a dashboard have?

Usually four to eight. More than that and nothing stands out.

Should I use pie charts?

Only for a few parts of a whole. Bar charts are easier to compare.

How often should I update it?

As often as the decision it supports: daily for operations, weekly or monthly for most businesses.