LahoreWin
Spreadsheets and data

Data transformation guide

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

Choose a specific task

Data transformation covers join two tables by key, find unmatched table rows, group and aggregate table rows, pivot table data. 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, Join column, Right CSV, Key column, Second CSV.

Join two tables by key

Join two tables by key 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 join two tables by key

Find unmatched table rows

Find unmatched table rows and export the findings without changing the source table.

Check the result before using it.

Open find unmatched table rows

Sample table rows

Sample 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 sample table rows

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.