How to create a long table (archived chart type)

If you want to show more than 20 rows of data, your best choice in Datawrapper is the  Long Table. Check out the example below. It has quite a number of features, such as pagination and even a fast search. So consider the long table as an optional, additional piece of information, e.g. for rankings or detailed local election results. On occasion, a long table can be the main content of a post or article. 

Keep in mind though that in order to enable fully responsiveness, the number of columns has some limits. A long table with >10 columns will be squeezed on a mobile screen, simply because of the dimensions of the screen. Should you have that much information the recommended solution is to break up the table into several tables or visualizations. Mobile users can sum up to 50 percent or more of your readers, for them (and for the desktop users as well) it is better to not overdo a table. Instead try to think of breaking up the information you got into pieces, which are easier to understand. 

The chart type to choose is the " Long Table". If you just started working with Datawrapper, please note that the selection of the chart type will affect the options available in RefineAnnotate, and Design. We cover the customizing options for the long table specifically in a separate short tutorial found here.


Preparing and importing the data

If you want to create this chart type, your data needs to be in a certain format. You'll need:

  • One header row containing descriptive labels ("Model", "Base Price", etc.)
  • At least two columns with categories, numeric values or dates
    All the columns you upload will also be displayed in your table. Note that only columns with numeric values can be displayed with an "inline bar chart", as in the chart above. 

Here are five rows of the data we used to create the chart at the top of the page. You can download the whole dataset directly from the table above. Click on "Download data" at the bottom of the Datawrapper table to receive a .csv, that you can then upload into Datawrapper.

 Company Women earn x less

Share of men who received bonus pay

Share of women who received bonus pay Employer size
ALDI STORES  6.9 5.6 5.1 5000 to 19,999
AMERICAN AIRLINES, INC. 9.2 34.2 8.3 5000 to 19,999
ARGOS  20 85 93 5000 to 19,999
ASDA STORES  37 95 91 5000 to 19,999
B & M RETAIL  0.8 21.9 33.8 5000 to 19,999


These numbers are percentages, but it's best to download them without the percentage signs. We will add percentage signs later. 

Once you prepared your data, create a new chart in Datawrapper. You can do so by going to our homepage and clicking on "Create a chart". In Step 1: Upload, copy & paste your dataset or upload it as a .csv or an Excel or Google spreadsheet. After uploading the data, the textfield on the right will look like this:

Click "Proceed" at the bottom right to go to the next step.


Check & Describe

In the second step, you can check if your dataset was imported correctly and make changes to it - if necessary. If you did not upload a header row, you have to untick "First row as label" to avoid losing your first row of data. Always remember to do this if you don't have descriptive row and column headers.

In step 2, your data will look like the image below. You can see that Datawrapper correctly recognized your numbers as numbers (and not as text or dates) because they are colored in blue and are right-alined. To learn more about the Datawrapper's automatic recognition of data formats, visit this article.

(This screenshot doesn't show the full dataset – the first column is so big that the table become scrollable.)

Click on a table header to get to the "Edit column" menu, which lets you add percentage signs:

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



In this step, you'll see a grid of icons of chart types. To create this specific version of the table, head over to the drop-down list of Archived chart types under the grid of Chart types and select the option titled ''Long Table''

You will now see a long table, without a title, descriptions or customized colors. Maybe you want to further refine, annotate & define this chart. We cover this in a separate tutorial which you can find 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