Blog

How do I turn a spreadsheet into a report? Five steps in Excel or Google Sheets

2 October 2026 · updated 16 November 2026

Five steps: make your data one clean table, total it with a pivot table, put the headline numbers at the top, add one chart and a three-sentence summary, then export the page to PDF. In Excel or Google Sheets this takes about an hour the first time and ten minutes once it is set up.

1. Make the data one clean table

Most reports go wrong here, before any chart is drawn.

  • One header row, one row per sale, invoice or expense.
  • No merged cells, blank rows or subtotal rows inside the data. Totals belong in the report, not in the list.
  • One kind of value per column: dates as real dates, amounts as numbers (no "£" typed into the cell, no "TBC").
  • Consistent names. "Mug", "Mugs" and "mug large" will be counted as three products. Fix them first.

In Excel, click in the data and press Ctrl+T to make it a Table; in Google Sheets use Format → Convert to table. Both then grow as you add rows.

2. Total it with a pivot table

Insert → PivotTable (Excel) or Insert → Pivot table (Sheets). Put the category (product, customer, month) in Rows and the amount in Values as a sum. Add a second pivot for totals by month if you want a trend.

3. Put the headline numbers at the top

On a new sheet, the first thing anyone reads should be three to six figures: total for the period, number of orders, average order value, and the same figures for last month or last year beside them. Show the change as an amount and a percentage ("up £840, or 7%").

4. Add one chart and a short summary

  • A line chart for change over time, a bar chart for comparing categories. Avoid pies with more than four slices.
  • Under it, three sentences in plain English: what happened, why you think it happened, what you will do about it.

5. Export to PDF

Set the print area to the report sheet, fit it to one page wide, and use File → Export → PDF (Excel) or File → Download → PDF (Sheets). A PDF reads the same on every phone and cannot be changed by accident.

Can I make this run by itself?

Yes, at two levels:

  • Inside the spreadsheet: keep the data as a Table and the pivots and chart refresh when you paste in next month's rows (Data → Refresh All in Excel).
  • Outside it: a small script can take the export file and write the finished Word and PDF report with no one opening a spreadsheet. We built one: CSV or Excel in, a report with headline totals, summary tables and charts out. Built into a business's own system, it can run on the first of every month and email the PDF.

Frequently asked questions

How long does it take?

About an hour the first time in Excel or Google Sheets, mostly cleaning the data. Once the table, pivots and chart exist, a new month takes ten minutes.

What should go in a monthly report?

Headline figures with comparisons, a short summary, one trend chart, two or three breakdowns and a line on unpaid invoices. See what a monthly sales report should include.

Why does my pivot table show the wrong totals?

Usually text where numbers should be (a "£" or a space typed into the cell), blank rows that cut the data short, or a subtotal row counted twice. Fix the table and refresh.

Word or PDF?

PDF for sending and reading; Word if someone needs to edit the wording before it goes out.

Related on B.A.I.S.


Need this done for you? Spreadsheet to one-page PDF report

Have it done for you

Turn your spreadsheet export into a report with charts

From £15 for one report · back in 1 working day

Send a CSV or Excel export, get a Word and PDF report: headline total, summary table, totals by category and charts. Checked by hand.