Skip to main content
16 votes

Is there a software tool which allows to perform SQL on CSV files?

Have a look at q q is a command line tool that allows direct execution of SQL-like queries on CSVs/TSVs (and any other tabular text files). https://github.com/harelba/q
Benjamin Crouzier's user avatar
10 votes

Is there a software tool which allows to perform SQL on CSV files?

The 'problem' with a CSV file is that the single 'table' doesn't have a name. Therefore, you'll need to define a table (including columns) and import the CSV file before doing any SQL queries on it. ...
Glorfindel's user avatar
  • 2,035
7 votes

Modern C++ CSV reader/parser library

Two libraries that fits the requirements and several of desired features: Rapidcsv CSVstream Fast C++ CSV Parser I start to test them few days ago, so I can not confirm all the features, however I ...
campisano's user avatar
  • 171
7 votes

Program to generate a CSV file from an image containing a table

I have found something amazing http://tabula.technology/ this is the best tool we have! It's also Free. It works really well with PDF files but even works fairly well with well formed tables like ...
myusuf3's user avatar
  • 121
5 votes
Accepted

Convert JSON to CSV

Python is: Free, Gratis & Open Source including commercial use Available for windows, along with just about everything else, although recent versions (post 2.5.4) have dropped Windows XP support ...
Steve Barnes's user avatar
  • 31.7k
5 votes

Software to build a regression model with 3.5 GB CSV on a low memory PC

Take a look at the Dask library. (http://dask.pydata.org/en/latest/). It extends pandas' DataFrames and Numpy arrays for larger-than-memory computation. Here's a blog post about using Dask with ...
Victor Lira's user avatar
5 votes
Accepted

Open-source CSV viewer & editor

I like OpenRefine. According to the documentation : OpenRefine is a Java-based power tool that allows you to load data, understand it, clean it up, reconcile it, and augment it with data coming from ...
Gounou's user avatar
  • 706
4 votes

Program to generate a CSV file from an image containing a table

ABBYY FineReader does very good job when it comes to optical recognition. Probably the best on the market. And it can also export to *.csv, among many other formats. The downside is, it is not free ...
andselisk's user avatar
  • 292
4 votes

Is there a software tool which allows to perform SQL on CSV files?

If you have the flexibility to use some light scripting languages try - R script - It has sqldf library which can be used to run sql queries on dataframes. You just have to read your csv into a ...
skybunk's user avatar
  • 141
4 votes

Is there a software tool which allows to perform SQL on CSV files?

Try csvsql. It is part of csvsuite, a suite of command line tools written in python, since March 2019 tested against Python 3.7. The csvkit tools are described in the book Data Science at the ...
knb's user avatar
  • 3,000
4 votes

Is there a software tool which allows to perform SQL on CSV files?

Using PostgreSQL and DBeaver is another option. PostgreSQL is a sophisticated, open source database system. It allows for importing CSV files through the COPY command and through graphical UIs such as ...
Lars Helge Øverland's user avatar
3 votes

Web app for reviews of proposals imported from CSV

You can try out the Proposal Review template on Simitless. you can either use it as is or take it as inspiration and modify it by deleting or adding new columns (or creating new things altogether), ...
Alex's user avatar
  • 1,974
3 votes

Convert JSON to CSV

Since you are in a Windows environment have you considered PowerShell? It meets all of your criteria and you already have it available (no need to install anything). This command will do what you ...
Jason Boyd's user avatar
3 votes

Lightweight contact manager for Linux with import & export feature

Old question but maybe someone needs an alternative. See Evolution. Osmo seems lightweight but it seems not to support vCard so I ended up using Evolution. It is not as "lightweight" as Osmo what ...
pirho's user avatar
  • 133
3 votes

Is there a software tool which allows to perform SQL on CSV files?

SQLite is a nice lightweight tool that is supported by multiple languages. If you use Python, there are several tools in the Python Package Index (pypi.org) that make it easy to use (including https:/...
rd_nielsen's user avatar
3 votes

Is there a software tool which allows to perform SQL on CSV files?

Try RBQL - it provides SQL-like dialect with Python or Javascript expressions. You can use RBQL from the command line (RBQL in pip) And from Rainbow CSV text editor extensions which provide nice GUI ...
user150547's user avatar
3 votes

Is there a software tool which allows to perform SQL on CSV files?

I know I'm late to the party, but I've created a Desktop app that can perform SQL on a bunch of CSV files. It is a Desktop app because it can easily handle a 600MB CSV file (only taking ~15 seconds to ...
Tanin's user avatar
  • 131
3 votes
Accepted

"MailMerge" for CSV + Markdown

I was looking for something similar, and since I could not find it, I wrote a small python script following the principles outlined by rd_nielsen. https://gist.github.com/frederik-elwert/...
Frederik's user avatar
3 votes

Parsing large (30GB) XML into CSV (with Python)

One possibility is a streaming XSLT 3.0 processor, which given your constraints means in practice Saxon/C Enterprise Edition (this has a Python language binding). There is actually a CSV-to-XML ...
Michael Kay's user avatar
3 votes
Accepted

WYSIWYG CSV editor that logs changes

Try using version-control software, such as Git. You can then edit the file however you want, such as with your favorite text editor, and you'll be able to look at previous versions and the ...
Kodiologist's user avatar
  • 1,197
3 votes

Open-source CSV viewer & editor

AlternativeTo.Net lists a bunch of alternatives to CSVed but they all seem to be VERY VERY unmaintained/outdated. Since you mentioned Notepad++, There is a maintained plugin for it called CsvQuery ...
Lockszmith's user avatar
2 votes

Tools for big CSV files manipulations

You could try datamash https://www.gnu.org/software/datamash/manual/datamash.html Also importing your records into mysql. importing into sqlite. sqlite> .mode csv sqlite> .import test.csv ...
cybernard's user avatar
  • 1,724
2 votes

Android app for exporting contacts properly to csv / ods / xlsx

first of all i have to say vCard (.vcf) is the standard for exchanging/storing contact-information and if somehow possible you should stay with it for data-consistency! export your contacts from the ...
DJCrashdummy's user avatar
  • 1,658
2 votes

Convert JSON to CSV

Although not free, there's a cheap (~5$) option - Data Transformer (disclaimer - I'm its developer). It converts between CSV, JSON, XML, and YML locally. It offers a number of conversion settings (...
Geo Systems's user avatar
2 votes
Accepted

Software to make text analysis of csv file

There is - the combination of python/jupyter and Pandas is excellent for this sort of thing. Open Source & Gratis Read large CSV files Lots of data analysis & visualisation tools Cross ...
Steve Barnes's user avatar
  • 31.7k
2 votes
Accepted

JavaScript chart webapp

Jupyter Notebook is a web application that allows you to create and share documents that contain live code, equations, visualizations and explanatory text. Google Colaboratory is Google's free Jupyter ...
karel's user avatar
  • 1,636
2 votes
Accepted

Transpose a 150x3000 field CSV file

Microsoft Excel will do this for you. It has a special paste option called 'Transpose': It supports up to 16,384 columns so this should work for your CSV file; just copy the content and Paste ...
Glorfindel's user avatar
  • 2,035
2 votes

Is there a software tool which allows to perform SQL on CSV files?

Flatbase is a free web app that allows you to query CSV, JSON, and other flat files using SQL. You can also graph results and share with colleagues.
mockaroodev's user avatar
2 votes
Accepted

Data validation library in Python and user defined rules

Pandas can do a lot of the work for you and is well worth looking at. Reading .csv files, (also .xlsx & others) Format conversions for date & value columns Filtering Are all available.
Steve Barnes's user avatar
  • 31.7k
2 votes

Data validation library in Python and user defined rules

Python's built in CSV support lets you import a CSV file and manipulate it. You can do this as rows to iterate over (and filter): import csv def filter_file(filename: str): with open(filename, ...
Rob Grant's user avatar
  • 121

Only top scored, non community-wiki answers of a minimum length are eligible