Turning a spreadsheet into report slides

The spreadsheet is where the work happened. It has the raw exports, the lookup tabs, the pivot that took an afternoon and the column nobody remembers adding. Then someone asks for “a few slides for Thursday”, and the temptation is to screenshot the busiest tab and paste it in.

A spreadsheet answers every question anyone might ask. A slide answers one. Turning the first into the second is an editing job more than a formatting one, and it goes faster when you treat it that way.

Decide what the deck is for

Before opening a slide tool, write down who will see the deck and what they will decide. A regional sales review needs different slides from a monthly finance summary built on the same workbook.

One sentence is enough: “The leadership team uses this to decide whether to move budget from the west region to the south.” That sentence tells you which tabs matter and which can stay behind.

Leave most of the spreadsheet behind

A typical working file holds far more than any meeting needs. Sort its contents before you build anything:

In the spreadsheet	On the slides?
Raw exports and data dumps	No
Calculation and lookup tabs	No
Summary figures and totals	Yes, the few that answer the question
Trend data	Yes, as one chart per question
Detailed breakdowns	Perhaps, as an appendix
Notes and assumptions	Yes, briefly, on a final slide

The appendix is useful. It lets you leave the detail out of the main story while keeping it a click away for the director who wants to see the branch-level figures.

One message per slide

Each slide should make one point, stated in its title. “West region revenue fell for the third month” is a slide title. “Revenue by region” is a tab name.

A practical way to plan the deck is to write the titles first, as a list, and read them in order. If the titles alone tell the story, the deck works. If they read like the tab list of the workbook, start again.

A short report deck often needs only five or six slides:

1. The headline. The one or two sentences that matter most this period.
2. Key figures. Four to six numbers, each with its comparison.
3. The main trend. One chart.
4. The breakdown that explains it. One chart or a small table.
5. What happens next. Decisions needed, actions, owners.
6. Notes. Data period, sources and definitions.

Rebuild tables, don’t paste them

A pasted block of cells is the most common weakness in report slides. Gridlines, tiny type, twelve columns and no hint of what to look at.

Rebuild any table you keep:

• Cut columns. Keep the two or three the point depends on, usually this period, the comparison and the change.
• Cut rows. Top five and “Other” beats a list of thirty.
• Round. ₹42.6 lakh, not ₹42,61,873.
• Highlight one row or column if that is what the slide is about.

If a table still needs more than about six rows and four columns, it probably belongs in the appendix.

Simplify the charts

Spreadsheet charts are built for the person analysing the data. Slide charts are built for a room. Fewer series, larger labels, and the conclusion in the title. Choosing the right chart for a recurring report covers which shapes hold up best when the numbers change each period.

For a one-off conversion, there are tools that will turn an Excel sheet into slides as a first draft. Treat whatever they produce the same way you would treat your own first pass: check the titles, cut what doesn’t serve the question and confirm every figure against the sheet.

Keep the numbers tied to the source

If the deck will be updated every month, copying values into it is a slow route to a mismatch. The figures on the slides should come from one place in the workbook, ideally a dedicated reporting tab, so that a correction in the sheet reaches the deck. Linking spreadsheet data to documents and slides explains how to set that tab up.

If you do paste values for a one-off, write the data date on the slide (“Figures as at 30 September”) so nobody mistakes it for a current view later.

Check before you share

A short routine catches most errors:

1. Pick three figures on the slides and find them in the sheet. Do they match?
2. Do totals on the slides still add up after rounding? If not, add a note.
3. Is the period stated on every slide that carries a number?
4. Does each title still say something true about the final figures?

Sharing the deck

How the deck travels matters. A slide file sent by email gets edited, re-forwarded and reopened in different software, where fonts and charts can shift. For a fixed record that looks the same for everyone, save the deck as a PDF before you send it, and keep the editable version for next month.

If the same figures go out every period, consider whether a linked report would serve readers better than a new deck each time. Live Documents is built for that case: the figures stay tied to the sheet, and the work each month is the explanation. For a one-off deck that won’t be repeated, an AI presentation maker can draft the slides around your figures, ready for the checks above.