Data & CSV

Grouped CSV fill down

Carry previous non-empty values forward separately within each group.

Grouped CSV fill down
Esc to restore

Your inputs

Up to 25 MB per file, 50,000 data rows, 200 columns and 2 million data cells. Fully blank rows and columns are ignored before row, column and cell limits are checked. Individual tools may have smaller result or chart limits.

Results update as you type. Larger files run when you press Update result.

Processed on your device

Your result

LOCAL & PRIVATE

Your result will appear here.

Your inputs stay in this browser. Nothing is uploaded or saved.

A clear answer. Here’s how.

Tracks the last non-missing cell for each exact grouping value in input order. Fills only missing target cells and leaves leading missing cells unchanged. Groups may be interleaved. Does not sort, look ahead, interpolate numeric values or carry values across different groups.

See a worked example

Worked example

A fixed demonstration, separate from the values you enter above.

Your CSV
ID,Name,Team,Amount,Date
001,Ada,Design,120,2026-01-05
002,Sam,Writing,80,2026-01-06
003,Jo,Design,150,2026-01-07
Column separator
Comma
Column to fill
Name
Group column
Team
Missing rule
Exactly empty

Example result

Example result
IDNameTeamAmountDate
001AdaDesign1202026-01-05
002SamWriting802026-01-06
003JoDesign1502026-01-07

Rows remain in input order; each group has its own last non-blank value. Leading blanks remain blank.

Keep going.

CSV dataset diffCSV rule validatorCSV calculated columnCSV rank and percentile