How to create a short table

The short table you find in Datawrapper is internally named the "beautiful table". It is designed for use with a relatively small number of data points. In general, very often you can complement a data article with such a table, usually at the bottom of the test. The added quality is that your users can look up the precise numbers and values of different measure

Consider adding a table in a post where you already have a bar chart or line chart - adding the table with the actual data is then an added level of service. Or, as a variation, you have the fastest growing companies in the US in a big bar chart, then you can add a table showing key figures for the ten biggest gainers and the ten biggest losers.

This guide will walk you through the steps to create an short table with Datawrapper.

1. Preparing and importing the data

Before uploading your data into Datawrapper, you should check if your dataset is formatted correctly. Since you're probably going for a 1:1 iteration of your data in your spreadsheet programme, these following steps are highly dependent on the nature of your data.

Here is how your data should be prepared in a spreadsheet: 

  • One header row containing categories
  • The first column containing categorical dimensions
  • Each following column containing values of measures accoring to their dimension
  • Values of different dimensions/columns do not necessarily ahve to be of the same measures

Here is a table formatted as is shouldbe. 

Company Last Sale Change / Net % Share Volume
Apple Inc. 136.53 -0.58 / -0.42 20,788,186
Alphabet Inc. 831.33 +0.57 / +0.07 1,472,771
Microsoft Coporation 64.62 +0.26 / +0.40 20,273,128

Source:  NASDAQ

You can copy this table from this post and import it into Datawrapper. Once that is done, click "Upload and continue" to get to step 2. 

2. Check & Describe

In this step you have to check if Datawrapper copied your data correctly. If everything looks like it does in your spreadsheet programme, you're good to go.

Make sure that the box  "First row as lable" is ticked so that Datawrapper correctly assigns the values to the labels. Click on "Proceed" and Datawrapper will take you to the next step.

3. Visualize

The chart type to choose here is the " Short Table". Experienced users of Datawrapper will know that, but if you just started it is important to know that with the selection of this chart type the options and features available for this chart will change in the sections RefineAnnotate and Design. We cover this in a separate short tutorial found here.

Still need help? Contact Us Contact Us