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

4 Answers 4

'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

Your Answer

 
discard

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