gridcraft

GridCraft guides: learn, test, and troubleshoot

Twelve practical guides to GridCraft: get started, compare Excel workflows, and work through tested formula, CSV, pivot table, and performance examples.

All guides

Formula tests7 min read

VLOOKUP and XLOOKUP in GridCraft: Tested Parameters and Errors

Reproduce v0.19.1 lookup tests: exact and approximate matches, duplicate keys, missing values, reverse search, and the errors returned by invalid arguments.

Pivot table tutorial7 min read

GridCraft Pivot Tables: From Raw Rows to a Summary Chart

Build a small revenue PivotTable, verify its totals, create a linked column chart, and understand what needs checking when the source changes.

CSV troubleshooting7 min read

GridCraft CSV Import and Export: Encoding, Delimiters, and Dates

Test UTF-8, semicolon and tab delimiters, quoted commas, leading zeros, and ambiguous dates before moving a CSV into a production workbook.

Formula troubleshooting7 min read

GridCraft Formulas Not Recalculating: A Practical Checklist

Separate manual calculation, text cells, wrong references, circular references, and cross-sheet dependencies with small v0.19.1 examples.

Performance test7 min read

GridCraft with 12,000 Rows: Practical Performance Notes

Qualitative observations from a v0.19.1 browser workbook with 12,000 records and a simple formula column, plus a repeatable way to test your own files.

Excel compatibility12 min read

GridCraft and Excel: Open, Edit and Save XLSX Files

Use Excel files in GridCraft with a practical XLSX workflow. Check formulas, charts, macros and format limits before saving a workbook back to Excel.

Product comparison12 min read

GridCraft vs Excel: Which Spreadsheet Fits Your Work?

Compare GridCraft vs Excel for cost, XLSX files, formulas, VBA and collaboration. Use a practical workbook test to decide where each tool fits.

Meet GridCraft12 min read

What Is GridCraft? A Guide to the Open-Source Spreadsheet

Learn what GridCraft is, who builds it, what its spreadsheet tools do, and how to choose between the online editor and desktop downloads.

Online editor12 min read

GridCraft Online: Open a Spreadsheet and Save Your Work

Use GridCraft online without installing the desktop app. Launch a sample, open an XLSX file, edit cells, download your workbook and troubleshoot startup.

Getting started4 min read

GridCraft XLSX guide: open, edit and save a workbook

Learn how to open an Excel XLSX file in GridCraft online, make a small edit, check a formula and download your updated workbook.

Formulas5 min read

GridCraft formulas: a practical SUM and IF tutorial

Practice SUM and IF in the GridCraft ArtCraft spreadsheet editor. Follow a simple example, change the inputs and verify the calculated results.

Analysis6 min read

GridCraft charts and PivotTables: a beginner’s guide

Prepare a clean source table in GridCraft, compare values with a chart and explore grouped summaries with a PivotTable in the ArtCraft desktop app.