How to deal with data All blog topics >
Tips on preparing data for simple charts and how-to guides for advanced needs.

How to deal with data

Tips on preparing data for simple charts and how-to guides for advanced needs.
All blog topics
How to match data with VLOOKUP in Excel & Google Sheets

How to match data with VLOOKUP in Excel & Google Sheets
VLOOKUP is a powerful formula to join (unordered) data. Here's a detailed explanation.
October 20th, 2021 by Lisa Charlotte Muth 8 min
Calculating with your uploaded data in Datawrapper is now easier

Calculating with your uploaded data in Datawrapper is now easier
June 2nd, 2020 by Lisa Charlotte Muth 4 min
How to import JSON data into Google Sheets to create a live COVID-19 chart

How to import JSON data into Google Sheets to create a live COVID-19 chart
April 21st, 2020 by Simon Haas 8 min
How to use the new Python library “datawrapper” to create 34 charts in a few seconds

How to use the new Python library “datawrapper” to create 34 charts in a few seconds
January 15th, 2020 by Sergio Sánchez 8 min
Why I created an R package to use Datawrapper’s API and how to use it

Why I created an R package to use Datawrapper’s API and how to use it
December 10th, 2019 by Benedict Witzenberger 6 min
How to prepare your data for analysis and charting in Excel & Google Sheets

How to prepare your data for analysis and charting in Excel & Google Sheets
October 23rd, 2019 by Lisa Charlotte Muth 19 min
How to split and extract text from data columns in Excel & Google Sheets

How to split and extract text from data columns in Excel & Google Sheets
October 23rd, 2019 by Lisa Charlotte Muth 4 min
How to get data in the right format with pivot tables

How to get data in the right format with pivot tables
April 24th, 2018 by Lisa Charlotte Muth 7 min

All Blog Topics

Climate visColor book updatesColor in data visCovid visData Vis Book ClubData Vis DispatchData vis do’s & don’tsDatawrapper NewsFix my chartHow to deal with dataMap StoriesMapsOpinionsTeam news and hiringThoughts and how-tosUncategorizedUnwrappedUser storiesWeekly Charts
View a chronological list of our articles Learn more about our newsletters