https://github.com/kennethreitz/tablib
Tablib: format-agnostic tabular dataset library headers = ('first_name', 'last_name') data = [ ('John', 'Adams'), ('George', 'Washington') ] data = tablib.Dataset(*data, headers=headers) Exports Drumroll please........... JSON! >>> print data.json [ { "last_name": "Adams", "age": 90, "first_name": "John" }, { "last_name": "Ford", "age": 83, "first_name": "Henry" } ] YAML! >>> print data.yaml - {age: 90, first_name: John, last_name: Adams} - {age: 83, first_name: Henry, last_name: Ford} CSV... >>> print data.csv first_name,last_name,age John,Adams,90 Henry,Ford,83 EXCEL! >>> open('people.xls', 'wb').write(data.xls) It's that easy. *I am wondering something like* data = tablib.Dataset(db(db.table.select().as_dict(), headers=headers) Then we can have DAL Rows written in to Excel, YAML and JSON. -- Bruno Rocha [ About me: http://zerp.ly/rochacbruno ]