Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top


I have big file that contains log information. Suppose, it in CSV format and has table structure. I want tool that can load this file and make some queries. For example: show often repeated entries, count of same entries etc.

share|improve this question

closed as off-topic by Ben N, fixer1234, DavidPostill, mdpc, Wes Sayeed Mar 30 at 1:37

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Questions seeking product, service, or learning material recommendations are off-topic because they become outdated quickly and attract opinion-based answers. Instead, describe your situation and the specific problem you're trying to solve. Share your research. Here are a few suggestions on how to properly ask this type of question." – Ben N, fixer1234, DavidPostill, mdpc, Wes Sayeed
If this question can be reworded to fit the rules in the help center, please edit the question.

'excel' comes to mind. otherwise 'r', the language for statistical computing, especially 'importing spreadsheet like data' is worth reading.

share|improve this answer
    
file contains thousands of records so excel doesn't match and visual tool will preferred. – user23099 Dec 30 '09 at 14:38
    
excel is capable of displaying 32k rows ... – akira Dec 30 '09 at 16:01

Microsoft Access

share|improve this answer
    
Didn't find how to import data – user23099 Dec 30 '09 at 14:40
1  
Look harder. :) Try opening the csv file with Access. – phoebus Dec 30 '09 at 14:58

Try Microsoft's Log Parser. Some more info here, and a GUI for it here.

share|improve this answer

Excel is your best bet. I agree with @akira

Access is too complicated for this task. You would have to mess around with wizards and not quite get what you want or figure out SQL

Excel is more than enough 'visual'. You can make pivots and charts to get a better sense of your data

share|improve this answer