How I turn a messy vendor contact dump into a clean vendor directory

A screenshot of a text thread that says "ask Mike about the bolts," three different spellings of the same supplier in your email, a business card photo from last year, and a "vendors" tab that stopped updating in March are not a directory. They are how you call the wrong person when something is late and then invent a new contact row every time you buy.

Here is the workflow I use when someone dumps a pile of vendor scraps on me and wants one clean vendor directory they can open without reconstructing who sells what from memory.

What "good enough" looks like

• Every vendor sits on one row: legal/trade name, category, primary contact, phone, email, website, payment terms, notes
• Duplicates are merged (same company, two spellings) instead of living as three half-filled rows
• Categories match how they buy (supplies / freelancers / software / logistics / landlords — whatever buckets they actually use)
• Preferred contact method and lead time are visible without digging through old threads
• One skim answers "who do we buy X from, who do we call, and what are the terms?"

Intake checklist

1. The messy dump (email exports, text screenshots, business card photos, old CRM/CSV scraps, invoice headers, sticky notes)
2. How they group vendors today (or permission to invent short category labels)
3. Which fields matter for reordering (terms, account #, preferred contact, lead time) vs nice-to-have
4. Anything confidential to keep off a shareable sheet (SSN/EIN dumps, full card numbers — never copy those into a directory)
5. Which "vendors" are actually clients or one-off people to park separately

The pass order that saves time

1. Inventory the scraps — list every source: name guess, category guess, contact bits, where it came from.
2. Normalize names — one spelling per company; merge obvious duplicates; park unknowns in a "needs confirm" bucket.
3. One row per vendor — contacts can have a primary + optional backup columns; do not invent five empty rows for one shop.
4. Fill the buy-critical fields first — phone/email/website, category, payment terms, lead time if known.
5. Add reorder hygiene — preferred SKU/product notes, account/customer # if they gave it, last-used date if obvious from invoices.
6. Build the sheet — Directory + optional Categories filter/view + Needs confirm tab.
7. Hand back — the vendor directory only; no full procurement system, ERP vendor master, or AP rebuild unless they asked separately.

Directory columns that work

Column / section	What goes here
Vendor name	Consistent trade/legal name after cleanup
Category	Supplies / software / contractor / logistics / other (their buckets)
Primary contact	Person name if known
Phone	Best number to call for orders or issues
Email	Best inbox for POs / quotes
Website / portal	Ordering URL if they use one
Payment terms	Net 30 / COD / card on file / etc. if known
Lead time	Typical days if they told you
Account #	Optional customer/account id — never full payment credentials
Status	Active / seasonal / needs confirm / do not use
Notes	"text only," "orders via portal," "Mike handles bolts," quirks

Common traps

• Creating a new row every time the same company emails from a different person
• Copying bank account numbers or card PANs into a "directory" tab that gets shared
• Mixing freelancers, landlords, and product suppliers with no category so filters are useless
• Keeping three spellings of one vendor because each partial row has one useful field
• Shipping a pretty CRM with empty phones and calling it procurement ready
• Treating a stale invoice header as today's preferred contact without a confirm flag

Soft handoff

When the sheet is done, send:

• The vendor directory (active + needs-confirm views)
• A short list of names that still need a phone, email, or spelling confirm
• One suggested next step (fill missing phones from last invoices, archive do-not-use rows, or dump next month's new supplier cards)

That is the whole job. No procurement suite rebuild required for a cleanup pass. I am a freelancer admin / spreadsheet person, not a purchasing consultant — this is contact hygiene, not vendor risk advice.

---

I do this as a 24-hour DFY service for freelancers and small businesses ($12 for messy vendor contacts → clean vendor directory). Shop: https://brittanybonds.gumroad.com/l/vendordir — code ADMIN12 for $2 off. Full catalog: https://brittanybonds.gumroad.com/ and https://brittany-bonds.github.io/