If you need a hosted service, I would use Google Sheets and write a custom Google Apps Script to transform data. Supports up to 2 million cells [1]. You could

If you need a hosted service, I would use Google Sheets and write a custom Google Apps Script to transform data. Supports up to 2 million cells [1]. You could also use an Excel Web App and leverage the JS API or REST API via Excel Web Services [2]. For native Excel, I would look at DataNitro's Excel Add-in [3] for Python bindings. Similar to DataNitro, I wrote a JavaScript equivalent Excel Add-in that may be handy (contact me if interested). Other helpful tools: - Google Refine - Google Fusion Tables [4] - Tableau (doesn't render tabular/grid views) --- [1] https://support.google.com/drive/answer/37603?hl=en https://support.google.com/drive/answer/37603?hl=en [2] http://msdn.microsoft.com/en-us/library/ms582023.aspx http://msdn.microsoft.com/en-us/library/ms582023.aspx [3] https://datanitro.com/quickstart https://datanitro.com/quickstart [4] https://groups.google.com/forum/#!topic/fusion-tables-announce/4oB11Lpd4z8 https://groups.google.com/forum/#!topic/fusion-tables-announ...