Querying a CSV file
Posted
by
sheepsimulator
on Super User
See other posts from Super User
or by sheepsimulator
Published on 2009-07-17T14:58:43Z
Indexed on
2011/02/12
7:27 UTC
Read the original article
Hit count: 483
Does anyone know of a simple tool that will open up a CSV file and let you do basic, SQLesque queries on it? Like a graphical tool of sorts, one that is easy to use.
I know I could write a small script to do an import of the CSV into a SQLite database, but since I imagine someone else thought of this before me, I just wanted to inquire if one existed. What's prompting this question is I am getting frustrated with Excel's limited filtering capabilities.
Perhaps some other data visualization manipulation tool would provide similar functionality.
Free or OSS is preferred, but I'm open to any suggestions.
EDIT:
I really would prefer some clear tutorials on how to do the below instead of just "make your sheet an ODBC entry" or "write programs using ODBC files", or more ideas on apps to use. Note: I cannot use MS Access.
Yet another EDIT:
I'm still open for solutions using SQLite. My platform is a semi-ancient Win2k laptop, with a P4 on it. It's quite slow, so a resource-light solution is ideal and would likely get the win.
© Super User or respective owner