Turn a spreadsheet or CSV into a video

Paste the cells

Copy the cells in Excel or Google Sheets and paste them into the Data step. A CSV pasted as text works as well; tabs and semicolons are read like commas. The first line names the columns, for example Country,Population. A list with no heading line, such as Coal,35, works too.

What the maker does with your columns

• Names with one column of numbers become a ranking, shown as a format that fits.
• Years or dates down the first column become a line chart, with one line for each column of numbers.
• Numbers that add up to about 100 can become a part-of-whole chart such as a donut or waffle.
• If the format you are on can't show the rows, the maker moves to one that can and tells you, with an Undo.

Shares are shown as shares

Donuts and waffles draw each row as a share of the total, not as the number you typed. If your rows add up to 120, a row of 30 shows as 25%. The Data step's Shows as column says what will appear, and a note tells you when the total isn't 100.

Tidy the sheet first

Use one row for each item and leave out any total row, which would be drawn as one more item. Keep one unit per column, and say the unit in your words.