How to Turn Excel Data into a Bar Chart Race Video

If you have ever watched one of those mesmerizing bar chart race videos on YouTube or TikTok and wondered how to make one from your own spreadsheet, you are in the right place. This guide walks you through every step—from formatting your Excel data to exporting a finished HD video—using Viral Data Race Studio, a free browser-based tool that requires no coding and no downloads.

Whether you are tracking sales figures, comparing country statistics, or visualizing sports rankings over time, the process is the same: prepare your data, export it, upload it, and let the tool handle the animation. The entire workflow takes about five minutes.

What You Need

Before you start, make sure you have these three things ready. That is genuinely all it takes:

• Excel or Google Sheets with time-series data — Your spreadsheet should contain values that change over time. Think GDP per year, monthly revenue by product, or weekly subscriber counts by channel. If your data does not change over time, a bar chart race is not the right format for it.
• A web browser — Chrome, Edge, Firefox, or Safari all work. No plugins or extensions needed.
• About 5 minutes — That includes formatting, uploading, customizing, and exporting. Seriously.

No software to install. No account to create. No credit card required. Let us get started.

Step 1: Format Your Data in Excel

The most important step in the entire process is getting your data into the right format. A bar chart race needs time-series data—values that change across time periods for multiple categories. The easiest format to work with is called wide format.

In wide format, each row represents a time period (a year, a month, a quarter) and each column represents a category (a country, a brand, a product). The cells contain the numeric values. Here is what it looks like:

Year    USA     China   Japan   Germany
2000    10.3    1.2     4.9     1.9
2005    13.0    2.3     4.8     2.8
2010    14.9    6.1     5.7     3.4
2015    18.2    11.1    4.4     3.4
2020    21.1    14.7    5.0     3.8

In this example, the first column is the time axis (Year), and each subsequent column is a category (USA, China, Japan, Germany). The values represent GDP in trillions of dollars. As you move down the rows, the bar chart race will animate forward in time, and the bars will grow, shrink, and re-rank based on the values.

A few formatting rules to keep in mind:

• Row 1 must be headers — The first row should contain column names. The first column header can be anything (Year, Date, Month), and the remaining headers become your bar labels.
• Keep values numeric — Do not include currency symbols, commas, or percentage signs in the cells. Use plain numbers only. You can add formatting later in the tool.
• Sort by time — Make sure your rows are in chronological order, from earliest to latest.
• No merged cells — Merged cells in Excel cause problems when exporting to CSV. Unmerge everything before saving.

If your data is already in a spreadsheet with time going down the rows and categories going across the columns, you are probably already in the right format. If not, a quick copy-paste and transpose in Excel will get you there.

Step 2: Export to CSV

Once your data is formatted correctly, you need to save it as a CSV (Comma-Separated Values) file. CSV is a universal format that every data tool understands, and it is what Viral Data Race Studio accepts for uploads.

From Microsoft Excel

1. Go to File → Save As (or Save a Copy in newer versions).
2. In the file format dropdown, select CSV (Comma delimited) (*.csv).
3. Choose a save location and click Save.
4. Excel may warn you about losing formatting. Click Yes to continue—you do not need any formatting for a CSV file.

From Google Sheets

1. Go to File → Download → Comma-separated values (.csv).
2. The file will download to your computer automatically.

After exporting, your CSV file will look like plain text with commas separating each value:

Year,USA,China,Japan,Germany
2000,10.3,1.2,4.9,1.9
2005,13.0,2.3,4.8,2.8
2010,14.9,6.1,5.7,3.4
2015,18.2,11.1,4.4,3.4
2020,21.1,14.7,5.0,3.8

That is exactly what the tool expects. Clean, simple, and ready to go. If you open your CSV in a text editor and it looks like the example above, you are good to proceed to the next step.

Step 3: Upload to Viral Data Race Studio

Now comes the easy part. Open the Viral Data Race Studio editor in your browser and get your CSV into the tool. You have two options:

1. Upload the CSV file — Click the upload button in the data panel and select your .csv file. The editor will parse the data automatically and populate the table.
2. Copy and paste — Open your spreadsheet, select all the data (including headers), copy it, and paste directly into the editor’s data table. The editor auto-detects the columns and rows from pasted data.

Either method works perfectly. Pasting is faster if you already have the spreadsheet open. Uploading is better if you have the CSV file saved and the spreadsheet is closed.

Once the data loads, you will see a preview of your bar chart race immediately. The bars will appear with default colors and settings, and you can already see which categories are leading at each time period. If something looks wrong—bars are missing, labels are garbled, or values seem off—go back and check your CSV formatting using the guidelines in Step 1.

If you do not have your own data ready, no problem. The editor includes built-in templates that you can use instantly—just pick one and start customizing.

Step 4: Customize and Export

With your data loaded, it is time to make the video look exactly how you want it. The customization panel gives you full control over the visual output:

• Color theme — Choose from 7 professionally designed palettes. Each theme assigns distinct, high-contrast colors to your bars automatically.
• Bar count — Set how many bars appear on screen. Top 10 is the most common choice, but you can show anywhere from 5 to 20 bars.
• Animation speed — Control pacing. Faster speeds work well for datasets with many time periods. Slower speeds let viewers absorb each transition.
• Number format — Display values as plain numbers, abbreviated (1.2M, 3.5B), currency ($1,200), or percentages.
• Title and labels — Add a headline, customize bar labels, and set the date display format.
• Aspect ratio — Choose 9:16 vertical for TikTok and Shorts, 16:9 landscape for YouTube, or 1:1 square for Instagram and LinkedIn.

Every change updates the preview in real time, so experiment freely. When you are satisfied with the look, hit the export button and your video will render directly in the browser. No server upload, no waiting in a queue—your data stays on your machine the entire time.

For a more detailed walkthrough of the creation process without any coding, check out our guide on how to make a bar chart race without coding.

Wide Format vs Long Format

When people talk about data formats for bar chart races, they usually mean one of two structures: wide format and long format. Both work with Viral Data Race Studio, but understanding the difference helps you avoid confusion when preparing your data.

Wide Format

Wide format is what we used in the examples above. Each row is a time period, each column is a category, and the cells contain values. It is the most intuitive layout if you are coming from Excel or Google Sheets:

Year    USA     China   Japan   Germany
2000    10.3    1.2     4.9     1.9
2005    13.0    2.3     4.8     2.8
2010    14.9    6.1     5.7     3.4

Long Format

Long format (also called “tidy” format) uses three columns: one for the time period, one for the category name, and one for the value. Each row represents a single data point:

Year    Country     GDP
2000    USA         10.3
2000    China       1.2
2000    Japan       4.9
2000    Germany     1.9
2005    USA         13.0
2005    China       2.3
2005    Japan       4.8
2005    Germany     2.8

Long format is common in databases and statistical tools like R and Python. If you downloaded your data from a data portal or API, it is probably in long format already.

Which Should You Use?

Either one. Viral Data Race Studio accepts both formats and detects which one you are using automatically. If you are building your data from scratch in Excel, wide format is usually easier because it looks like a normal spreadsheet. If you are downloading data from an external source, you can use it as-is without converting.

The key thing is consistency. Do not mix wide and long format in the same file—pick one and stick with it.

Common Data Formatting Issues

Even experienced spreadsheet users run into formatting problems when preparing data for a bar chart race. Here are the most common issues and how to fix them:

Missing Values

If a category does not have data for a particular time period, you have two options: leave the cell blank or enter 0. Blank cells will cause the bar to disappear for that time period and reappear when data resumes. Entering 0 will keep the bar visible but at zero length. Choose whichever makes more sense for your story. If a country did not exist yet, blank is appropriate. If sales were genuinely zero, use 0.

Text in Number Columns

This is one of the most frequent problems. Values like “$1,200”, “10.3T”, or “N/A” in your data columns will break the parser. Remove all currency symbols, unit abbreviations, commas in numbers, and text placeholders before exporting to CSV. Use only plain numeric values: 1200, 10.3, 0.

Date Format Issues

The time column should contain clean, consistent values. Years (2000, 2005, 2010) work best. If you are using months, a format like “2020-01”, “2020-02” works well. Avoid mixing formats—do not put “Jan 2020” in one row and “2020-02” in another. If Excel has auto-formatted your dates into something like “1/1/2020 12:00:00 AM”, reformat the column to a simpler date style before exporting.

Too Many Categories

A bar chart race with 50 categories will look cluttered and confusing. For the best visual result, keep your data to 15 to 20 categories maximum. If you have more, consider filtering down to the top performers or grouping smaller categories into an “Other” category. Remember, the tool lets you control how many bars appear on screen at once, but having cleaner underlying data produces better results.

Special Characters in Names

Category names with special characters like ampersands (&), accented letters, or quotation marks can sometimes cause parsing issues in CSV files. If a category name contains commas (e.g., “Korea, Republic of”), make sure the entire name is wrapped in double quotes in the CSV, or simply rename it to something simpler like “South Korea”. Most spreadsheet programs handle the quoting automatically during CSV export, but it is worth double-checking if you see garbled labels after uploading.

Example Datasets to Try

Want to practice with real data before using your own? Here are five excellent datasets that produce visually stunning bar chart races. Each one is available as a built-in template in the editor, or you can download similar data from the sources listed:

1. GDP by Country (1960–2025) — Watch economies rise and fall over 65 years. China’s explosive growth from the 2000s onward makes for a dramatic race. Source: World Bank Open Data. Available as a built-in template.
2. World Population by Country (1960–2025) — See India overtake China, and watch African nations climb the rankings. Source: United Nations Population Division. Available as a built-in template.
3. Top YouTube Channels by Subscribers — From the early days of YouTube to the MrBeast era, this dataset captures every major subscriber milestone. Source: Social Blade historical data. Available as a built-in template.
4. Cryptocurrency Market Cap (2013–2025) — Bitcoin dominance, the Ethereum surge, meme coin explosions—this is one of the most visually dynamic datasets you can race. Source: CoinGecko historical data. Available as a built-in template.
5. Global CO2 Emissions by Country — A sobering but powerful visualization showing which countries have contributed most to climate change over the past half-century. Source: Our World in Data. Available as a built-in template.

Each of these datasets follows the wide format structure described earlier. Open the editor, select a template, and you will have a working bar chart race in under 30 seconds.

Quick Tips for Excel Power Users

If you work in Excel regularly, these tips will speed up your workflow:

• Use VLOOKUP or INDEX/MATCH to pull data from multiple sheets into one summary table before exporting. The bar chart race needs all data in a single sheet.
• Transpose with Paste Special — If your data has time periods as columns instead of rows, select the range, copy it, right-click where you want to paste, choose Paste Special, and check the Transpose box.
• Use Find & Replace to strip out unwanted characters. Replace “$” with nothing, replace “,” with nothing, and your number columns will be clean.
• Name your columns clearly — The column headers become the bar labels in your video. “United States” looks better than “US_GDP_NOMINAL” on screen.
• Check for hidden rows or columns — Hidden data in Excel will still export to CSV, which can produce unexpected bars. Unhide everything and delete what you do not need before saving.

Your Spreadsheet Is Ready—Now Make It Move

You now know exactly how to take data from Excel or Google Sheets and turn it into a bar chart race video. The process is straightforward: format your data in wide or long format, export to CSV, upload to the Viral Data Race Studio editor, customize the visuals, and export your finished video. The entire workflow takes less than five minutes and costs nothing.

Bar chart race videos are one of the most engaging data formats on social media right now. A single well-crafted race can generate thousands—or millions—of views on TikTok, YouTube, and Instagram. And it all starts with the data you already have sitting in a spreadsheet.

Open the editor and turn your Excel data into a bar chart race now →