Archives

How to: convert KML into other formats with Open Refine

Original image by GotCredit/Flickr Maps are a powerful tool to visualise data because they can explain stories with a high level of detail. You can show the data within countries, regions or even electoral wards. The only thing you need to know is how to work with KML files. The open source data cleaning tool Open Refine can help …

How to: use Open Refine to open a rebel CSV file

Image by Craig Chew-Moulding/Flickr CSV files are a common format when working with spreadsheets. The process to open a CSV file is really easy and usually takes only a couple of minutes, as this tutorial shows. However, what can you do if the standard process fails? You can use Open Refine, a powerful tool that can help …

How to: open a CSV file with Excel

(Image by r2hox/Flickr) CSV – comma separated values  – is a common format for datasets. Excel or the free spreadsheet software Google Sheets can open them easily and, in some cases, automatically. Open your CSV file with Excel. You will get a messy data set without format, but don’t panic: that is how a CSV should look like. Select …