I'm looking for an Excel-like web tool that can allow me to: 1) manually update row-based data; 2) have an API to automatically update certain fields of each piece of data.
Say I have 1M rows and would like to be able to show them in a tabular way. I like Excel but I think there must be something better out there. Is there?
Thanks
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...