Learn how to create a

searchable data table.

Datawrapper knows more than just charts: Learn how to create a searchable and sortable data table.

Sometimes, you just want to give your readers the numbers. A lot of them. So what's the best way to present them?

If you want to show more than 20 rows of data, your best choice is probably the Data Table. Check out this efficiently visualized table created with Datawrapper:

It's super easy to create with Datawrapper. First, click here to create your chart. The next step is uploading your data. You can copy & paste data from Excel or the web, or upload your own CSV files. To re-create the table above, just copy & paste this dataset:

[["HDI rank","Country","Human Development Index (HDI)","Life expectancy at birth","Mean years of schooling","Gross national income (GNI) per capita"],["1","Norway","0.943","81.1","12.6","47,557"],["2","Australia","0.929","81.9","12","34,431"],["3","Netherlands","0.91","80.7","11.6","36,402"],["4","United States","0.91","78.5","12.4","43,017"],["5","New Zealand","0.908","80.7","12.5","23,737"],["6","Canada","0.908","81","12.1","35,166"],["7","Ireland","0.908","80.6","11.6","29,322"],["8","Liechtenstein","0.905","79.6","10.3","83,717"],["9","Germany","0.905","80.4","12.2","34,854"],["10","Sweden","0.904","81.4","11.7","35,837"],["11","Switzerland","0.903","82.3","11","39,924"],["12","Japan","0.901","83.4","11.6","32,295"],["13","Hong Kong, China (SAR)","0.898","82.8","10","44,805"],["14","Iceland","0.898","81.8","10.4","29,354"],["15","Korea, Republic of","0.897","80.6","11.6","28,230"],["16","Denmark","0.895","78.8","11.4","34,347"],["17","Israel","0.888","81.6","11.9","25,849"],["18","Belgium","0.886","80","10.9","33,357"],["19","Austria","0.885","80.9","10.8","35,719"],["20","France","0.884","81.5","10.6","30,462"],["21","Slovenia","0.884","79.3","11.6","24,914"],["22","Finland","0.882","80","10.3","32,438"],["23","Spain","0.878","81.4","10.4","26,508"],["24","Italy","0.874","81.9","10.1","26,484"],["25","Luxembourg","0.867","80","10.1","50,557"],["26","Singapore","0.866","81.1","8.8","52,569"],["27","Czech Republic","0.865","77.7","12.3","21,405"],["28","United Kingdom","0.863","80.2","9.3","33,296"],["29","Greece","0.861","79.9","10.1","23,747"],["30","United Arab Emirates","0.846","76.5","9.3","59,993"],["31","Cyprus","0.84","79.6","9.8","24,841"],["32","Andorra","0.838","80.9","10.4","36,095"],["33","Brunei Darussalam","0.838","78","8.6","45,753"],["34","Estonia","0.835","74.8","12","16,799"],["35","Slovakia","0.834","75.4","11.6","19,998"],["36","Malta","0.832","79.6","9.9","21,460"],["37","Qatar","0.831","78.4","7.3","107,721"],["38","Hungary","0.816","74.4","11.1","16,581"],["39","Poland","0.813","76.1","10","17,451"],["40","Lithuania","0.81","72.2","10.9","16,234"],["41","Portugal","0.809","79.5","7.7","20,573"],["42","Bahrain","0.806","75.1","9.4","28,169"],["43","Latvia","0.805","73.3","11.5","14,293"],["44","Chile","0.805","79.1","9.7","13,329"],["45","Argentina","0.797","75.9","9.3","14,527"],["46","Croatia","0.796","76.6","9.8","15,729"],["47","Barbados","0.793","76.8","9.3","17,966"],["48","Uruguay","0.783","77","8.5","13,242"],["49","Palau","0.782","71.8","12.1","9,744"],["50","Romania","0.781","74","10.4","11,046"]]

Once you've imported your dataset into Datawrapper, click Upload and continue. In step 2, we can check whether the data looks as expected. Everything looks good here, so let’s move to step 3. 

Creating your table

Datawrapper automatically created a bar chart with the data we just pasted in. This is nice, but we want a table! Click on Data Table in the Chart Type-section to change it.

In the Refine tab, we can make further adjustments to our table. For example, we can enable the Filter view to add a search box above the table, and let the table automatically display the data over multiple pages - with just one click!

Now, just add a title and a description and the table is ready to publish.

The finished table

This is the live version of the table we just created:


How to pubslish your table

Embedding charts into your website is super easy. If you use Datawrapper for free, you can download the chart as a ZIP file and host it on your own website yourself.

When you upgraded to Datawrapper single, you see a range of publishing options for your chart:

You can download the chart as a static image, but the best way to use a Datawrapper chart is by embedding it directly into your website. To do so, click on Export for embedding. Datawrapper automatically generates an iFrame-embed code that you can copy & paste directly into your CMS.

Copy the embed code into your website and you're done!

Other Interesting Tutorials

How to create a Stacked Column Chart

Learn how to create a stacked column chart in minutes with Datawrapper.

View Guide

All-new line charts

Datawrapper has completely revamped line charts: More responsive, cleaner and with annotations.

View Guide