Template

Vendor list template (free CSV for Excel and Google Sheets)

A vendor list template is a spreadsheet with one row per supplier and columns for who they are, what they provide, who owns the relationship, what you pay and when the contract can be cancelled. Download the free CSV below (28 columns, six clearly fictional example rows), then follow the setup steps to add dropdowns, filters and renewal alerts in Excel or Google Sheets.

Updated November 17, 2026 ยท 10 min read

Download the vendor list template (CSV) A CSV file that opens in Excel and Google Sheets. Delete the example rows before use.

Key takeaways

  • The columns that save money are the boring ones: contract end, notice period, auto-renewal and a calculated notice deadline.
  • Give every vendor a permanent ID and one internal owner. A list without owners is a list nobody updates.
  • Use dropdowns for status and category, or you will have "IT", "I.T." and "Tech" as three categories within a month.
  • Keep 8 to 12 top-level categories that match how your company is organized, not how vendors describe themselves.
  • Do not store bank details or tax ID numbers in a shared sheet. Track that the document is on file, and keep it somewhere restricted.

Vendor list, vendor database, approved vendor list: what is the difference?

  • Vendor list (also supplier list or vendor contact list): every supplier you buy from or are considering, one row each, with contacts and commercial basics. This template.
  • Vendor database: the same data split into linked tables (vendors, contracts, contacts, invoices) sharing a vendor ID. Worth it once one vendor has several contracts or many contacts.
  • Approved vendor list (AVL): the subset that passed your checks and may be used without further approval. It is a status on this list, not a separate file. More in the approved vendor list guide.

The columns that matter, and why

The template has 28 columns in seven groups. The letters below match the CSV, so the formulas later on this page work without changes.

ColColumnWhy it is there
Identity
AVendor IDPermanent key (V-0001). Names change, companies rebrand; the ID never does and is never reused. Links the list to contracts, invoices and quotes.
BVendor nameThe legal name as it appears on invoices, so finance can match them.
CWebsiteThe best duplicate check you have: two rows with the same domain are almost always the same vendor.
Classification
DCategoryFrom a fixed dropdown (taxonomy below). Lets each department filter to its own vendors.
ESubcategoryOptional second level, useful once a category has more than ten vendors.
FServices providedPlain words, the way an employee would search for it ("office cleaning", "payroll").
GStatusProspect, Approved, Active, On hold, Inactive or Blocked. Definitions below.
People
HInternal ownerOne role or person accountable for the relationship, renewals and updates. Use a role if people change often.
I to LContact name, role, email, phoneOne primary contact. If you need billing, support and escalation contacts too, move contacts to their own tab keyed by vendor ID.
Commercial
M, NCountry, currencyDrive tax treatment, payment method and exchange risk.
OPayment termsNet 15, Net 30, upfront. Finance needs it; it is also a negotiating lever.
Contract
P, QContract start, contract endDates in YYYY-MM-DD so they sort and calculate correctly.
RNotice period (days)How long before the end you must cancel. Usually found in the terms, not the quote.
SAuto-renewsYes or No. A Yes with no notice deadline in the calendar is how unwanted renewals happen.
TNotice deadlineContract end minus notice period. The single most useful date on the sheet; the alerts below are built on it.
UAnnual spend (est.)Tells you where to spend review time: sort by it and start at the top.
V, WLast quote date, last quoted priceYour baseline for the next negotiation or comparison.
Performance and risk
XRating (1-5)The owner's overall score, updated at each review. Write the reason in Notes.
YData accessDoes the vendor touch personal or confidential data? If Yes, it needs a data processing agreement and a closer review.
ZDocuments on fileWhich documents exist (contract, DPA, insurance certificate, tax form), not the documents themselves.
Housekeeping
AALast reviewedWhen the owner last confirmed the row is correct. Rows older than a year are suspect.
ABNotesDecisions and reasons: why on hold, why blocked, what was promised at renewal.

The 10-column minimum version

If 28 columns is more than a small team will maintain, keep these and delete the rest: Vendor ID, Vendor name, Website, Category, Status, Internal owner, Contact email, Contract end, Notice deadline, Notes. That still answers the three questions people actually ask: who do we use for X, who do I talk to, and when can we get out of it.

What the example rows look like

The CSV ships with six fictional vendors on reserved .example domains and fictional phone numbers, chosen to show each status and a few edge cases. A shortened view:

IDVendorCategoryStatusContract endNotice deadline
V-0001Example Content StudioMarketingActive2026-12-312026-11-01 (missed: it will auto-renew)
V-0002Sample Cloud Hosting Inc.ITActive2027-06-302027-04-01
V-0003Demo Talent Partners LtdHR and recruitingApproved(none: fee per hire)
V-0004Placeholder Bookkeeping LLCFinanceActive2027-02-282027-01-29
V-0005Example Office Cleaning Co.FacilitiesOn hold2026-10-312026-10-01
V-0006Sample Legal Advisors LLPLegalProspect

Row V-0001 is the reason the notice deadline column exists: the contract ends at the end of December, but the last day to cancel was the first of November.

How to set it up in Excel

A CSV stores data only, not formatting, dropdowns or rules. Open it once, then save as a workbook before you add anything.

  1. Open and save as .xlsx. Open vendor-list.csv, then File, Save As, Excel Workbook. If everything lands in column A (common with some European regional settings), use Data, From Text/CSV instead and choose comma as the delimiter.
  2. Make it a table. Click any cell and press Ctrl+T (My table has headers). Tables extend formulas and formatting to new rows automatically and add filter buttons to every header.
  3. Freeze the header and the name. Click cell C2, then View, Freeze Panes, Freeze Panes. Rows and the ID and name columns stay visible while you scroll.
  4. Create a Lists sheet. Add a sheet called Lists. Put the six statuses in A2:A7 and your categories in B2:B12.
  5. Add dropdowns. Select the Status column, then Data, Data Validation, Allow: List, Source: =Lists!$A$2:$A$7. Repeat for Category with =Lists!$B$2:$B$12 and for Auto-renews and Data access with the source Yes,No.
  6. Calculate the notice deadline. In T2 enter the formula below and format the column as a date. The table copies it down.
  7. Add renewal alerts. Select the data rows, then Home, Conditional Formatting, New Rule, Use a formula. Add the red rule first, then the amber one.

How to set it up in Google Sheets

  1. Import. In a new spreadsheet, File, Import, Upload, choose the CSV, Replace spreadsheet, separator detected automatically.
  2. Freeze. View, Freeze, 1 row; then View, Freeze, up to column B.
  3. Filter. Data, Create a filter. For views that do not disturb colleagues (for example "my vendors only"), use Data, Filter views.
  4. Dropdowns. Add a Lists sheet as above, select the Status column, then Data, Data validation, Add rule, Criteria: Dropdown (from a range), Lists!A2:A7. For Contact email, use the criterion "Text is valid email".
  5. Formulas and alerts. Same formulas as Excel. Conditional formatting lives under Format, Conditional formatting, Format cells if: Custom formula is. Rules apply top to bottom, so put red above amber.
  6. Permissions. Share with edit rights only to the people who maintain rows; everyone else gets view access. Version history (File, Version history) shows who changed what.

Copy-ready formulas

These work in both Excel and Google Sheets with the template's column letters. Some regional settings use a semicolon instead of a comma between arguments.

Notice deadline (T2): =IF(Q2="","",Q2-R2) Red: notice deadline within 30 days or already passed (conditional formatting rule): =AND($T2<>"",$G2="Active",$T2-TODAY()<=30) Amber: notice deadline within 90 days: =AND($T2<>"",$G2="Active",$T2-TODAY()<=90) Possible duplicate (same website on two rows): =AND($C2<>"",COUNTIF($C:$C,$C2)>1) Review overdue (not reviewed for a year): =OR($AA2="",TODAY()-$AA2>365) Email sanity check (Excel data validation, Custom): =ISNUMBER(SEARCH("@",K2))

A useful pivot (Insert, PivotTable in Excel; Insert, Pivot table in Sheets): rows = Category, values = SUM of Annual spend and COUNT of Vendor ID, filter Status = Active. It shows in one glance where the money goes and where you have five vendors doing the same job.

A category taxonomy for a typical company

Categories should mirror who inside your company buys and owns the relationship, so each team can filter to its own vendors. Start with this and merge or delete what you do not use. Ten to twelve top-level categories is plenty for most companies.

CategoryTypical subcategoriesUsual owner
MarketingSEO, paid media, content and copywriting, PR, design and video, events, printing, marketing softwareMarketing
SalesLead data, sales software, outsourced prospecting, promotional merchandiseSales
ITHosting and infrastructure, software subscriptions, hardware, IT support, cybersecurity, development agencies, telecomIT or engineering
HR and recruitingRecruitment agencies, background checks, payroll, benefits, training, HR softwareHR
FinanceAccounting and bookkeeping, audit, tax advice, banking and payments, insurance brokersFinance
LegalCommercial contracts, employment law, intellectual property, privacy and complianceLegal or operations
FacilitiesOffice space, cleaning, maintenance, security, utilities, furnitureOffice manager
Operations and logisticsCouriers, freight, warehousing, packagingOperations
Professional servicesManagement consulting, translation, research, specialist contractorsRequesting team
Travel and eventsTravel agency, hotels, venues, cateringOffice manager or HR
Office suppliesStationery, kitchen, small equipmentOffice manager

Two rules keep it clean. First, each vendor gets one primary category, the team that owns it; mention other services in the Services column. Second, nobody adds a category by typing it in a cell: changes go through the Lists sheet.

Status definitions

StatusMeaningMoves to
ProspectOffer received or vendor shortlisted, not checked yetApproved after checks (see how to verify a vendor)
ApprovedChecked and allowed to be used, no active contractActive when work starts
ActiveCurrent contract or recurring spendOn hold or Inactive
On holdProblem under review; no new workActive or Blocked
InactiveNo spend for 12 months; kept for historyApproved again after a fresh check
BlockedDo not use; reason in NotesOnly by owner decision

Moving a vendor from Approved to Active is a good trigger for the vendor onboarding checklist; collecting their details in a consistent shape is easier with a vendor registration form.

What not to put in the sheet

  • Bank account details. They belong in your accounting or payment system, where changes are controlled. A shared spreadsheet is exactly where a fake "please update our bank details" email does its damage.
  • Tax ID numbers and tax forms. In the US, businesses commonly collect IRS Form W-9 from vendors to get the taxpayer identification number they need for information returns. Store the form in a restricted folder and only mark "W-9" in the Documents on file column.
  • More personal data than you need. Vendor contacts are people, and in the UK and EU their names, work emails and phone numbers are personal data under data protection law. Keep only what you use, limit who can edit, and remove contacts who have left. The UK regulator, the ICO, publishes guidance for organizations. This is general information, not legal advice.

When a spreadsheet stops working

A vendor list in a spreadsheet is the right tool for a small team with a stable set of suppliers. It starts to break in predictable ways:

  • Several people edit it. Rows get overwritten, the filter someone left on hides half the list, and nobody is sure which copy is current.
  • Offers arrive by email. New vendors pitch every week, but the sheet only learns about them if someone copies the details in by hand, so most never make it.
  • Duplicates creep in. "Acme", "ACME Ltd" and "Acme Digital" are one vendor, entered by three people who did not check.
  • Departments cannot see their own offers. The marketing agency that pitched the CEO never reaches the marketing lead.
  • Prices go stale. The quote you compared against last year lives in someone's inbox, not in the row.
This is the gap PitchBin fills for incoming offers. Forward any vendor email to save@pitchbin.com and it is filed in a shared company catalog with the vendor, service, price and category extracted, and the sender's website checked. Everyone who signs up with your work email domain joins the same catalog, teammates follow their categories so marketing offers reach marketing, and each offer keeps its status, notes and rating. Your spreadsheet can stay the record of contracted vendors; the catalog holds everything that is pitched to you. Free for companies receiving offers. More in a vendor database that builds itself.

When you have several offers for the same need, the quote comparison guide and template takes you from the list to a decision.

Frequently asked questions

What should a vendor list include?

At minimum: a permanent vendor ID, legal name, website, category, status, internal owner, primary contact, contract end date, notice deadline and notes. Add payment terms, spend, ratings and documents on file as the list grows.

How do I make a vendor list in Excel?

Open the CSV, save it as an .xlsx workbook, convert the range to a table with Ctrl+T, add dropdowns for status and category with Data Validation, and add conditional formatting on the notice deadline so upcoming renewals turn amber and red.

What is the difference between a vendor list and an approved vendor list?

A vendor list holds every supplier you use or are considering. An approved vendor list is the subset that passed your checks and can be used without further sign-off. In this template it is simply the rows with status Approved or Active.

How often should a vendor list be reviewed?

Review high-spend and data-access vendors at least once a year and before every notice deadline. A quarterly pass to clear duplicates, update statuses and remove departed contacts keeps the rest usable.

Can I use this template as a vendor contact list?

Yes. For a contact list only, keep the ID, name, website, category, owner and the four contact columns. If you need several contacts per vendor, move them to a second sheet keyed by vendor ID.

Is the template free to use?

Yes. It is a plain CSV file you can download, edit and share inside your company. The example rows are fictional and should be deleted before use.

Let the vendor list fill itself.

Forward vendor offers to save@pitchbin.com and they land in one shared, searchable catalog with company, service, price and category filled in. Free for companies receiving offers.

Create your PitchBin