Skip to content
dotXLSOpen Workspace

Excel Lookup & Join

Match records between two Excel worksheets and bring selected columns across without writing VLOOKUP or XLOOKUP formulas.

Import an XLSX workbook with at least two worksheets, choose matching key columns and return columns, preview the join, then append the matched values as one reversible step.

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

Import an XLSX workbook with at least two worksheets. The current worksheet is the source table; choose another worksheet as the lookup table.

Excel Lookup & Join
Columns to bring back

Import a multi-sheet XLSX workbook to choose return columns.

The first matching lookup row is used when a lookup key appears more than once. Duplicate lookup keys are reported before you apply changes. Source rows are never deleted.

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.