Auto Lot Finder Back to Auto Lot Finder

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

ColumnWhat goes in it
vin17 characters, from the door jamb or windshield barcode.
stock_numberThe yard's own number, written on the windshield.
year, make, modelFrom the car or its paperwork.
statusintake, ready, parts, hold, crush, sold, scrapped. Use data validation so it is always one of these.
zoneWhere it is parked: a zone name, a row and stall.
intake_dateThe 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

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