Skip to content
dotXLSOpen Workspace

Calculate Difference Between Two Columns

Calculate signed, absolute, or percentage difference between two numeric columns without changing row order.

Paste Data

Copy cells from Excel or Google Sheets and paste them here.

Import a spreadsheet file

Import CSV or XLSX data into the current dotXLS workspace. Files are processed in your browser.

Tools

Choose two numeric columns, select a difference calculation, preview each result, then add a new Difference column.

Column difference

Percentage difference uses |Second − First| ÷ average of the absolute values × 100. If both values are zero, the result is 0%.

Undo and Redo controls are available with the current grid.

Paste spreadsheet data to create your workspace.

Name	Department	Amount
Ahmed	Sales	1200
Maria	HR	950

Your data stays in this browser tab and is not sent to WordPress.

Export result

Download the current workspace data after editing or cleaning.