GS-Calc is a modern spreadsheet with unique capabilities for handling large datasets. You can edit large CSV files with millions of rows, and handle XLSX files that are automatically split and merged. With GS-Calc you can build complex data models containing, for example, millions of binary look-up formulas in a file that is opened, saved and updated almost instantly.
- 32 million rows x 16,384 columns. Loaded text/CSV files that exceed the 32M/16K limits are automatically split into multiple sheets and saved together as a zipped collection of text files.
- Unlimited workbook file size and best possible loading/saving speed. A workbook file with 500 million random numbers can be opened in 30 seconds on an old, slow PC with 16GB RAM.
- Efficient data compression allowing you to save, for example, 20 million formulas as a 5KB file (see how >>).
- Organizing worksheets in a tree form and creating 3D array cell references for worksheets in a given subfolder.
- Over 450 built-in functions which can automatically detect array arguments and return dynamic 2D array results and images.
- Up to 64 processor cores that can be used to perform calculations with no restrictions for all types of formulas.
- During recalculation, you can reference any number of closed workbooks of any size, using any formulas.
- You can extend the above set of functions in any way you want by calling your own functions from Python modules in GS-Calc formulas as User Defined Functions (UDF). Python functions can return to GS-Calc any type of data, including single values, matrices, dynamic images or even entire CSV files.
- If you need the best performance, instead of Python, you can also add your functions written in C++/C in DLL libraries. Such functions can even replace the built-in ones, ensuring the same performance, dynamic 2D array results and multithreaded updates.
- VLOOKUP, HLOOKUP, MATCH, UNIQUE, FILTER functions using regex and fast binary searching to ensure the best performance for worksheets with millions of rows. For example, one million VLOOKUP() functions in a table with a few million rows can be updated almost instantly, even on a slow, old PC with 8GB RAM.
- The FILTER() function to quickly filter millions of rows (and/or to perform multi-key sorting and searches for duplicates).
- Built-in solver functions (formulas) with no limits for the number of variables.
- Linear programming, including integer, binary and mixed programming, and quadratic programming.
- Various optimization functions. Equation sets. Time series analysis.
- Built-in fast Monte Carlo simulations with detailed reports for models of any complexity.
- Fully configurable cross-highlighting and dark modes to ensure the best screen readability and to fit personal preferences.
- Each single worksheet can be separately split into up to 100 panes to display various regions of that worksheet or other worksheets, and you can password-protect such view layouts.
- Mass modifying/adding/removing parameters/arguments used by functions in large workbooks without the risk of making mistakes in long formulas, no matter how complex they are. (see how >>)
- Unlimited number of hyperlinks and unlimited number of conditional formatting functions in sheets.
- Fast multicolumn drop-down lists with up to 32 million items.
- Fast pivot tables with up to 32 million rows, built-in reports, full regex filtering, statistics.
- 25 pivot table data functions (vs. 11 in Excel).
- Pivot tables can be used as formulas or as separate documents in dedicated view panes.
- Charts easily handling millions of data points with custom (grid-)lines and iso-lines.
- Up to 16 independently scaled axes on each chart.
- Unlimited number of fully parametrized (Google Sheets compatible) sparkline() functions in sheets.
- Unlimited number of in-cell charts as formatting styles.
- Loading/editing/saving CSV, text, XLS, XLSX, dBase, Clipper, FoxPro, MySQL, SQLite files with up to 32 million rows (and up to 1 million columns for text files).
- All opened files are edited in-place: if you click "Save" they are saved back in their original format, with their original structure and parameters.
- Compare files in any format, workbooks, sheets, ranges and generate reports with (hyperlinks to) differences.
- Verify data integrity with SHA256 checksums when switching between file formats. You can calculate control sums separately for several data categories.