Excel to SQL guide

Excel to SQL: the translation guide for analysts making the switch

If you know Excel, you already understand the concepts behind SQL. Here is the direct translation between the Excel functions you know and the SQL syntax that does the same thing — faster, on bigger data.

Why Excel users learn SQL faster than they expect

Excel and SQL both work with tabular data — rows and columns. The operations are the same: filter rows, sort, aggregate, join tables, and calculate new columns. The syntax is different, but the mental model is nearly identical. Excel users learn SQL faster than total beginners because the underlying logic is already familiar.

Every Excel operation you already know has a direct SQL equivalent. This guide maps them one-to-one so you can read and write basic SQL immediately — without starting from scratch.

The direct translations: Excel → SQL

For each operation below, the Excel approach is on the left, the SQL equivalent is on the right.

Filtering rows

Excel

=IF(region="North", revenue, "")

SQL

SELECT * FROM sales
WHERE region = 'North'

Sorting

Excel

Data → Sort → Sort by Revenue, Largest to Smallest

SQL

SELECT * FROM sales
ORDER BY revenue DESC

SUM of a column

Excel

=SUM(A:A)

SQL

SELECT SUM(amount)
FROM orders

SUMIF / COUNTIF (conditional aggregation)

Excel

=SUMIF(B:B, "North", C:C)

SQL

SELECT SUM(revenue)
FROM sales
WHERE region = 'North'

VLOOKUP (joining two tables)

Excel

=VLOOKUP(A2, customers!A:B, 2, FALSE)

SQL

SELECT o.*, c.name
FROM orders o
JOIN customers c ON o.customer_id = c.id

Pivot Table (GROUP BY)

Excel

Insert → PivotTable → Rows: Region, Values: SUM of Revenue

SQL

SELECT region, SUM(revenue)
FROM sales
GROUP BY region

IF statement

Excel

=IF(B2>1000, "High", "Low")

SQL

SELECT
  CASE WHEN revenue > 1000 THEN 'High'
       ELSE 'Low'
  END AS tier
FROM sales

Where SQL wins over Excel

SQL is not just a different syntax — it solves problems that Excel cannot handle at scale.

Scale

Excel struggles above ~500K rows. SQL handles millions with ease.

Reproducibility

SQL queries are code — they can be version-controlled, shared, and re-run exactly.

Automation

SQL queries can be scheduled to run on a timer. Excel requires manual updates.

Multi-table

SQL handles many tables natively with JOIN. Excel VLOOKUPs become unmanageable at scale.

Where Excel still wins

SQL is not a replacement for everything. The best analysts use both — SQL to extract and aggregate, Excel to polish for presentation.

Quick ad-hoc analysis on small datasets.
Charts and formatting that need fine-grained control.
Sharing with non-technical stakeholders.

The best analysts use both tools. SQL to extract and aggregate at scale; Excel to format, chart, and share with stakeholders who do not have database access.

Next step

Learn SQL from scratch

The SQL guide walks through every concept in order — from your first SELECT to joins, aggregation, and window functions — with real examples at each step.

Learn SQL from scratch