Login
Book a demo

VLOOKUP Online: Join Google Sheets, Excel and CSV by a Key Column

Inner Join or Left Join — no formulas, no setup

Run a VLOOKUP-style join between two spreadsheets. Pick the key column in each file, choose Inner Join or Left Join, and select which columns to include in the output. Works with Google Sheets, Excel, CSV, BigQuery, and REST APIs. Free, in-browser, no signup.

Use the tool

How it works

Step 1
Connect both tables
Upload your left and right files, pick them from Google Drive, run BigQuery queries, or pull from REST API endpoints.
Step 2
Pick the key columns + join type
Choose the matching column in each table, and pick Inner Join (only matches) or Left Join (all left rows plus matches).
Step 3
Choose output columns + download
Select which columns to include in the result, then download your joined file.

Want to schedule this, not just run it once?

Need your CRM joined with billing data every morning? Sheetgo can run this VLOOKUP-style join on a schedule, pulling from Google Sheets, Excel, BigQuery, or any API — and push the result into your master dashboard.

Get Sheetgo on Google Workspace Marketplace

Frequently Asked Question

Dive deeper into VLOOKUP-style joins

Get the answers to your questions about joining Google Sheets, Excel, and CSV

What's the difference between this and Excel's VLOOKUP?

L
K

Excel’s VLOOKUP is a formula inside one file. This tool takes two separate files and produces a merged third file — no formulas to write, no ranges to pin.

What's the difference between Inner Join and Left Join?

L
K

Inner Join keeps only rows where the key value exists in both files. Left Join keeps every row from the left file, adding matched data where the key exists in the right file, and leaving blanks where it doesn’t.

Can I choose which columns to include in the output?

L
K

Yes. After selecting the key columns, pick which columns from each file should appear in the joined output — useful when you only need a few fields from a large table.

Does it work with Google Sheets, BigQuery, and APIs?

L
K

Yes. Each side of the join can come from a Google Sheet, Excel file, CSV, BigQuery query, or REST API endpoint — mix and match as needed.

What else can I do with the Sheetgo add-on?

L
K

Beyond scheduled automation, the Sheetgo add-on — powered by Sheetgo Workflows — can send personalized emails from spreadsheet rows, generate Google Docs or PDFs as mail-merge outputs, chain multiple processing steps into one flow (for example: filter → merge → dedupe → email), and orchestrate approvals across teams. Everything runs unattended once set up. One-click install from Google Workspace Marketplace.

Which data sources can I connect to with Sheetgo?

L
K

With the Sheetgo add-on, your automated flows can pull from Google Sheets, Excel, CSV files in Google Drive, BigQuery (with live SQL queries), and any REST API using Bearer Token, API Key, or Basic authentication. The output can land back in a spreadsheet, a generated Google Doc or PDF, an email, or any combination chained in a Workflow.

FAQ image