# Car shortlist spreadsheet templates

Learn how to build a car shortlist spreadsheet template that puts listings side by side, so you can compare details and reach a decision you understand.

A [car shortlist spreadsheet template](/articles/build-a-car-comparison-spreadsheet/) is a grid that holds the details of several listings side by side. It turns scattered notes into comparison columns you can read at a glance. You bring your own information about each car, and the template keeps it organized for a decision. 

- Choose a template with one row per car and one column per detail you care about.
- Fix the comparison columns before you add cars, so every listing gets the same treatment.
- Record the source of each listing in its own column, so you can check details again.
- A shortlist document works for new and used cars; the columns simply change.
- Keep the file simple enough that you can explain every entry to yourself later.
 

## What a car shortlist template does 

A car shortlist template is a ready-made layout for comparing listings in a single view. The layout places each car in a row and each detail in a column. A spreadsheet template does the same job with cells you can sort and filter. 

The value of a shortlist document comes from structure rather than decoration. Every car answers the same questions in the same order. That symmetry lets you spot a difference between two listings without hunting through notes. 

A usable template stays small at the start. You add columns as your questions become clearer. The document grows with the decision instead of forcing you into fields you do not need. 

## Start with the decision you need to make 

A car shortlist decision template should begin with the question you are answering. Write down what the choice is really about, such as running costs, space or condition. The answer shapes which comparison columns earn a place. 

List the details that would change your mind about a car. Each detail becomes a candidate column. Group them into must-haves, strong preferences and nice extras, then keep the must-haves near the left of the sheet. 

A shortlist that tries to capture everything becomes hard to read. Drop any column you would never use to rule a car in or out. The remaining columns carry the decision, and the rest can wait. 

## Building the columns of the sheet 

Comparison columns are the backbone of any car shortlist spreadsheet. Give each column a short, clear heading and keep one type of information per column. Mixed content in a single column makes sorting and filtering unreliable. 

Place identifying details first, such as make, model, year and the listing source. Follow with condition, mileage and service history for a used car shortlist. Put cost-related fields and your own notes toward the right. 

Add a rating column where you score each car against your must-haves. A simple numeric score keeps your judgment visible and comparable. Keep the scoring rule written at the top of the sheet, so the numbers mean the same thing for every row. 

## Filling rows without skewing the comparison 

Each row of a car shortlist template should describe one listing only. Copy the same fields for every car, even where the answer is unknown. An empty cell is honest, while a guessed value damages the comparison. 

Record where each detail came from, such as the seller's description or your own inspection. A source column lets you check a claim before it influences the decision. Treat unverified details as open questions rather than facts. 

Enter figures in a consistent unit and format across the sheet. Mixed units break sorting and can hide a real difference between two cars. Note the unit in the column heading so nobody has to guess. 

## An easy car shortlist template layout 

An easy car shortlist template keeps the number of columns low and the headings obvious. A reader should understand the sheet without a guide. The layout below covers the fields most shortlists need, and you can remove any row that does not apply. 

The order matters less than the consistency. Keep identifying fields first, then condition and history, then cost and your score. Add a final column for open questions, so nothing gets lost between rows. 

Save the empty layout as a separate file before you fill it. That master copy becomes your reusable template for the next search. Each new search starts from a clean sheet rather than an edited one. 
| Column | What it holds | 
| Make and model | The identity of the car | 
| Year and mileage | Age and distance covered | 
| Condition notes | What you observed or were told | 
| Service history | Records the seller can show | 
| Asking cost | The figure in the listing | 
| Running cost notes | Fuel, tax and insurance factors | 
| Must-have score | Your rating against fixed criteria | 
| Source and open questions | Where the detail came from and what is unverified |  

## Adapting the sheet for used cars 

A used car shortlist needs fields that a new-car sheet can skip. Condition, mileage and service history carry weight because each car is unique. The same template works once you add those columns. 

Record the history documents a seller can actually show, not what they promise. Note any gaps in the record and treat them as questions for an inspection. A trained mechanic should check a used car before you commit to it. 

Keep a column for repair estimates you have been given by a qualified workshop. Estimated repair costs change the comparison between two similar cars. Leave the estimate blank until a specialist has looked at the car. 

## Keeping the document readable and current 

A shortlist document loses value when it grows messy after a few edits. Freeze the header row so headings stay visible while you scroll. Use one color for your own notes and another for seller claims. 

Update the sheet after every viewing or call, while the details are fresh. Date each update in a dedicated column, so you know how current a row is. Old rows that nobody has checked should be marked as such. 

Remove cars that no longer fit your criteria instead of leaving them crossed out. A shortlist with ten stale rows hides the two cars you are actually weighing. Keep the sheet short enough to read in one sitting. 

## Where a spreadsheet stops helping 

A spreadsheet compares recorded facts, not the feel of a car on the road. Some judgments need an inspection or a test drive that no cell can hold. Write those judgments in a notes column and date them. 

Mechanical checks and safety assessments belong with a trained specialist, not with a template. A sheet can remind you to book an inspection and record the result. It cannot replace the inspection itself. 

When two cars score the same, the sheet has done its job and the choice moves to your priorities. Revisit the must-have list and decide which criterion matters more. The document supports the decision rather than making it. 

## Questions about car shortlist templates 

### What should a car shortlist document include? 

A car shortlist document should include one row per car and the details that would change your decision. Identifying fields, condition, history, cost factors and your own score cover most shortlists. A source column keeps every claim traceable. 

### Can I build a car shortlist spreadsheet in any spreadsheet program? 

Yes, a car shortlist spreadsheet works in any spreadsheet program that supports rows, columns and sorting. The layout matters more than the software. Keep headings in the first row and one car per row. 

### Is there an easy car shortlist template for a first search? 

Yes, an easy car shortlist template starts with fewer than ten columns and grows only when a question appears. Begin with identity, condition, cost factors and a score. Add columns as your criteria become clear. 

### How is a used car shortlist different from a new car one? 

A used car shortlist adds condition, mileage and service history because each car differs. A new car sheet can focus on specification and cost. The same template serves both once you adjust the columns. 

### What is a car shortlist decision template? 

A car shortlist decision template is a sheet built around the choice you need to make. It lists your must-haves as fixed criteria and scores each car against them. The scoring rule stays written at the top so every row is judged the same way. 

### How many cars should a shortlist hold? 

A shortlist holds as many cars as you can compare carefully, and no more. Keep only rows you have checked and would still consider. Removing stale rows keeps the sheet readable and the comparison honest.
