SheetCompareGlossary
Spreadsheet & Data Glossary
An A-Z reference of spreadsheet, data, and database terms — written for working spreadsheet users, not academics.
We're writing the full glossary entry by entry. Below is the planned A-Z index. Entries become clickable as they're published.
A
- Absolute reference
- Aggregation
- Array formula
B
- BOM
- Byte order mark
C
- Cell reference
- Character encoding
- Conditional formatting
- CSV
D
- Data cleansing
- Data deduplication
- Data normalization
- Data validation
- Delimiter
- Dynamic array
E
- ETL
- ELT
- Excel table
F
- Foreign key
- Freeze panes
G
- Group by
H
- Header row
I
- INDEX MATCH
- Inner join
J
- Join
K
- KPI
L
- Left join
M
- Macro
N
- Named range
- Null value
O
- OLAP
- Outer join
P
- Pivot table
- Power Pivot
- Power Query
- Primary key
Q
- Quoted field
R
- Reconciliation
- Relative reference
S
- Schema
- Sheet protection
- Slicer
- Sparkline
- Structured reference
- SUMIF
- SUMPRODUCT
T
- TSV
U
- UTF-8
V
- VBA
- VLOOKUP
X
- XLOOKUP
- XLSX