Join two weekly CSVs without Power Query or Python

Two CSVs, one question. The first has customer IDs and last week's orders; the second has customer IDs and their region. You just need them joined so you can slice orders by region. In Excel that means a VLOOKUP that breaks the moment the files grow, in Power Query it means learning M for a ten-minute task, and in Python it means a notebook you will re-run by hand next week. All you wanted was a join.

A join does not need to be a project. Build it once as a workflow and re-run it on next week's pair of exports.

Why the usual tools overshoot

• VLOOKUP is fragile: one moved column or a stray space and it silently returns the wrong value.
• Power Query is powerful but lives inside the Excel/Power BI stack and has a real learning curve.
• A Python script works, but now you own an environment, dependencies, and a manual re-run every week.

The join workflow

1. Load both exports into the workflow.
2. Trim & Clean the key column in each so whitespace does not break matches.
3. Type Convert the key to the same type in both files so IDs line up.
4. Join on the key to bring region onto every order row.
5. If keys sometimes drift, use a fuzzy join with a threshold so near-matches still connect.

See what matched — and what didn't

The receipt shows how many rows matched and how many keys had no partner in the other file. Unmatched keys are usually the interesting part: a customer missing a region, an ID that changed between exports. Instead of a VLOOKUP quietly returning blanks, you get an explicit list.

Save it as your "Weekly join" workflow. Next week, swap in the two new exports and re-run. The join you would have rebuilt by hand is now a single click.