bar chart race excel / Step-by-step workflow

How to Make a Bar Chart Race from Excel Data

Excel is best used as the data preparation step: clean the spreadsheet, export CSV, then preview or import the CSV into a race tool.

Start here Format Excel data for a bar chart race, export CSV, and preview the result online.

01

Choose long or wide format

Long format is best for tools. Wide format is convenient for spreadsheets and can be converted automatically by this MVP.
02

Export as CSV

Save the worksheet as CSV UTF-8. Avoid merged cells, formulas that return text, and thousand separators stored as strings.
03

Validate the file

Upload the CSV to the race maker page. The validator will flag missing date columns, missing values, and non-numeric values.

Copyable data

Use this starter table

Paste this into a spreadsheet or preview it in the chart tool before styling.

date,United States,China,Japan
2020,21322950,14687744,5040108
2021,23594031,17820459,4937422

Should I use rows or columns for categories?

Both are supported here. Long format is more universal; wide format is often easier inside Excel.

Can I make the animation inside Excel?

Excel can make static and some animated visuals, but dedicated race tools are usually faster for web-ready output.

Last updated: 2026-06-23