Coverage: cars, trucks, SUVs and vans sold in United States from 1990 to present, last release: 26 May 2023, including 2774 “2023 models” and 112 “2024 models”.
The BIG database
Download free SAMPLES:
Year Make Model Trim .XLSX (5 columns)
Year Make Model Trim Basic Specs .XLSX (32 columns)
Year Make Model Trim Full Specs .XLSX (120 columns)
Alternative file formats: CSV and SQL.
Buy complete database + FREE updates (every 2 months) for one year:
The small databases
For startups who do not need a huge database with 60,000+ rows for every trim, I offer small databases limited to 1 row per nameplate, model and body style, without trim. Note: car images are by model, NOT by body style. Example: BMW 3-Series can be sedan, wagon, coupe, cabrio, photo URL is the same for all 4, showing one body style at random.
Download free SAMPLES:
Make-Model (2 columns)
Year-Make-Model-Image (5 columns)
Year-Make-Model-Body-Dimensions (15 columns)
Buy complete database + FREE updates for one year:
This one have fewer columns, but extra rows indicating optional engine/transmission for certain trims.
Download free SAMPLE:
Year-Make-Model-Trim-Engine (9 columns)
Buy complete database + FREE updates for one year:
Custom / partial database
Contact me for a quote if you want to buy custom selection of columns, makes, years, or body type. Custom subsets won’t let you download updates unless you ask me to send you updates, but are good for one-time use, for example to decide what used car to buy, or academic project.
Electric/hybrid subset I added in 2019 once few customers contacted me saying asking for subset because their business do not deal with internal combustion engines, but this seems to cause confusion now, some people thinks that first 6 packages are only for gasoline cars and contact me to ask if should buy 2 separate databases to get all cars. WRONG, original 6 packages contain ALL cars including electric ones.
See also: Analysis of American cars evolution 1990-2023.
Looking for pre-1990 cars? You can use Year-Make-Model (1945-present, no trims or specs). However, I am interested to make a specs database with older cars, for my personal research and to sell Excel to businesses dealing with older cars. Show me a website with longer historical coverage, that include at least car engine size, power and dimensions, and I may create a new database for you!
American car database coverage
Year-Make-Model-Trim-Specs is the best car database for people angry when a popular API closed in 2018 or tired of CarQueryAPI’s missing cars, I sourced most fields from most famous American car website, added 4 extra fields by myself, did few improvements in model hierarchy and created an Excel database with completeness and accuracy having no equivalent on internet. Full changelog.
Complete for all cars, trucks, SUVs and minivans sold in United States from Model Year 1990 to present. Canada-specific cars are NOT included in this database because it focus on US (Canadian cars are included in Year-Make-Model based on Wikipedia). If you are not from USA and want to use this database in another country, see list of models to determine.
Italic makes start at MY 2001 (European exotic manufacturers). They apparently changed source of data from MY 2001 onward. Specifications are consistent before and after but certain info is available starting from MY 2001 and hierarchy is different, for example Mercedes C43 AMG was listed as separate model until MY 2000 and as trim under C-Class for MY 2001. I manually improved hierarchy to fix these issues.
Cars are sorted by make and model alphabetically, by year new to old, then by trim from low to high. Feel free to re-sort models or years, avoid re-sorting trims when importing in your application.
66 car makes included
American domestic: AM General, Buick, Cadillac, Chevrolet, Chrysler, Dodge, Eagle, Fisker, Ford, Geo, GMC, Hummer, Jeep, Karma, Lincoln, Lucid, Mercury, Oldsmobile, Panoz, Plymouth, Pontiac, Ram, Rivian, Saturn, Tesla.
European imports: Alfa Romeo, Aston Martin, Audi, Bentley, BMW, Bugatti, Ferrari, Fiat, Jaguar, Lamborghini, Land Rover, Lotus, Maserati, Maybach, McLaren, Mercedes-Benz, Mini, Porsche, Rolls-Royce, Saab, Smart, Spyker, Volkswagen, Volvo.
Asian imports: Acura, Daewoo, Genesis, Honda, Hyundai, INFINITI, Isuzu, Kia, Lexus, Mazda, Mitsubishi, Nissan, Scion, Subaru, Suzuki, Toyota, VinFast.
Data fields included with % available
Percentages calculated at 1 October 2022 update for 2001-2023 model years (54310 trims, out of 67032 total trims 1990-2023), because italic fields are NOT available for 1990-2000 models and would have screwed up percentages, while most customers deal with cars 10-20 years old max so don’t care about missing data in older cars.
Data extracted from JSON files:
Naming: ID 100%, Make 100%, Model 100%, Year 100%, Trim 100%, Trim (description) 100%.
Price & colors: Base MSRP 81.02%, Base Invoice 77.43%, Colors exterior 96.80%, Colors interior 83.83%
Dimensions and weight: Body type 100%, Doors 100%, Total seating 80.95%, Length 99.64%, Width 97.33%, Height 98.41%, Wheelbase 99.79%, Front track 41.46%, Rear track 41.34%, Ground clearance 64.18%, Angle of approach 27.72%, Angle of departure 27.74%, Turning circle 85.86%, Drag coefficient 16.44%, EPA interior volume 34.18%, Cargo capacity 65.09%, Maximum cargo capacity 44.36%, Curb weight 89.65%, Gross weight 56.36%, Maximum payload 48.45%, Maximum towing capacity 54.73%.
Engine and transmission: Cylinders 99.18%, Engine size 99.19%, Horsepower 99.72%, Horsepower rpm 98.04%, Torque 98.57%, Torque rpm 97.49%, Valves 80.28%, Valve timing 60.16%, Cam type 80.28%, Drive type 100%, Transmission 99.22%.
Fuel and mileage: Engine type 99.98%, Fuel type 99.45%, Fuel tank capacity 98.31%, EPA combined MPG 84.29%, EPA city/highway MPG 84.06%, Range in miles (city/hwy) 99.22%, EPA combined MPGe 1.40%, EPA city/highway MPGe 1.13%, EPA electricity range 1.05%, EPA kWh/100 mi 0.99%, EPA time to charge battery (at 240V) 1.00%, Battery capacity (kWh) 0.52%.
Interior dimensions: Front head room 93.67%, Front hip room 76.35%, Front leg room) 92.88%, Front shoulder roomn) 90.80%, Rear head room 81.50%, Rear hip room 66.40%, Rear leg room 80.96%, Rear shoulder room 79.47%.
Warranty: Basic 80.56%, Drivetrain 80.39%, Roadside 75.31%, Rust 80.29%.
Data extracted from Review pages:
Review: Source URL 100%, Image URL 99.98%, NHTSA Overall Rating 17.52%
Description: Review full 83.19%, Review 1 4.25%, Review 2 4.25%, Review 3 4.23%, Review 4 4.25%, What’s new 10.68%, Pros 85.94%, Cons 84.54%.
Scorecard: Overall 15.74%, Driving 8.08%, Comfort 8.00%, Interior 8.12%, Utility 7.71%, Technology 5.88%.
Expert rating: Our verdict 8.58%, Driving 8.55%, Comfort 8.56%, Interior 8.55%, Technology 8.56%, Storage 7.64%, Economy 3.31%, Value 8.57%, Wildcard 8.58%.
Data extracted from HTML pages (not available for cars launched after March 2020):
Old naming: Trim 88.88%, Description 88.88%, Images URL 73.74%, Suspension 69.52%.
Interior features: Front seats 69.87%, Rear seats 59.87%, Power features 69.60%, Instrumentation 69.71%, Convenience 69.83%, Comfort 69.47%, Memorized settings 18.65%, In car entertainment 69.69%.
Exterior features: Roof and glass 69.79%, Body 21.95%, Truck features 23.61%, Tires and wheels 69.88%, Doors 21.11%, Towing and hauling 40.88%.
Safety: Safety features 72.46%.
Optional features: Packages 35.75%, Exterior options 39.58%, Interior options 39.25%, Mechanical options 27.22%.
Bonus data (added by me):
Domestic / imported 100%, Country of origin 100%, Car classification 100%, Platform code / generation number 100%, Date added 100%.
I noticed that it’s hard to find your site in google, i found it on 25th spot, you should get some quality backlinks to rank it in google and increase traffic. I had the same problem with my blog, your should search in google for – insane google ranking boost – it helped me a lot
What was your Google search? I am #1 for searches like “Car database Europe” or “Excel car database“. I was #1 for a lot more keywords but since 1 month ago my website is under a penalty from Google. I am 100% sure that sooner or later penalty will be removed and rankings restored.
Please add weights to car dimension database
You would be the first one interested in dimensions and weights but nothing else.
I CAN add weights range as I did for European database. Would be this OK for you? Car weight vary depending by engine, transmission, drivetrain, if you want weights for individual versions you may buy the detailed BIG database.
Yes, like you did for the European database would be fine. I don’t need exact for every option, just a roundabout figure. Also, could you make it for MySQL as well?
When do you need the database ready? I am busy in multiple projects so can’t work full-time to cars, but I hope to finish it this month, and your weight request will take few additional days of full-time work.
If I make it MySQL then how I can manage and update it? I make it XLS and if you want, I export it as CSV, import in phpMyAdmin, export as SQL, send it and you tell me if it works well… never did this before.
OK, just post when it’s finished and I wil test it for you.
congratulations for your products. Unfortunately, I believe you do not have a similar for Latin America Region, right?
The data should contain automakers, number of cars produced or imported per year from 2000-2014 (actual volumes) including tire sizes and speeds.
Would be great if you have something like that. Do you?
The above North American databases do not have tires at all.
Meanwhile I have tires in the European database, that is NOT SIMILAR with above North American databases but it is slightly more suited for you, I can expand it by adding cars produced in Latin America, but I will not able to provide accuracy for cars imported in Latin America.
ALSO I will be never able to get data about number of cars produced, even less number of cars sold in your particular country, even less the forecasts.
Does your data have jeeps and harleys?
Jeep is in database, Harley-Davidson don’t produce cars.
I’ve been searching for a complete list for a affordable price for a long time. I finally found this database. It is complete and accurate. along with excellent customer service this is a win win.
This is a awesome website with some awesome info
Are you interested in car databases or you post comments to SPAM backlinks to GSMArena?
Thanks for providing this service. It’s been more reliable than the last database that I tried.
I did want to comment on one little detail I found. The model column in the spreadsheet is configured to be a “General” format. Because of that, the cells are supposed to self-discover what kind of data is inside each one. It turns out that this behavior interferes with a SQL Server import. Basically, any field with a dash and a number such as “CX-5” will blank itself out during import into my SQL database. The fix I found is to change that whole column to a “Text” field in Excel prior to import.
I was wondering if in future updates you could actually set that column as a Text field? It might save others the confusion in the future.
Other than that it’s been working great for me.
I done over 50 sales last year and you’re the first person who report this problem. OK, I can change it to text when releasing next update. But how is possible that cells like CX-5 to blank itself? BTW, did you received today update?
I checked your website and does not seems to use my database, it have lots of wrong model names especially in BMW and Mercedes, what happened?
I’m not really sure why it happened but the import feature in SQL Server Management Studio seems to be picky. I imagine most of your customers are using free and open source databases and probably aren’t running into the same problem.
As for my website, a lot of the cars came from my previous subscription to a different service, which clearly had some problems with it. I’ve tried to merge the data so as not to leave broken links behind but I’m still working on it.
Thanks for reminding me about the weird BMW and Mercedes models. I can go ahead and delete those.
And yes, I did receive the update. Thanks for that. I’ll probably be importing it next weekend.
Personally, I like the design of your website. It is simple, straight forward, and to the point. I appreciate you compiling a custom version of your car spreadsheet for me. This is my first time being your customer, I’m very impressed by the detail of the information you provided. I look forward to doing further business with you near years end.
It’s John from ShipMyAuto.com. Like we spoke via email – we need an update for our current DB table.
It is great to hear that business is doing well.
As you know, we are using the 50 column format which means the 27 column format would require us to rewrite code.
The 81 column format is more than we need – we only need the 50 columns like the previously format.
So, it looks like we need to buy the 81 column format.
We are ready to purchase. Please send a payment request and a download link once we pay.
You can send the request and invoice to [email protected]
Question: Do you have any data for motorcycles or boats?
I added 27 and 83 columns packages in May 2016. The 51 column package remained for sales by end of year without getting any more sales because people tend to choose biggest package unless they need just Basic specs, this is why I deleted it. I can sell you a custom package with extra columns removed but I suggest to buy a standard package if you want to be notified automatically about updates.
I created database for motorcycles too, see menu. For boats tell me a website to scrap data from and I will create a new database.
I first bought the carquery database/API… My developer could not get it to work to show US makes only… I emailed them several times and the never replied to me… I bought the same product from Teoalida and it works great, and when we had a question he responded to us very promptly…
Thank you Teoalida,
Hello I’m looking for vehicle vin decoder in excel format