save excel data to couchDB

Question

I'm wondering if there is a tool that will save/push my MS Excel (or OO calc) data to CouchDB database. Googling didn't help a lot so I don't think there is an existing solution for this.

Excel -> json -> Curl to CouchDB would do the trick but I'm still hoping there is something out there that will save my time on programming this.

Answer 1

If you get the Excel data into a JSON file as Sam Bisbee suggests, you should be able to use the tools/load.py script from couchdb-python to easily and quickly dump it into CouchDB without spending too much time writing your own. (Although I wouldn't think it would take that long to write your own...)

Check out this blog post about loading/dumping JSON into/out of CouchDB. The implementation uses Python.

Loading the JSON file should be as easy as:

./load.py –input=msg_db.json http://target-couchdb:5984/msg_db