Hot answers tagged

33 votes
Accepted

Fastest free Python library to read a CSV file with 1~3 columns of numbers

So I eventually wrote a small benchmark using the libraries Steve Barnes had pointed at. I had found the same when looking for it as I was writing the question so I guess that's the main ones. Some ...
user avatar
9 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. ...
user avatar
  • 1,977
9 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
user avatar
8 votes

Fastest free Python library to read a CSV file with 1~3 columns of numbers

I would like to contribute another library here, that I stumbled over looking for similar question. I tested it with Franck Dernoncourts benchmark code and it beats Pythons standard csv and Pandas by ...
user avatar
6 votes

Program for opening .csv files with custom delimiter

For Windows, if you have Microsoft Office, you can use Excel. You have the ability to set a custom delimiter when importing text files:
user avatar
6 votes
Accepted

Program for opening .csv files with custom delimiter

You can use OpenOffice (or LibreOffice, which is pretty much the same): free and open source Windows and Linux specify the delimiter when importing the CSV:
user avatar
5 votes

Program for opening .csv files with custom delimiter

You can use Google Drive (free, web-based). Create a new spreadsheet, go to File > import, then specify the delimiter:
user avatar
5 votes

Fastest free Python library to read a CSV file with 1~3 columns of numbers

You have a wide choice depending on data size and complexity and what you are going to do with the resulting data: The csv library that comes with Python by default. NumPy - numpy.from_file function -...
user avatar
5 votes

Simple text editor for spreadsheet-style data entry

I would suggest downloading the wxPython, (it is quite likely to be already installed on both Mac and Linux), and the wxPython demo and taking a look at the SimpleGrid.py in there, adding file load ...
user avatar
5 votes
Accepted

Viewer for huge CSV files which don't fit in memory

You could try reCsvEditor, a CSV file viewer/editor which supports a wide variety of field delimiters, very large files and Unicode Files. Files are displayed in a table format. It seems to match all ...
user avatar
  • 1,770
5 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 ...
user avatar
  • 101
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 ...
user avatar
4 votes

Lightweight contact manager for Linux with import & export feature

Osmo has been around for years and is pretty good - the GUI's not so flashy, but it's pretty lightweight with minimal dependencies. It has basic import/export functionality, as well as everything you'...
user avatar
  • 1,606
4 votes

Get random records from CSV files

This is really a job for a scripting language. The task you describe is so specific that you're very unlikely to find a tool that does exactly that. On the other hand, it can be written in a few ...
user avatar
4 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 ...
user avatar
4 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 ...
user avatar
  • 141
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 ...
user avatar
  • 141
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 ...
user avatar
4 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 ...
user avatar
  • 291
3 votes

Offline CSV validator

Take a look at csvkit, a python library for working with CSV data with accompanying command line scripts. It's designed to be smart about character encoding (and can be used to convert or normalize ...
user avatar
3 votes

Offline CSV validator

It's somewhat unclear how far your requirements stretch, but in general most scripting languages have a CSV parser of their own, and can be used from the command line. If there's an error in your CSV ...
user avatar
3 votes

Speadsheet software that can handle thousands of columns

You could always look at Pyspread which reports that while row & col sizes depend on memory size, etc. according to the FAQ: For standard size on GTK platforms, 80 000 000 rows can be displayed. - ...
user avatar
3 votes

Bulk search and replace in text file with results from CSV or spreadsheet?

I'm not entirely sure if I understand your intention correctly, but at least on Linux that should be easily done using core command line utilities like sed or awk. sed is a stream editor, which ...
user avatar
  • 18.4k
3 votes

Tool for converting Excel files to CSV

I would suggest using python with the xlrd library, the conversion could be as simple as: from xlrd import open_workbook import os import sys def xl2csv(filename): """ Convert an excel file to ...
user avatar
3 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 ...
user avatar
  • 282
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 ...
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), ...
user avatar
  • 1,964
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:/...
user avatar
3 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 ...
user avatar
  • 2,061
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/...
user avatar

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