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).
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
[2] http://msdn.microsoft.com/en-us/library/ms582023.aspx
[3] https://datanitro.com/quickstart
[4] https://groups.google.com/forum/#!topic/fusion-tables-announ...