Home / Office & Sheets / Spreadsheet Lookup & Join
Spreadsheet Lookup & Join
Bring columns from one sheet into another by a shared key, like VLOOKUP, or find rows missing from the other file.
Free, no uploads, no sign-up. Runs 100% in your browser.
How Spreadsheet Lookup & Join works
Files are opened in your browser with SheetJS and JSZip. Nothing is uploaded, and your original file is never changed. Keys are matched ignoring case and outer spaces if you like. Left, inner, full and not-found joins are supported.
Input: XLSX, XLS, ODS, CSV. Output: XLSX, CSV.
How to use Spreadsheet Lookup & Join
- Drop the main sheet.
- Drop the lookup sheet.
- Pick the matching key columns.
- Choose which rows and columns to keep and download.
Tips
- Excel, ODS and CSV all work. Formulas are read as their last saved values.
- For CSV files with odd characters, save them as UTF-8 first.
Spreadsheet Lookup & Join FAQ
- Are my files uploaded?
- No. This tool runs entirely in your browser tab. Files are read from your disk into memory and the result is generated locally.
- Is it free? Are there limits or watermarks?
- Free and open source (MIT). There are no file-size caps, daily quotas, accounts or watermarks.
- Does it work offline?
- Yes, once the page (and any engine it needs) has loaded, it keeps working without a connection thanks to the service worker cache.
Related tools
- Compare Spreadsheets: Find every changed cell, added row and removed row between two Excel or CSV files.
- Merge Excel Files: Combine sheets from many Excel, ODS or CSV files into one workbook, or stack their rows into one table.
- Remove Duplicate Rows: Delete repeated rows from Excel or CSV, matching on all columns or the ones you pick, ignoring case and spaces.
- Merge Word Documents: Combine DOCX files into one, keeping text, tables, images and links, with page breaks between them.