Learning level
80/100
Learning level
80/100
Product version
1.0.1
Guide status
Stable
Sections
3
Prepare sheets that behave well with filters, formulas, SQL and export.
What this guide covers
Quick facts
Keep one clear row of field names and one record per subsequent row when the sheet will be filtered or queried.
Avoid mixing unrelated concepts in one column. Numeric columns should primarily contain numeric values; dates should follow a consistent convention.
Use merged cells and decorative layouts outside the main data range when you expect to run SQL/filter operations on the table.