Top 23 CSV Open-Source Projects
:green_book: SheetJS Community Edition -- Spreadsheet Data ToolkitProject mention: Processing uploaded spreadsheet files | reddit.com/r/webdev | 2021-04-20
Fast and powerful CSV (delimited text) parser that gracefully handles large files and malformed input
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 - 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.
Excel Workbook ManagerProject 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
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
A list of command line tools for manipulating structured text dataProject 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
An open source multi-tool for exploring and publishing dataProject mention: SQLite the only database you will ever need in most cases | news.ycombinator.com | 2021-04-15
Thoughtfully architected, obscenely fast, thoroughly enjoyable web services for all
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
A terminal spreadsheet multitool for discovering and arranging dataProject 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.
Read and write spreadsheet files (CSV, XLSX and ODS), in a fast and scalable wayProject 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
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 data manipulation made easy in PHP
Miller is like awk, sed, cut, join, and sort for name-indexed data such as CSV, TSV, and tabular JSONProject mention: Consultare un databate XML, JSON, CVS o RDF | reddit.com/r/ItalyInformatica | 2021-03-31
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, 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.
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 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
Library that makes it possible to read, edit and write CSV files
Multi-purpose serial data visualization & processing programProject 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
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-1 country lists merged with their UN Geoscheme regional codes in ready-to-use JSON, XML, CSV data setsProject 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
Collaborate & label any type of data, images, text, or documents, in an easy web interface or desktop app.
fast-cpp-csv-parserProject mention: Csvlib file | reddit.com/r/cpp | 2021-03-10
This one comes to mind: https://github.com/ben-strasser/fast-cpp-csv-parser
What are some of the best open-source CSV projects? This list will help you:
|22||Universal Data Tool||1,388|
|23||Fast C++ CSV Parser||1,249|