# How to make a short video from Excel data

A spreadsheet holds the facts but not the story. Here is how to choose the numbers worth saying out loud, give them context, and turn an Excel or CSV file into a vertical video.

Guides · Updated 2026-11-20

## From rows to a story

Monthly sales, survey responses, class grades, inventory, the results of a campaign: a lot of small-business and classroom knowledge lives in spreadsheets. The data is there, but a spreadsheet does not say what matters. Sending it around rarely changes anything, because people do not have time to read a few hundred rows.

A short video does one thing a spreadsheet cannot: it tells people what the numbers mean, in order, in under a minute or two. “Our Saturday sales doubled after we opened earlier” is a story. Column F, rows 2 to 53, is not.

The overall process is the same as for any document, described in the [complete guide to turning a PDF into a video](https://abcontents.com/blog/pdf-to-video-guide). Data needs a few extra steps, covered below.

Make a video from your spreadsheet [Make my video](https://abcontents.com/create)

## Pick the number that tells the story

Before uploading anything, look at your data and answer three questions:

1. What changed? A rise, a drop, a record, a surprise.
2. Compared with what? Last month, last year, a goal, another group.
3. So what? What should the viewer do or understand because of it?

If you cannot answer all three for a number, it probably does not belong in the video. A good data video has one main figure and, at most, two supporting ones. Everything else can stay in the file for whoever wants the detail.

Examples: a coffee shop that sees oat milk orders grow month after month; a teacher whose class improved on the second test; a nonprofit that shows how donations were spent by category.

Be careful with small samples. If the class has twelve students or the survey had twenty answers, say so, and avoid percentages that sound bigger than they are. “Nine of our twelve students improved” is honest and still convincing.

## Prepare the file so the AI reads it right

ABContents accepts Excel, OpenDocument spreadsheets and CSV files. The AI writes the script only from your files and brief, so a tidy file gives a better script. A few minutes of preparation help a lot:

- Keep one table per sheet, with clear column headers such as “Month” and “Sales (USD)”, not “Col1”.
- Delete scratch columns, test rows and old versions you do not want mentioned.
- Write units and periods in the headers: currency, percentage, the year.
- If the key figure is a total or a comparison, calculate it in the sheet so the script does not have to.

Then use the brief (up to 600 characters) for context the numbers cannot give: who the video is for, which result to lead with, and what action you want. For example: “For our customers. Lead with the 30% faster delivery in October. End by inviting them to order online.”

If your workbook has many tabs, upload only the one that matters, or export that sheet as CSV. You can add up to 9 files, so a short Word note with the story you want told can sit next to the data.

## Say numbers so people understand them

Numbers are harder to hear than to read. Write them as you would say them and round when exactness does not change the message.

| In the sheet | Out loud |
| --- | --- |
| 12,487 | more than twelve thousand |
| 0.48 | almost half |
| From 3.2 to 6.1 | nearly doubled |
| Q3 2026 | from July to September |

Give each number its own sentence and a reason to care. “Almost half of our orders now come from WhatsApp. So that is where we will answer first.” Captions help too: ABContents burns word-by-word captions into every video, so the figure is seen as well as heard.

Order matters as well. Lead with the headline number, then the comparison, then what it means. Ending on the action, such as “order online” or “sign up for the next class”, gives the viewer something to do with the number they just heard.

## What to expect, and what to check

The video is narrated motion graphics drawn with code, in one of 24 styles; Data Pulse or Blueprint fit numbers well. It is not a pixel-perfect copy of your Excel chart. If you need the exact chart on screen for a board meeting, keep it in the deck and use the video to tell the story around it.

Always watch the finished video and compare every figure with the file before you share it. If anything is off, you get one free remake. For results in slides, see [PowerPoint to video](https://abcontents.com/powerpoint-to-video); to promote a result to customers, use the [AI marketing video maker](https://abcontents.com/ai-marketing-video-maker); and for a full results document, read [how to turn a report into a video](https://abcontents.com/blog/turn-a-report-into-a-video). Data that explains a topic fits the [explainer video maker](https://abcontents.com/explainer-video-maker).

Finally, keep the original spreadsheet. If someone asks where a number came from, you can point to the exact row, and next month you can update the file and make the new edition of the video in a few minutes.

## Questions

### Which spreadsheet formats can I upload?

Excel, OpenDocument spreadsheets and CSV, along with PDF, Word, PowerPoint, text and photos. You can upload up to 9 files for one video.

### Will my Excel chart appear exactly in the video?

No. The visuals are motion graphics drawn with code in the style you choose, not a copy of your chart. The script is written from your data and brief, so check each figure before sharing.

### How many numbers should a data video include?

One main figure and at most two supporting ones is a good rule for a short video. More than that is hard to follow by ear.

### Can I send spreadsheets automatically?

Yes. Developers can use the REST API or the MCP server with a prepaid API key, so a script or an AI agent can turn a weekly CSV into a video.

## Use cases

- [AI explainer video maker: motion graphics, not avatars](https://abcontents.com/explainer-video-maker)
- [Marketing video maker AI: a vertical ad from your product info](https://abcontents.com/ai-marketing-video-maker)
- [PowerPoint to video AI: from slides to a narrated vertical video](https://abcontents.com/powerpoint-to-video)
