#####   ######  #####    ###    #   #  ###  #   #  ######
##  ##  ##      ##  ##  ## ##   #   #   #   #   #  ##
#####   ####    #####   #   #   #   #   #   #   #  ####
##  #   ##      ##      ## ##    # #    #    # #   ##
##   #  ######  ##       ###      #    ###    #    ######

$ curl repovive.com/roadmaps/frontend-system-design-interview-prep/spreadsheet-design/data-model

░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░████████████████████████████████████████████████████████████████████████████████████████████████

#####   ######  #####    ###    #   #  ###  #   #  ######
##  ##  ##      ##  ##  ## ##   #   #   #   #   #  ##
#####   ####    #####   #   #   #   #   #   #   #  ####
##  #   ##      ##      ## ##    # #    #    # #   ##
##   #  ######  ##       ###      #    ###    #    ######

$ curl repovive.com/roadmaps/frontend-system-design-interview-prep/spreadsheet-design/data-model

Repovive

Data Model - Spreadsheet Design | Frontend System Design Interview Prep | Repovive

Repovive.

Frontend System Design Interview Prep17 sections · 206 units12h total

Open in Course

Data Model

Storing cell data

Choose a sparse data structure for efficiency.

Sparse storage:

{
  cells: {
    'A1': { value: 'Hello', formula: null },
    'B2': { value: 15, formula: '=A1+10' }
  },
  columns: { A: { width: 100 }, B: { width: 120 } },
  rows: { 1: { height: 24 } }
}

Why sparse: A $1$ M cell grid stored densely uses massive memory. Sparse storage only stores non-empty cells.

Cell addressing: Use "A1" notation or row/column indices. Convert between them as needed.