GS-Calc

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.

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 on the number of variables.

Built-in fast Monte Carlo simulations with detailed reports for models of any complexity.

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.

Charts easily handling millions of data points with custom gridlines and iso-lines. 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 hyperlinked differences.