How can easily I turn this CSV data into something more visual?

January 13, 2012 6:21 PM

I'm looking for some free software that will help me turn the CSV export from the Android time tracking app Gleeo into some simple visualizations (multicoloured horizontal bars?) without a huge amount of work.

The data includes things like the start and end times, as well as categories ("projects") and tasks within each project. I'm not looking for anything crazy fancy, I'm just curious if I'll be able to pick out trends in my workflow by visualizing it.

PROJECT   TASK      DETAILS   START              END                DURATION  Decimal Duration
ILS       Meeting   -         2012-01-10 08:43   2012-01-10 10:21   1:38      1.6333333333

posted by Decimask to Technology (6 answers total)

Best answer: If you have Excel, it can import the CSV into a table and create charts and graphs easily. If not, the Google Docs Spreadsheet app should also be able to do this.
posted by nalyd at 6:46 PM on January 13, 2012

Best answer: I think gnuplot is what you're looking for. I haven't used it in years, and there's a little bit of a learning curve, but it's powerful, command-line based, multi-OS and free.
posted by Simon Barclay at 6:51 PM on January 13, 2012

Best answer: check out google charts.
posted by the noob at 9:16 PM on January 13, 2012

Response by poster: Thanks for the suggestions folks, I'll have something to play with this weekend.
posted by Decimask at 7:13 AM on January 14, 2012

http://www.tableausoftware.com/public

I loves me some tableau.
posted by jopreacher at 11:38 AM on January 14, 2012

Many Eyes is great for taking in CSV data and using it to visualize in a ton of different ways.
posted by sub-culture at 7:17 PM on January 14, 2012