Vendor List Template: Track Every Event Vendor in One Place

An event vendor list is the one place that answers the questions you get asked all season: who is coming, where they are, whether they have paid, whether their insurance is on file and when they arrive. Without it, those answers live in an inbox, a payment app, a folder of certificates and a printed map with pencil marks, and they drift apart the moment a vendor swaps spaces.

The phrase has a second meaning in purchasing, where a vendor list (or approved vendor list) is the set of suppliers a company may buy from. This page is about events: the businesses that rent a space to sell or exhibit at your market, fair, festival or expo, plus the service suppliers you hire to run it, such as rentals, catering, security and sanitation.

• Market and fair organizers tracking dozens or hundreds of selling vendors
• Festival teams managing food vendors, merchandise stalls and sponsors' activations
• Expo and trade show organizers with exhibitors who need booths, services and paperwork
• Committees and volunteers who need to read the same list without editing it

Start from the decisions and tasks the list has to support, then add a column for each. Most event vendor lists need the columns below. Delete what you will never filter or sort by.

Keep one row per vendor, not per space. A vendor with two stalls gets one row with both numbers in the Space column, separated by a semicolon, so payment and insurance are tracked once. If your event has more than one area, such as an indoor hall and an outdoor lot, add an Area column rather than a second sheet.

The Status column is what turns a contact list into a working tool. Define a small set of values, write down what each one means, and only use those. When a teammate asks who still needs a nudge, the answer is a filter, not a meeting.

Copy the header row into the first row of a spreadsheet, or paste the whole block and split it into columns on the vertical bar. The two example rows show the format; delete them once your first real vendors are in.

[EVENT NAME] Vendor List | Last updated: [DATE] by [NAME]

Vendor ID | Business name | Contact name | Email | Mobile | Category | Area | Space | Space size | Status | Fee | Paid | Balance | Insurance | COI expiry | Permit type and number | Power (amps) | Load-in time | Load-in entrance | Vehicle | Notes

V001 | [BUSINESS NAME] | [NAME] | [EMAIL] | [MOBILE] | [CATEGORY] | [AREA] | [SPACE NUMBER] | [SIZE] | Confirmed | [FEE] | [PAID] | [BALANCE] | Approved | [DATE] | Not required | None | [TIME] | [GATE] | Van, leaves after unload | [DATED NOTE]
V002 | [BUSINESS NAME] | [NAME] | [EMAIL] | [MOBILE] | Food | [AREA] | [SPACE NUMBER]; [SPACE NUMBER] | [SIZE] | Accepted, unpaid | [FEE] | 0 | [BALANCE] | Not received | | [PERMIT TYPE AND NUMBER] | [AMPS] | [TIME] | [GATE] | Food truck, stays on site | [DATED NOTE]

Allowed values
Category: [YOUR CATEGORY LIST]
Status: Applied, Accepted unpaid, Confirmed, Ready, Waitlisted, Declined, Cancelled, No-show
Insurance: Not received, Received, Approved, Rejected, Not required

Keep the suppliers you hire on a second tab. They need different columns: what they deliver, when, and who on your team owns the relationship.

[EVENT NAME] Supplier List

Supplier | Service | Contact name | Mobile | Email | Contract signed | Deposit paid | Balance due date | Delivery or arrival time | Pickup time | Day-of contact | Team owner | Notes

[RENTAL COMPANY] | Tents, tables, chairs | [NAME] | [MOBILE] | [EMAIL] | Yes | Yes | [DATE] | [DATE AND TIME] | [DATE AND TIME] | [NAME AND MOBILE] | [TEAM MEMBER] |
[SANITATION COMPANY] | Portable restrooms, handwashing | [NAME] | [MOBILE] | [EMAIL] | Yes | No | [DATE] | [DATE AND TIME] | [DATE AND TIME] | [NAME AND MOBILE] | [TEAM MEMBER] |

1. 1

   Pick One Master List

   Decide which file is the master and say so in its title. Every other list, from the load-in schedule to the public vendor directory, is pulled from it.

2. 2

   Lock Down the Values

   Use dropdowns (data validation in Excel and Google Sheets) for Category, Status and Insurance. Free-typed values like 'paid?' and 'pd' break every filter.

3. 3

   Make It Easy to Filter

   Freeze the header row, turn on filters, and format money and date columns properly so they sort.

4. 4

   Control Who Edits

   Give most of the team view or comment access, and editing rights to the few people who change vendor records. Add a tab that logs every space swap and cancellation with a date.

5. 5

   Protect Vendor Data

   Contact details and insurance documents are personal and business data. Keep the master private, and only share the columns each person needs.

A vendor list is only useful if people trust it. The rule that makes that happen is simple: whoever learns about a change updates the list the same day, and a review on a set schedule catches anything missed.

• Date every note, and write who made it
• Never delete a cancelled vendor's row; change the status so the history stays
• When a vendor moves, update the Space column and the floor plan together
• Reconcile the Paid column against your payment records before each review
• Archive last year's list and start a fresh copy, carrying over returning vendors

Most of the documents you send in the last month are filtered or sorted views of the master. Build them from it rather than retyping, so a late change only has to be made once.

• Load-in schedule: sorted by load-in time and entrance, for gate volunteers
• Missing documents: filtered to Insurance not Approved, or permits blank for food vendors, for your reminder emails
• Unpaid balances: filtered to Balance greater than zero
• Power order: filtered to Power needed, with amperage, for the electrician or venue
• Food vendors: name, space and permit numbers, if the health department asks for them
• Public vendor directory: business name, category and space only, never contact or payment columns

Before you can fill the Space column you need a numbered layout. Our event floor plan maker explains how to draw one, and the vendor application form template collects most of these columns at the point of application. Insurance columns are easier to fill when you have told vendors exactly what to send; see the vendor certificate of insurance guide.

A spreadsheet is a fine start for a small market. It starts to strain when vendors book and pay at different times, swap spaces, and send documents by email, because every one of those events needs someone to update the list by hand.

• Space swaps are made on the map but not in the list, or the other way round
• Payments arrive in one tool and are copied into the list days later
• Certificates of insurance sit in an inbox, with the list still showing Not received
• Several people keep their own copy, and nobody knows which one is right

If that sounds familiar, vendor fair software and exhibitor management software keep the vendor record, the space and the payment together. For farmers markets in particular, start with our farmers market vendor application, and if you are launching a new market, how to start a flea market covers setting up stall numbering from day one.