:green_book: SheetJS Community Edition -- Spreadsheet Data ToolkitProject 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.
Fast and powerful CSV (delimited text) parser that gracefully handles large files and malformed inputProject 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
Run Linux Software Faster and Safer than Linux with Unikernels.
Excel Workbook ManagerProject 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.
Collaborate & label any type of data, images, text, or documents, in an easy web interface or desktop app.
Instant offline SQL-powered data visualisation in your browserProject mention: A stab at pivot/BI visualization in SQL-based offline-first PWA | news.ycombinator.com | 2021-08-05
🧚 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-05
I 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:
Extract transactions from PDF statements of brokers/banks or "Portfolio Performance" CSV exports. Compatible with Tresor One activitiesProject mention: Is there an app that tracks many types of investments, including custom ones? | reddit.com/r/eupersonalfinance | 2021-05-20
There is Tresor One, but afaik it's only available in German, currently.
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.
A lightweight module for using git as a databaseProject 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.
A converter between the CSV format of Dutch banks and the YNAB format. Or sync your bank statement directly with YNAB!Project mention: Dutch bank statement synchronization with YNAB! | reddit.com/r/ynab | 2021-10-04
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!
Mini 1k module for CSV,TSV,PSV file manipulationsProject mention: lil-csv, a 1k JS module to parse and generate CSV files | dev.to | 2021-07-10
If you need additional features from lil-csv then feel free open an issue here: https://github.com/flash-oss/lil-csv/issues
Node.js script to download all TRX and TRC10 transfers to/from an account to a CSV file, using TronGrid APIsProject mention: Koinly - Tronlink Pro | reddit.com/r/Tronix | 2021-04-26
Merge multiple databases and remove duplikats from CSV files (e.g. Keepass)Project mention: Marge and remove dublikats from CSV files (e.g. Keepass) | news.ycombinator.com | 2021-05-30
5 projects | news.ycombinator.com | 26 Nov 2021
Dutch bank statement synchronization with YNAB!
1 project | reddit.com/r/ynab | 4 Oct 2021
A stab at pivot/BI visualization in SQL-based offline-first PWA
1 project | news.ycombinator.com | 5 Aug 2021
lil-csv, a 1k JS module to parse and generate CSV files
1 project | dev.to | 10 Jul 2021
How can I read a csv file properly with TypeScript, that has columns with /n and /r/n contained in quotes (“… /r/n … /n … ”)
1 project | reddit.com/r/typescript | 9 Jul 2021
Sqliteviz is a single-page offline-first web app for fully client-side visualisation of SQLite databases or CSV files
2 projects | reddit.com/r/learnSQL | 26 Jun 2021
Do you know of any website that has a bunch of files for CSV parser edge case testing?
3 projects | reddit.com/r/vba | 23 Jun 2021
|4||Universal Data Tool||1,544|
Are you hiring? Post a new remote job listing for free.