Show HN: A modern spreadsheet with Python integration

https://news.ycombinator.com/rss Hits: 11
Summary

GS-Calc is a modern spreadsheet with unique capabilities for processing big data sets. You can edit large CSV files with millions of rows, XLSX files that are automatically split and merged, build complex data models e.g. with millions of look-up formulas that are opened/updated almost instantly and clean, transform, publish multi-gigabyte data sets. 32 million rows x 16,384 columns. The number of worksheets and subfolders is unlimited. No limit for the file size. Large text, CSV files exceeding the 32M/16K limits are automatically split into multiple sheets and saved together in one zip. Organizing worksheets in a tree form and creating 3D array cell references for worksheets in a given subfolder (by specifying only the folder path in the reference). Optimized to process large files. GS-Calc easily outperforms other existing spreadsheet solutions and redefines what the term "large data set" means for desktop software. → Performance examples. GS-Calc vs other spreadsheets (for consistency, using the "industry standard" 1M row limit): Loading text files is several times faster in GS-Calc. Copying/pasting/filling large data ranges should be on average several times faster (and more, especially for blocks containing formulas) in GS-Calc. Performing VLOOKUP and MATCH for newly pasted/entered data in large data sets can be executed at least several times faster in GS-Calc. GS-Calc workbooks saved in its binary file format are a few times (and up for specific data sets) times smaller and are accordingly faster to load/save. Pivot table data functions in GS-Calc: 25 functions (vs 11 functions in Excel), chi2 tests, 32 million rows, full regex filtering. Fast pivot tables with up to 32 million rows, built-in reports, many functions and filtering options. Monte Carlo Simulations to easily estimate risk in business, costs, future pensions or simply to reverse-calculate formulas etc. Mass modifying/adding/removing parameters/arguments used by functions in large workbooks witho...

First seen: 2025-04-25 22:58

Last seen: 2025-04-26 11:05