List-format data

List-format data is organized in regular rows and columns: one row of unique headers, one observation per row, one type of information per column, with no empty row, total row or merged cell. This format is required to sort, filter, and create a structured table or a PivotTable.

Example

Columns Date, Région, Produit, Montant, with one sale per row.

Related concepts

The whole glossary