up vote 0 down vote favorite
share [g+] share [fb]

I have a few CSV and XLS files that I would like to analyse or "visualize" online (like in charts etc).

I tried Google Fusion Tables, but I want to know if there are any alternatives.

Also suggest my a few tools I can download that would ease the process instead of using office excel.. (is OpenOffice good enough?)

link|improve this question
40% accept rate
Since you said 'download' I removed the 'web' from the title, as discussion of web apps/tools is off topic at SU. What OS are you using? What features are you finding Excel (and/or Google Fusion Tables) can't do for you? – techie007 Jun 16 '11 at 15:24
Nothing too complex.. I have a large list of marks of students with their roll nos.. im new to excel, but i'd like to see tools that would be out there that could make my tasks perhaps a bit more easier so I could focus on adapting with those tools instead. Im on windows 7. And fusion tables is too slow and doesn't chart out well with the large dataset and features are limited. – Power-Inside Jun 16 '11 at 15:29
Not a real answer, but here's some beginner info on charting in Excel "Demo: Create charts in Excel 2007" - office.microsoft.com/en-us/excel-help/… – techie007 Jun 16 '11 at 18:15
feedback

4 Answers

up vote 0 down vote accepted

You could try using QlikView (BI software)... http://www.qlikview.com/us

There is a free fully functional personal edition you can download from their website.

It is extremely powerful and there is a learning curve involved (not to bad if you only want to do simple things) but plenty of good free tutorials and an active, helpful community forum on their website as well.

It can import data from practically anything and has many built in wizards for doing such things as charts. It's also designed to handle massive recordsets very quickly and indeed it does.

The functionality within it is vast.

link|improve this answer
looks nicely and exactly fits my need. Thanks for the nice and free alternative! – Power-Inside Jun 17 '11 at 4:43
No problem - i have a number of their training course pdf files if you need them for reference. Would need your email addr to send. – Paul Jun 17 '11 at 11:46
feedback
up vote 1 down vote

Spotfire and Tableau are amazing commercial applications for this, and Spotfire especially is incredibly easy to use to explore lots of visualizations side-by-side. Both have a desktop version and an online web player (Spotfire demo gallery, Tableau demo gallery). They are both highly scalable, into the millions of rows. Both are expensive, but have free trials.

IBM's Many Eyes project is a free web-based collaborative tool that has lots of charts available.

link|improve this answer
feedback
up vote 0 down vote

my typical workflow:

  • think about graph with pen and paper
  • massage data in Excel and/or with script
  • create chart in ploticus

http://ploticus.sourceforge.net/doc/welcome.html

link|improve this answer
thanks, but too bad it doesn't have an interactive GUI that would be easier for me.. im looking for something fast and simple to learn to work with. – Power-Inside Jun 16 '11 at 15:30
I found that the lack of GUI interface makes me design my graphs in a more disciplined fashion. For a nice GUI interface take a look at Sigmaplot: sigmaplot.com/products/sigmaplot/sigmaplot-details.php – Florenz Kley Jun 20 '11 at 15:58
feedback
up vote 0 down vote

Try:

  • Google Docs - web (docs.google.com)
  • LibreOffice/OpenOffice - download: very good solution.
  • Microsoft Office Online - web (office.live.com, in Hotmail or Skydrive accounts)

Note: There are some incompatibility issues with files created in MS Excel opened not in MS solutions, but with the first two above you will rarely see it (except for XLSX format - try to save in XLS).

link|improve this answer
I forgot to mention that my spreadsheets were large.. google docs once said it couldnt handle 400000 cells.. i'll try other office suites btw thanks. – Power-Inside Jun 17 '11 at 2:56
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.