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.
| Col | Column | Why it is there |
|---|---|---|
| Identity | ||
| A | Vendor ID | Permanent key (V-0001). Names change, companies rebrand; the ID never does and is never reused. Links the list to contracts, invoices and quotes. |
| B | Vendor name | The legal name as it appears on invoices, so finance can match them. |
| C | Website | The best duplicate check you have: two rows with the same domain are almost always the same vendor. |
| Classification | ||
| D | Category | From a fixed dropdown (taxonomy below). Lets each department filter to its own vendors. |
| E | Subcategory | Optional second level, useful once a category has more than ten vendors. |
| F | Services provided | Plain words, the way an employee would search for it ("office cleaning", "payroll"). |
| G | Status | Prospect, Approved, Active, On hold, Inactive or Blocked. Definitions below. |
| People | ||
| H | Internal owner | One role or person accountable for the relationship, renewals and updates. Use a role if people change often. |
| I to L | Contact name, role, email, phone | One primary contact. If you need billing, support and escalation contacts too, move contacts to their own tab keyed by vendor ID. |
| Commercial | ||
| M, N | Country, currency | Drive tax treatment, payment method and exchange risk. |
| O | Payment terms | Net 15, Net 30, upfront. Finance needs it; it is also a negotiating lever. |
| Contract | ||
| P, Q | Contract start, contract end | Dates in YYYY-MM-DD so they sort and calculate correctly. |
| R | Notice period (days) | How long before the end you must cancel. Usually found in the terms, not the quote. |
| S | Auto-renews | Yes or No. A Yes with no notice deadline in the calendar is how unwanted renewals happen. |
| T | Notice deadline | Contract end minus notice period. The single most useful date on the sheet; the alerts below are built on it. |
| U | Annual spend (est.) | Tells you where to spend review time: sort by it and start at the top. |
| V, W | Last quote date, last quoted price | Your baseline for the next negotiation or comparison. |
| Performance and risk | ||
| X | Rating (1-5) | The owner's overall score, updated at each review. Write the reason in Notes. |
| Y | Data access | Does the vendor touch personal or confidential data? If Yes, it needs a data processing agreement and a closer review. |
| Z | Documents on file | Which documents exist (contract, DPA, insurance certificate, tax form), not the documents themselves. |
| Housekeeping | ||
| AA | Last reviewed | When the owner last confirmed the row is correct. Rows older than a year are suspect. |
| AB | Notes | Decisions 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:
| ID | Vendor | Category | Status | Contract end | Notice deadline |
|---|---|---|---|---|---|
| V-0001 | Example Content Studio | Marketing | Active | 2026-12-31 | 2026-11-01 (missed: it will auto-renew) |
| V-0002 | Sample Cloud Hosting Inc. | IT | Active | 2027-06-30 | 2027-04-01 |
| V-0003 | Demo Talent Partners Ltd | HR and recruiting | Approved | (none: fee per hire) | |
| V-0004 | Placeholder Bookkeeping LLC | Finance | Active | 2027-02-28 | 2027-01-29 |
| V-0005 | Example Office Cleaning Co. | Facilities | On hold | 2026-10-31 | 2026-10-01 |
| V-0006 | Sample Legal Advisors LLP | Legal | Prospect |
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.
- 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.
- 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.
- 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.
- Create a Lists sheet. Add a sheet called Lists. Put the six statuses in A2:A7 and your categories in B2:B12.
- 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.
- Calculate the notice deadline. In T2 enter the formula below and format the column as a date. The table copies it down.
- 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
- Import. In a new spreadsheet, File, Import, Upload, choose the CSV, Replace spreadsheet, separator detected automatically.
- Freeze. View, Freeze, 1 row; then View, Freeze, up to column B.
- Filter. Data, Create a filter. For views that do not disturb colleagues (for example "my vendors only"), use Data, Filter views.
- 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".
- 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.
- 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.
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.
| Category | Typical subcategories | Usual owner |
|---|---|---|
| Marketing | SEO, paid media, content and copywriting, PR, design and video, events, printing, marketing software | Marketing |
| Sales | Lead data, sales software, outsourced prospecting, promotional merchandise | Sales |
| IT | Hosting and infrastructure, software subscriptions, hardware, IT support, cybersecurity, development agencies, telecom | IT or engineering |
| HR and recruiting | Recruitment agencies, background checks, payroll, benefits, training, HR software | HR |
| Finance | Accounting and bookkeeping, audit, tax advice, banking and payments, insurance brokers | Finance |
| Legal | Commercial contracts, employment law, intellectual property, privacy and compliance | Legal or operations |
| Facilities | Office space, cleaning, maintenance, security, utilities, furniture | Office manager |
| Operations and logistics | Couriers, freight, warehousing, packaging | Operations |
| Professional services | Management consulting, translation, research, specialist contractors | Requesting team |
| Travel and events | Travel agency, hotels, venues, catering | Office manager or HR |
| Office supplies | Stationery, kitchen, small equipment | Office 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
| Status | Meaning | Moves to |
|---|---|---|
| Prospect | Offer received or vendor shortlisted, not checked yet | Approved after checks (see how to verify a vendor) |
| Approved | Checked and allowed to be used, no active contract | Active when work starts |
| Active | Current contract or recurring spend | On hold or Inactive |
| On hold | Problem under review; no new work | Active or Blocked |
| Inactive | No spend for 12 months; kept for history | Approved again after a fresh check |
| Blocked | Do not use; reason in Notes | Only 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.
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.
Keep reading
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.