Data Analysis & Spreadsheet Tools
Clean and inspect CSV summaries, format complex SQL queries, and generate nested Excel formulas.
Available Calculators
Excel Formula Generator
Build Excel and Google Sheets formulas from plain choices. Get the formula, an explanation and fixes for common errors.
SQL Formatter
Paste messy SQL and get readable, consistent code. Runs in your browser, nothing is uploaded. Choose case and indent.
CSV Quick Stats
Get mean, median, mode, standard deviation and quartiles for every column in a CSV. Your file never leaves your browser.
Topic Guides & Frameworks
XLOOKUP vs VLOOKUP vs INDEX-MATCH: Performance, Syntax & Edge Cases
Complete comparison of Excel lookup functions. Learn syntax differences, multi-criteria searches, wildcard matching, and backward lookup methods.
Mean vs Median: How Outliers Distort Data and Which to Report
Learn when to use the mean versus the median in business and data analytics. Real salary, house price, and revenue examples with skewness explained.