Create a Vendor Comparison Spreadsheet
6. Small Business Essentials (Documents & Operations)
⏱ 20 minutes min
📊 Beginner
Objective
Build a simple side-by-side comparison to choose between vendors or suppliers.
Materials Needed
- AI chat tool
- Names or types of vendors being compared
Step-by-Step Instructions
-
1
List the vendors or suppliers you're considering and what factors matter most (price, quality, delivery time, reviews).
-
2
Prompt: 'Create a comparison spreadsheet template with these vendors as rows and these factors as columns, plus a simple scoring system.'
-
3
Fill in what you know about each vendor.
-
4
Ask the AI which vendor looks strongest based on your inputs and why.
-
5
Save the spreadsheet to revisit for future vendor decisions.
Instructor TipThis same template structure works for comparing software subscriptions, contractors, or even job candidates.
TakeawayA simple scoring spreadsheet turns a gut-feeling vendor decision into a clear, defensible comparison.
Tools Used
- ChatGPT
- Claude.ai
- Gemini