Top 23 CSV Open-Source Projects

• SheetJS js-xlsx

  5 25,264 5.9 JavaScript

  :green_book: SheetJS Community Edition -- Spreadsheet Data Toolkit

  

  Project mention: Processing uploaded spreadsheet files | reddit.com/r/webdev | 2021-04-20

• Papa Parse

  0 9,610 4.3 JavaScript

  Fast and powerful CSV (delimited text) parser that gracefully handles large files and malformed input

• Scout APM

  Sponsored scoutapm.com

  Scout APM - Leading-edge performance monitoring starting at $39/month. Scout APM uses tracing logic that ties bottlenecks to source code so you know the exact line of code causing performance issues and can get back to building a great product faster.

• q

  1 8,110 4.1 Python

  q - Run SQL directly on CSV or TSV files (by harelba)

  Project mention: What are the most useful VSCode extensions you know which could be reimplemented in Emacs? | reddit.com/r/emacs | 2021-03-31

  I would love if someone ported this to emacs, but perhaps in the meantime check out q (https://github.com/harelba/q), a command line tool that offers similar query abilities.

• ExcelJS

  2 7,410 7.7 JavaScript

  Excel Workbook Manager

  

  Project mention: Obtain binary of Dropbox file | reddit.com/r/webdev | 2021-02-26

  It looks like exceljs is able to word directly with buffers: https://github.com/exceljs/exceljs#reading-xlsx

• xsv

  6 7,026 0.0 Rust

  A fast CSV command line toolkit written in Rust.

  Project mention: If you want to run SQL queries on CSV files from the command line without installing/opening any DBMS software, use CSVKIT | reddit.com/r/SQL | 2021-04-14

  I've also had success using this tool to do sql like operations on csv files! https://github.com/BurntSushi/xsv

• structured-text-tools

  1 5,690 6.4

  A list of command line tools for manipulating structured text data

  Project mention: Consultare un databate XML, JSON, CVS o RDF | reddit.com/r/ItalyInformatica | 2021-03-31

  Per una vasta lista commentata vedi https://github.com/dbohdan/structured-text-tools

• datasette

  22 5,003 9.5 Python

  An open source multi-tool for exploring and publishing data

  Project mention: SQLite the only database you will ever need in most cases | news.ycombinator.com | 2021-04-15

• ServiceStack

  0 4,899 9.3 C#

  Thoughtfully architected, obscenely fast, thoroughly enjoyable web services for all

  

• csvkit

  2 4,548 4.4 Python

  A suite of utilities for converting to and working with CSV, the king of tabular file formats.

  

  Project mention: If you want to run SQL queries on CSV files from the command line without installing/opening any DBMS software, use CSVKIT | reddit.com/r/learnpython | 2021-04-14

• visidata

  4 3,739 9.7 Python

  A terminal spreadsheet multitool for discovering and arranging data

  Project mention: `uq is a simple, user-friendly alternative to `sort | uniq`. | reddit.com/r/commandline | 2021-04-15

  Run vd (VisiData on the file, press Shift+F, instant unique lines sorted by number of uses. Like sort | uniq -c | sort -n in one go.

• Spout

  1 3,469 2.7 PHP

  Read and write spreadsheet files (CSV, XLSX and ODS), in a fast and scalable way

  

  Project mention: How to test CSV in Drupal without losing your mind | reddit.com/r/drupal | 2021-03-18

  to add to this, this library is really good when wanting to parse CSV files https://github.com/box/spout

• pgloader

  2 3,353 4.1 Common Lisp

  Migrate to PostgreSQL in a single command!

  Project mention: How do I import data from a text file. BTW, I’m a noob. | reddit.com/r/PostgreSQL | 2021-04-22

• CSV

  0 2,738 7.6 PHP

  CSV data manipulation made easy in PHP

  

• miller

  6 2,710 9.9 C

  Miller is like awk, sed, cut, join, and sort for name-indexed data such as CSV, TSV, and tabular JSON

  Project mention: Consultare un databate XML, JSON, CVS o RDF | reddit.com/r/ItalyInformatica | 2021-03-31

• octosql

  1 2,402 6.7 Go

  OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL.

  Project mention: Minimally Invasive (and More Accurate) Analytics: GoAccess and Athena/SQL | news.ycombinator.com | 2021-02-16

  With OctoSQL[0], as I wanted to see how people are using it, I literally just set up an http endpoint which received a JSON request on each CLI invocation (you can see the data sent in the code, it's open source) and appended it to an on-disk JSON file.

  Then I used... OctoSQL to analyze it!

  Nit: The project may seem dead for a few months, but I'm just in midst of a rewrite (on a branch) which gets rid of wrong decisions and makes it easier to embed in existing applications.

  [0]:https://github.com/cube2222/octosql

• PlotJuggler

  1 2,188 8.9 C++

  The Time Series Visualization Tool that you deserve.

  Project mention: Ask HN: Software for Time Series Data Manipulation | news.ycombinator.com | 2021-02-17

  Based on your comment, I assume you mean a GUI program for interactive exploration and manipulation, rather than a library?

  This was posted on HN a few months ago and came to mind: https://github.com/facontidavide/PlotJuggler

  In a past job, we used the commercial app nCode Glyphworks for graphical / interactive signal processing from field tests with hundreds of sensors.

• django-import-export

  1 2,090 5.8 Python

  Django application and library for importing and exporting data with admin integration.

  

  Project mention: Useful Django 3rd party packages Part 2 | dev.to | 2021-02-22

  Doc: https://django-import-export.readthedocs.io/en/latest/ Source: https://github.com/django-import-export/django-import-export

• AdaptiveTableLayout

  0 1,763 0.0 Java

  Library that makes it possible to read, edit and write CSV files

  

• Serial-Studio

  2 1,629 9.6 C++

  Multi-purpose serial data visualization & processing program

  

  Project mention: Cereal Monitor Opensource Dropin Replacement For | reddit.com/r/arduino | 2021-02-06

  you folks might wanna check SerialStudio out https://github.com/Serial-Studio/Serial-Studio

• JobFunnel

  1 1,464 8.0 Python

  Scrape job websites into a single spreadsheet with no duplicates.

  Project mention: Late Night Random Discussion Thread - February 05, 2021 at 09:00PM | reddit.com/r/unitedstatesofindia | 2021-02-05

  JobFunnel ( repo for scrapping )

• ISO-3166-Countries-with-Regional-Codes

  1 1,393 1.9 Ruby

  ISO 3166-1 country lists merged with their UN Geoscheme regional codes in ready-to-use JSON, XML, CSV data sets

  Project mention: Looking for recommendations for an API to lookup 3-letter country ISO codes with approximate matching | reddit.com/r/learnprogramming | 2021-03-25

  You can download the country code data from https://github.com/lukes/ISO-3166-Countries-with-Regional-Codes

• Universal Data Tool

  0 1,388 9.4 JavaScript

  Collaborate & label any type of data, images, text, or documents, in an easy web interface or desktop app.

  

• Fast C++ CSV Parser

  3 1,249 1.7 C++

  fast-cpp-csv-parser

  Project mention: Csvlib file | reddit.com/r/cpp | 2021-03-10

  This one comes to mind: https://github.com/ben-strasser/fast-cpp-csv-parser

Index