Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?)

share|improve this question
    
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? –  Ƭᴇcʜιᴇ007 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/… –  Ƭᴇcʜιᴇ007 Jun 16 '11 at 18:15

5 Answers 5

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.

share|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

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.

share|improve this answer

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

share|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

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).

share|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

You should check out Jolicharts (http://jolicharts.com). It creates data presentations directly connected to your data (Google Docs, Excel sheets, Database, etc.)

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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