← Excel Data Cleanup

Final project · Spreadsheet

Handoff a clean order file

My saved work →

Your work

Active 0:00 · Paused 0s

Edit the grid or the CSV. Formulas use grid row numbers, including the header row.

Supported formulas

SUM, SUMIF, COUNTIF, IF, TRIM and exact LOOKUP. Arithmetic, single-column ranges and cell references are supported. Example: =SUM(B2:B3). Cycles are rejected. Empty numeric values stay empty unless you supply a declared default.

Show the reference answer
order_id,date,region,name,amount
1,2026-09-01,East,Avery,120
2,2026-09-02,Unknown,Morgan,0

Check the key, explicit defaults and dates independently.