GS-Calc

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 structure

• Optimized to process large files. Can load tens of GB of data in minutes.
• Fast pivot tables with up to 32 million rows, built-in reports, many statistical functions, chi2 tests, and filtering options.
• Monte Carlo Simulations to easily estimate risk in business, costs, future pensions or simply to reverse-calculate formulas etc.
• VLOOKUP, HLOOKUP, MATCH, UNIQUE, FILTER functions using fast binary searching to ensure the best performance for worksheets with millions of rows and millions of look-up functions.
• Use of regular expressions in the look-up and text functions and in the Find and Replace function.
• The FILTER() function to quickly filter millions of rows (and/or to perform multi-key sorting and searches for duplicates).
• Charts easily handling millions of data points with custom vertical and horizontal (grid-)lines.
• Fully configurable cross-highlighting to ensure the best screen readability.
• No limitations for the number of hyperlinks and its usage. Workbook hyperlinks created instantly by the Copy/Paste commands. No limitations for conditional formatting - you can instantly create and efficiently use millions of rules. No limitations for using cell references to external closed workbooks in all functions including the INDIRECT() function and functions written and added by users.
• Users can specify from 1 to 64 processor cores to be used by GS-Calc for calculations.
• Around 450 built-in functions. Users can add their own DLL libraries with new functions or functions replacing the default ones, with the same performance, dynamic array and multi-core calculations.
• Two optional native file formats: Open Document *.ods spreadsheet format and fast and compact binary format which - thanks to various data patterns analysis - enables you to generate even tens of times smaller files than those saved by other popular spreadsheets.
• 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 existing files are edited in-place, without changing their format or parameters/structure.
• Specialized numerical functions: matrix decompositions; linear equation sets with improving iterations; least squares (weighted, constrained), regression with orthogonal polynomials; time series analysis; minimization; linear programming, integer programming and quadratic programming.
• GS-Calc can be installed on any portable storage device and used without performing any registry modifications. Can be installed and used off-line.