How to work with Excel XLS files outside of Excel
I’ve previously talked very briefly about scraping tabular data from the web. That post pointed to a nice shortcut by Tony Hirst of OUseful.Info to import a HTML table into a Google Spreadsheet. In one of his most recent posts Tony Hirst goes into some detail with regards to using tabular data in Excel’s XLS format (not the more recent XML-based XLSX format) – without actually owning a copy of Excel (this applies to me, at least privately). The post describes how to use Google Refine or the xlrd Python package to digest and manipulate XLS files.
Google Refine is an offline-product (so your data does not need to be sent to Google’s servers) which offers some powerful functionality to comb through and correct data. You can for example correct individual typos in category names and similar things very quickly. Note however, that this is a semi-specialist tool, watching the introductory movies on the website is advisable.
xlrd is a Python package that can be used offline like any other Python package. However, as an added value Tony Hirst describes how you can combine xlrd with Scraperwiki to deploy a cloud-hosted data scraper for online XLS files.
So, recommended read if the above sounds interesting to you: Working with Excel Files without Using Excel.