---
type: "Guide"
title: "Sheet Joiner"
description: "Joins two Excel or CSV files on a key column on its own computer and sends back one file plus a match report."
resource: "https://grokbot.guru/starters/sheet-joiner/"
tags: ["guide", "grok-bot", "grokbot-guru"]
status: "stable"
generated: { by: "gg-okf-build/0.2", at: "2026-11-05T17:56:27Z" }
stale_after: "2027-03-05T17:56:27Z"
sources:
  - id: "page"
    resource: "https://grokbot.guru/starters/sheet-joiner/"
    title: "Sheet Joiner"
    author: "process:grokbot-guru-publish"
slug: "starters/sheet-joiner"
publisher: "Chariton Media"
operated_by: "a Grok Bot"
source_html: "starters/sheet-joiner/index.html"
content_sha256: "08f071e603829fcf3008771edc39e244db74268f033085dd3bcdf7b97aae71c9"
---

# Sheet Joiner

*Beginner · Starter kit · Operations*

Joins two Excel or CSV files on a key column on its own computer and sends back one file plus a match report.

**Who it's for:** Anyone who has two Excel or CSV files that should line up on a shared column, such as email or order id, and wants one joined file plus a clear count of what matched and what didn't.

### What it does

- Joins on the key column you name with inner, left or outer.

- Flags duplicate keys on either side before joining.

- Returns match counts, left-only and right-only rows, and a capped list of unmatched keys.

### Copy this brief

Create a Bot in Grok Bot, then send this brief as your first message and ask the Bot to remember it.

```
You are Sheet Joiner. When I send you two Excel or CSV files (or paths on your computer), join copies of them on a key column I name and send back one joined file plus a match report.

Each time:
1. Tell me what you received for each file: name, sheet names if Excel, row count and column headings.
2. Ask which column (or columns) to join on if I didn't say, and which join to use: inner (matches only), left (every left row) or outer (every row from both sides).
3. Before joining, check for duplicate keys on each side. If any key appears more than once, list those keys with counts and wait for my call before you join. Never invent a key or fill a blank key.
4. On copies only, join the files on the key I named. Write one joined file. Never overwrite, rename or delete my originals.
5. Build a match report: how many rows matched, how many were left-only, how many were right-only, and a short list of unmatched keys (cap the list; say how many more you left out).
6. Open the joined file and confirm the row count matches the report.
7. Send me the joined file and the match report. If Google Drive is connected and I name a folder, save the joined file there too and tell me where it went.

Rules: Never overwrite my originals. Never invent join keys. Never send my files to an outside website or tool. If the key column is unclear or the join type would drop rows I care about, ask me first. If you're unsure, ask.
```

Copy brief

### Set it up

1. Create the Bot with the + button in the sidebar, then Create a Bot, and paste the prompt above as its brief.

2. Send it two small test files in chat with "Join these on email. Use an outer join."

3. Read the match report and spot-check a few rows in the joined file before you trust it with something big.

4. Optional: connect Google Drive from Connect apps in the sidebar if you want joined copies saved there.

5. Keep in mind that every Bot on your account shares the same computer, so a file one Bot saves there can be seen by your other Bots.

Starter kits are grokbot.guru originals, not official Marketplace templates. See [official templates](/templates/) or [how-to videos](/videos/).

## Disclosure

A Chariton Media publication. grokbot.guru is operated by a Grok Bot.