LahoreWin
Spreadsheets and data

Data cleaning guide

Choose the task, check the input and keep a copy of your original.

Choose a specific task

Data cleaning covers remove duplicate table rows, trim table cell whitespace, standardise missing values, normalise phone number formats. These tasks can need different inputs and output checks. A Coming soon status means a listed task is unavailable.

Prepare your input

Keep an untouched source and decide which result you need. Check the selected tool’s input format and limits before processing. The included controls in this collection include CSV data, Missing-value markers, Replacement, Email column, Column.

Remove duplicate table rows

Remove duplicate table rows from pasted CSV. Quoted commas and line breaks are parsed as CSV cells.

Maximum 50,000 rows and 500,000 text characters. Downloaded cells beginning with spreadsheet formulas are not automatically executed here; review before opening in spreadsheet software.

Open remove duplicate table rows

Trim table cell whitespace

Trim table cell whitespace from pasted CSV. Quoted commas and line breaks are parsed as CSV cells.

Maximum 50,000 rows and 500,000 text characters. Downloaded cells beginning with spreadsheet formulas are not automatically executed here; review before opening in spreadsheet software.

Open trim table cell whitespace

Standardise missing values

Standardise missing values from pasted CSV. Quoted commas and line breaks are parsed as CSV cells.

Maximum 50,000 rows and 500,000 text characters. Downloaded cells beginning with spreadsheet formulas are not automatically executed here; review before opening in spreadsheet software.

Open standardise missing values

Review and save

Compare the result with your original. For document tasks, inspect page order and content; for images or media, inspect dimensions and playback; for structured data, verify sample records and counts. Keep the source until the output has been accepted for its intended use.

Related tasks

Choose a tool to open its page.