FROM ROWS TO A REPORT PEOPLE WATCH

CSV to VideoOne spreadsheet. One clear takeaway.

Choose the category and metric that matter, check the grouped results, then turn them into a report video. Start with a browser preview before spending a credit. Have a sales export ready? CSV to video lets you focus the report on a selected metric, such as revenue by region or orders by channel.

UTF-8 CSV previewCategory & metric mappingSum or equal-weight average
01 / PREPARE YOUR DATA

Find the story in your rows

Free preview · 10 credits per video

Sample data · UTF-8 · Up to 10 MB / 20,000 rows

DATA PREVIEWChoose video styling in the next step
Regional revenue recap

USD (thousands)

North180South120West150

All 6 rows → 3 categories

RegionRevenueOrders
North12012
South808
West10010
North606
South404

Table shows the first 5 rows; the chart includes every row. Average gives each row equal weight.

This step parses and groups the CSV in your browser. Generating sends only the grouped data from your selected columns, not the original spreadsheet.

Confirm your data to choose Fast or Creative, narration, aspect ratio and duration.

FROM DATA TO A FINISHED VIDEO

Three steps. Keep the meaning intact.

01

Import and check

Choose a CSV or paste its contents. Switch between comma, semicolon and tab separators; quoted fields are supported. The first row must contain unique column names. Import up to 20,000 rows and 40 columns.

02

Map the metric

Select a category column, a different numeric column and an aggregation. The chart includes every input row, grouped into three to six categories. A five-row table preview helps you verify that the separator and headers are correct.

03

Tell the story

Send the approved summary to the video form on this page. Add a focus for your audience, then choose Fast or Creative. Narration, music, landscape or portrait, and MP4 export use the same report generation workflow.

Prepare a metric that is worth explaining

Sales reviews: separate revenue from volume

Grouping revenue by region answers how much each region contributed. Choosing order count answers a different question. Use sums for additive amounts and counts, but do not add up average order values. A weighted average needs the correct denominator: calculate total revenue divided by total orders in your spreadsheet before importing the final summary.

Marketing updates: make averages meaningful

The Average option gives every input row the same weight. That works for comparable observations, but conversion rates and click-through rates often require weighting by visits or impressions. An ordinary mean is not a substitute for that calculation. Prepare the business metric in the source spreadsheet, preserve its unit and time window, and use the video to explain the resulting comparison.

Excel and Google Sheets: export a clean sheet

In Excel, save the relevant sheet as CSV UTF-8. In Google Sheets, download the current sheet as comma-separated values. Remove merged headings and subtotal rows that would double-count the data. Check the decimal convention, headers and units before importing. If your task needs multiple sheets or document context, the general report creator also accepts XLSX files directly.

SYNTHETIC EXAMPLE · TRY IT ABOVE

Worked example: six sales rows, three regions

The synthetic sample has two rows per region: North 120 and 60, South 80 and 40, West 100 and 50. Sum produces 180, 120 and 150. Average produces 90, 60 and 75. Those results are calculated by the workbench rather than inferred by a model. The video receives the grouped values you approved and the aggregation description. This keeps the meaning of the chart explicit and avoids spending the narration on a row-by-row reading of the file.

Actual generated example · synthetic data · edit the workbench above to make your own

A dataset recap with a deliberate focus

This workflow creates one report video from a dataset; it does not generate a separate personalized marketing video for every row. Imports are limited to 10 MB and use UTF-8 text with decimal-point numbers. Clean currency symbols, percentage signs and locale-specific number formatting first. If you have more than six categories, filter the source file before importing: the tool will ask you to narrow the data rather than silently omit groups. Your raw CSV stays in the browser; generation sends the selected, grouped summary.

General report video creator

CSV to video: prepare a useful report from an export

Check what one row represents

First check what one row represents. For a CSV to video report, an order, a customer, a day and a monthly total all need different handling. That determines which numbers can be added. If an export contains both daily records and a monthly subtotal, summing all rows counts the same activity twice. Remove the subtotal or choose a clean export before importing, and keep one clear header row at the top.

Choose the grouping before choosing the story

For CSV to video, the category column answers “group by what?” and the metric column answers “measure what?” Region plus revenue produces a different report from region plus order count. Try both in the preview if you are deciding which question matters. Do not compare the heights of charts that use different units as if they described the same thing; explain each measurement on its own terms.

Know when a simple average is the wrong calculation

The Average option gives each row equal weight. A CSV with conversion rates for campaigns of different sizes usually needs a weighted calculation instead. For example, a campaign with ten visits should not have the same influence as one with ten thousand visits. Calculate the intended rate from its numerator and denominator in the source sheet, then import the result with a clear label and unit.

Use the sample to check your CSV to video setup

The sample has six records across three regions. Revenue grouped by region gives North 180, South 120 and West 150 when summed, or 90, 60 and 75 when averaged. Switching to Orders should change the values while keeping the categories. Try those controls before importing your own export. It is a quick way to understand what will be sent to the generator and what stays in the browser.

Keep the report focused when there are many categories

CSV to video works best here with three to six groups. If your export has dozens of products, prepare a clearly defined subset in the source sheet, such as one product family. Explain that scope in the title or brief so viewers do not mistake a subset for the whole business. Keep the underlying file for checking the finished chart and any totals or comparisons in the narration.

Questions before you start

How should I format the CSV?

Use unique, non-empty headers in the first row and a consistent column count. Choose a category and a different numeric column with three to six categories. Numeric values use a decimal point; blanks, percentages and locale-specific formats are not guessed.

Does the model receive my whole spreadsheet?

This page parses and groups the CSV in your browser. Generation sends the approved summary. If you add more attachments in the video form afterward, those files also become generation inputs.

Can I generate one video per row?

Not in this workflow. It creates one focused data report video from the selected metric, rather than a batch of personalized ads.

When should I upload an XLSX file directly?

Use the general report creator for multiple metrics, sheets or supporting documents. XLSX reads cached values and does not execute formulas or macros. Scanned PDFs do not have OCR support.

What costs credits?

Previewing, choosing columns and grouping data is free. Generating a video requires an account and costs 10 credits per generation. Review the aggregation and unit before starting.

Can I use a semicolon-separated file for CSV to video?

Yes. Choose Semicolon in the separator control, then check the headers and the first rows in the preview. Tab-separated content is also supported. If the columns do not line up, fix the separator before choosing a metric.

Does CSV to video include rows beyond the five-row preview?

The table displays the first five rows, while grouping uses every imported row within the supported limits. The page shows the total row count. An invalid value or too many groups produces a message rather than silently excluding those records.

Already have a short set of values? Edit them directly and choose a chart.

Chart to Video