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.


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

  • 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

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


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