Archives

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 …