Downloadcsv2odf can create business intelligence reports from csv data sources with output to ods, odt, html, xlsx, or docx documents. It uses a template file that you design to control the layout, fonts, and colors. Just query your database with output to csv (or tsv), then use csv2odf to insert the data into your template to produce a nice looking formatted output. It is a command line tool and you can automate the generation of reports by using scripts and cron. It can be used to create spreadsheets and documents for LibreOffice, OpenOffice, Microsoft Office Excel and Word. It is open source GPL v3 and crossplatform, it can run on most operating systems that can run Python (Python is required). More details, example files, and online manual at http://csv2odf.sf.net.
Features
- Generate business intellegence reports for OpenOffice.org and LibreOffice.
- Generate business intellegence reports for Microsoft Office Excel and Word.
- Generate reports in ods, odt, html, xlsx, and docx format.
- Convert csv data into reports with formatted fonts and colors.
- Automate report generation using shell scripts and cron.
Project Samples
License
GNU General Public License version 3.0 (GPLv3)Follow csv2odf
User Reviews
-
I have been looking for something similar to csv2odf for 5+ years. Something that would help deal with Excel's weirdnesses loading csv data (because Excel is smarter than me, it transforms my pure string data into typed data, losing the original content in the process; like turning 01235 into 1235). Something that would require installation of no additional dependencies, no additional setup, no venv, no admin privileges, no different versions for different OSes. And the maintainer is super-responsive to fix changes required by modern versions of python. csv2odf handles all these with a simple python script. Thank you, Larry!
-
Very useful tool. Recent version 2.0x improved a lot on memory usage, reduced memory usage from 10GB to 30MB, great improvement !!! Another problem is speed. Currently, convert a csv with 10k lines (5.2MB size) to xlsx will need 3 minutes, for lager files, the time will increase a lot. If the conversion speed can improve a lot, that will be perfect.
-
Fantastic tool and very responsive dev!
-
I'm very happy about csv2odf selection. It's a useful tool to build good report. Technically speaking I appreciated following code attribute: - stable - well documented - fast - it's not overloaded with unnecessary function Finally the support it's very good. stefano