Top 12 JavaScript CSV Projects
-
Project mention: Tips for Making a Popular Open-Source Project in 2021 [Ultimate Guide] | news.ycombinator.com | 2021-11-12
Maybe a story from a maintainer would help. To contextualize, the main SheetJS open source project https://github.com/SheetJS/sheetjs has over 28K stars.
tl;dr: the project involves "crowdsourced research" which benefits from popularity.
The main social goal with the project is data preservation and integrity. Large-scale economic and political decisions are made from data and analyses in spreadsheets. For example, last year in the UK, COVID cases were underreported thanks to Excel minutiae https://www.bbc.com/news/technology-54423988
Due to various corporate stratagems, the older data representations were intentionally obfuscated. To support Excel, many developers poked around at Excel files and guessed at the structures.
In this environment, the biggest challenge is finding worksheets with random corner cases. These types of files are not easy to create and fuzzing has limited effectiveness. This is where open source and popularity come into play. The open source and JS nature of the project helps reduce testing friction (https://oss.sheetjs.com/ runs in the web browser, no need to install anything) and encourage bug reports with test cases.
There will always be "entitled users" and "low quality bug reports" but that comes with the territory. There are also meaningful issues and code contributions. Efforts at trying to prevent the low quality contributions also discourage higher quality contributions.
-
Papa Parse
Fast and powerful CSV (delimited text) parser that gracefully handles large files and malformed input
Project mention: How can I read a csv file properly with TypeScript, that has columns with /n and /r/n contained in quotes (“… /r/n … /n … ”) | reddit.com/r/typescript | 2021-07-09 -
-
Project mention: I have an excel template that generates data in other sheets based on what is loaded into the first sheet, how can I use this template and have my nodejs process write the data to the first sheet in the specific columns? | reddit.com/r/node | 2021-11-17
I personally have used https://github.com/exceljs/exceljs in the past.
-
Universal Data Tool
Collaborate & label any type of data, images, text, or documents, in an easy web interface or desktop app.
-
Project mention: A stab at pivot/BI visualization in SQL-based offline-first PWA | news.ycombinator.com | 2021-08-05
-
pxi
🧚 pxi (pixie) is a small, fast, and magical command-line data processor similar to jq, mlr, and awk.
Project mention: New command-line parser with 35+ opt-in features developed for 5 months needs your feedback | reddit.com/r/node | 2021-06-05I have been working on a command-line parser for one of my open source projects (pxi) for about 5 months now. Today I have reached a milestone and wanted to collect feedback before I move on:
-
tresor-import
Extract transactions from PDF statements of brokers/banks or "Portfolio Performance" CSV exports. Compatible with Tresor One activities
Project mention: Is there an app that tracks many types of investments, including custom ones? | reddit.com/r/eupersonalfinance | 2021-05-20There is Tresor One, but afaik it's only available in German, currently.
-
Scout APM
Scout APM: A developer's best friend. Try free for 14-days. 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.
-
Project mention: [task] Node.js Developer, Gatsby SSG, Write a questionnaire tool that employs gitrows to use git like a database | reddit.com/r/slavelabour | 2021-04-01
I believe I need a node.js engineer, to make https://github.com/gitrows/gitrows work inside of the Gatsby SSG and then use it to produce a survey system.
-
YNABGoingDutch
A converter between the CSV format of Dutch banks and the YNAB format. Or sync your bank statement directly with YNAB!
I am the creator of [YNABGoingDutch](https://github.com/DanielsWrath/YNABGoingDutch), a tool which automatically creates ready-to-go CSV files from your horrendous Dutch CSV files!
-
If you need additional features from lil-csv then feel free open an issue here: https://github.com/flash-oss/lil-csv/issues
-
tron-transfers-downloader
Node.js script to download all TRX and TRC10 transfers to/from an account to a CSV file, using TronGrid APIs
-
Project mention: Marge and remove dublikats from CSV files (e.g. Keepass) | news.ycombinator.com | 2021-05-30
JavaScript CSV related posts
- The unexpected return of JavaScript for Automation
- Dutch bank statement synchronization with YNAB!
- A stab at pivot/BI visualization in SQL-based offline-first PWA
- lil-csv, a 1k JS module to parse and generate CSV files
- How can I read a csv file properly with TypeScript, that has columns with /n and /r/n contained in quotes (“… /r/n … /n … ”)
- Sqliteviz is a single-page offline-first web app for fully client-side visualisation of SQLite databases or CSV files
- Do you know of any website that has a bunch of files for CSV parser edge case testing?
Index
What are some of the best open-source CSV projects in JavaScript? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | SheetJS js-xlsx | 28,267 |
| 2 | Papa Parse | 10,171 |
| 3 | ExcelJS | 8,558 |
| 4 | Universal Data Tool | 1,544 |
| 5 | sqliteviz | 1,139 |
| 6 | pxi | 257 |
| 7 | tresor-import | 161 |
| 8 | gitrows | 126 |
| 9 | YNABGoingDutch | 35 |
| 10 | lil-csv | 9 |
| 11 | tron-transfers-downloader | 4 |
| 12 | marge-csv-keepass | 1 |
Are you hiring? Post a new remote job listing for free.
