Show HN: A modern spreadsheet with Python integration
a year ago
- #big-data
- #spreadsheet
- #performance
- GS-Calc is a modern spreadsheet optimized for processing large data sets, handling up to 32 million rows and 16,384 columns.
- It supports editing large CSV and XLSX files, automatically splitting and merging them as needed.
- GS-Calc outperforms other spreadsheets in performance, with faster loading, copying, pasting, and formula execution.
- Features include pivot tables with 25 functions, Monte Carlo simulations, and support for up to 32 million rows.
- Advanced functions like VLOOKUP, HLOOKUP, MATCH, UNIQUE, and FILTER use fast binary searching for optimal performance.
- Supports regular expressions in look-up and text functions, and offers multi-core processing (1 to 64 cores).
- Python integration allows creating custom functions that return numbers, matrices, strings, CSV data, and images.
- Can load, edit, and save files in various formats (CSV, XLS, XLSX, dBase, MySQL, SQLite) without altering their structure.
- Includes specialized numerical functions for matrix decompositions, linear programming, and time series analysis.
- GS-Calc can be installed on portable storage, works offline, and doesn’t require internet or registry modifications.