Data & CSV

CSV lagged change

Compare each numeric value with an earlier row in the current order.

CSV lagged change
Esc to restore

Your inputs

UTF-8 CSV/TSV stays on this device. First row contains unique headings; maximum 25 MB, 50,000 rows and 200 columns. Fully empty rows are ignored.

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.

Appends the difference from the row lag positions earlier and 100×difference/absolute prior value. Initial rows, blank current/prior cells and percentage changes from zero remain blank where undefined. Preserves row order and rejects other non-numeric values; no dates or groups are inferred.

See a worked example

Worked example

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

Your CSV data
ID,Name,Department,Amount,Date
001,Ada,Design,120,2026-01-05
002,Sam,Writing,80,2026-01-06
003,Jo,Design,150,2026-01-07
004,Lee,Writing,,2026-01-08
005,Alex,Design,60,2026-01-09
Column separator
Comma
Numeric column
Amount
Rows back
1

Example result

Example result
IDNameDepartmentAmountDateAmount.changeAmount.percentChange
001AdaDesign1202026-01-05
002SamWriting802026-01-06-40-33.3333333333
003JoDesign1502026-01-077087.5
004LeeWriting2026-01-08
005AlexDesign602026-01-09

Keep going.

CSV dataset diffCSV rule validatorCSV calculated columnCSV rank and percentile