How to create a table

Tables, despite their seemingly simple nature, can be one of the most effective data visualization tools in your toolbox. Their ability to host a different "data type" - words, specific numbers, images, sparklines, or bar charts - in each cell makes them surprisingly versatile. The combination of words, numbers, and images all in an organized grid makes communicating a lot of information easier on the.

This guide will show you how to create your first table with Datawrapper. Our tables are surprisingly feature-rich and fully responsive, meaning they will adapt to different screen sizes. We'll use the example of the change in life expectancy by country from 1960-2016, since it was used in our blog post introducing the new table features.

1

Preparing and importing the data

This is perhaps the most flexible chart type Datawrapper offers. The chart requires:

  • at minimum, one column or one row of any data type (number, text, or date)

  • That's it! Of course, it is likely and expected that you will have more than one column or row of data. Remember that Datawrapper identifies columns (not rows) by data type, so plan accordingly when importing data. You can also choose whether or not the first row are labels. For more information about cells with images, see the article about parsing markdown. Additionally, if you'd like to have a column with country flags, see this article. Heres a small snippet of the data we used:

    Country 1960 1961 1962 1963 1964
    Afghanistan 32.29 32.74
    33.18
    33.62
    34.0
    Angola 33.25
    33.57
    33.91
    34.27
    34.64
    Albania 62.28
    63.30
    64.19
    64.91
    65.46
    United Arab Emirates 52.26
    53.31
    54.35
    55.37
    56.38
    Argentina 65.02
    65.14
    65.23
    65.31
    65.39
    2

    Check & Describe

    Datawrapper automatically detects empty cells (in red) and assigns null-values. These will simply not be charted so you don't have to worry about them. You will also notice that Datawrapper automatically identifies the values as either a number, text, or date. If you see that your data was recognized as the wrong format, change the format in your CSV/XLS, then import it again into Datawrapper. When you're ready, click proceed.

    Click on  "Proceed" at the bottom left to go to Step 3: Visualize:

    3

    Visualize

    The chart type to choose here is "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 Refine, Annotate, and Design. We cover how to customize your table in a separate tutorial found here.

    You will now see a table, without a title, descriptions or customized colors. Maybe you want to further refine, annotate & define this chart.   We cover this in a separate short tutorial found here.

    Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

    Still need help? Contact Us Contact Us