Guide
Free vehicle inventory template for Excel: a car lot inventory sheet
A car inventory template in Excel works for a small lot: one row per vehicle, a column for each fact you will be asked about, and a formula for days on lot. Download the CSV below, open it in Excel or Google Sheets, and keep one rule: a car is entered the day it arrives.
Download the vehicle inventory template (CSV)
The columns
| Column | What goes in it |
|---|---|
| vin | 17 characters, from the door jamb or windshield barcode. |
| stock_number | The yard's own number, written on the windshield. |
| year, make, model | From the car or its paperwork. |
| status | intake, ready, parts, hold, crush, sold, scrapped. Use data validation so it is always one of these. |
| zone | Where it is parked: a zone name, a row and stall. |
| intake_date | The day it arrived. Format the column as a date. |
| days_on_lot | =TODAY()-H2 when intake_date is column H. |
Make the sheet hard to break
- Freeze the header row and turn on a filter, so the counter can filter by status or zone.
- Use data validation lists for status and zone; free text drifts into ten spellings of "parts".
- Sort by days_on_lot, largest first, every Monday.
- Never delete a sold car. Change its status; the VIN must stay findable.
When a spreadsheet stops working
A shared sheet breaks when several people edit it from the yard at once, when the person with the laptop is not the person moving the car, and when nobody can type a VIN on a phone in the rain. That is the point to move to a car lot inventory app with VIN scanning and a shared yard.
Where Auto Lot Finder fits
Auto Lot Finder keeps the same columns, filled in on a phone at the car: scan the VIN, add year, make, model and stock number, pick a zone. Days on lot is computed for you, and Export writes a CSV with the same columns (plus last seen) that opens in Excel. Scout is free for 20 intakes a month.
Outgrown the spreadsheet?
Try the sample yard in your browser, or install the app and scan your first VIN.
More guides: Work & create · all Adelyons guides