Table data analyzer

Question

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.

score 1 · Answer 1 · answered Dec 30 '09 at 14:20

1

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

answered Dec 30 '09 at 14:20

akira

63,447

score 1 · Answer 2 · answered Dec 30 '09 at 14:25

1

Microsoft Access

answered Dec 30 '09 at 14:25

Carling

229

score 1 · Answer 3 · answered Dec 30 '09 at 15:17

1

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

answered Dec 30 '09 at 15:17

RedFilter

506

score 0 · Answer 4 · answered Dec 30 '09 at 15:36

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

Table data analyzer

4 Answers4