Web Analytics Made Easy -
StatCounter

About me & history of Car Database

Teoalida’s Car Database was born from a major hobby for automobiles and pleasure for working in Excel and data analysis. It is one of MANY hobbies started during childhood and one of the FEW hobbies turning into business during adulthood.

This is mostly 1-man business. I (Teoalida) do data entry, web scraping, database updates, design my website, and also customer support via chat every day. I employ other people just for coding certain scrapers too complex for me.

After years of dedication I became the biggest data provider in automobile industry, given by numerous car databases offered for various regions of world, complete, accurate and frequently updated, plus other databases about geography, real estate and electronic products.

I am born in a family of engineers (read more on About me), I use AutoCAD since 1998 and in 2008 I started designing buildings, many people encouraged me to pursue a career in architecture, but this turned to be a bad experience due to difficulties in convincing people to pay my services, many idiots who want house plans for free, and in the rare cases when I was paid, it was one-time payment per project. I had little contact with people in IT and nobody ever told me that these databases can be a gold mine.

The hobby for cars started in 1999, since 2003 I use Excel to create an all-cars database, independently from the internet world (I connected to internet in 2005), manually entering data from the very reliable AutoKatalog car magazines from Germany (as seen in above video), making an original compilation that you cannot find anywhere else online (except on websites that purchased from me).

In 2011 I published my works for first time intending to share with other car hobbyists, but had the surprise to be visited by programmers, web designers and mobile app developers, working for various companies (car insurance, car parts shops, car shipping services, etc), realizing that I can make a business from this!

Due to poor website design and offering too much for free, plus data structure optimized for on-screen reading rather than for programming, I did not made any sale until May 2012. I had to do many changes to make it appealing for this unexpected audience, both in data structure and in website presentation, including moving in November 2012 to WordPress to have an eCommerce plugin where people can make payments and receive databases automatically, this helped me to have in each each month of 2013 more sales than whole 2012 year. I started updating databases regularly.

Most of these programmers have little experience in cars, some making mistakes such as buying wrong database, buying an American car database when they do business in Europe, or buying from other data providers just because their database is cheaper or have more rows, ending with bad quality databases with many missing models or incorrect data.

A new era started in 2015: web scraping. Previously I avoided to copy data from other websites, thinking that it means cheating, copyright issue, illegal way to collect data and creating non-original content, but most people have no issue with this, they do not care about buying someone’s original compilation and ask me specifically to create scripts that extract data from various websites and sell them CSV. Now I want to apologize to all owners of websites I scraped data from, but if I was rejecting these customers motivating that scraping is illegal, customers would go to other data mining companies or freelancers and obtained same data anyway.

In 2015 I sold approximately 100 databases, enough to quit my job of AutoCAD and architectural design, and dedicate my life to data providing industry.

Over time I realized that web scraping is not as dangerous as I though, since 2015 to 2018 I created additional 50+ databases, raising my income 5 times, including the best-selling car databases for America, India, Middle East, Australia, motorcycles database, real estate databases, mobile phones, etc. During 2018 over 500 people have paid me for databases.

Having high experience in automobile industry and few other fields, I carefully choose what websites to scrap data from, to maximize accuracy and data completion rather than largest number of car model variations as other people may do.

All databases made by me wear a signature: the very colorful Excel spreadsheets with borders in correct place (since 2013 I realized that majority of customers import data into MySQL instead of visualization in Excel, so the visual enhancements are useless), but they prove how much CARE I spend developing databases.

Just look at there metrics comparing with other car database providers
(you can check yourself on smallseotools.com)

Teoalida car database vs other data providers

Full story

The love for cars began in 1999, while walking to school I started counting car makes and number of cars for each foreign make. My list contained about 50, I omitted all american car makes as well as sport car manufacturers like Ferrari or Aston Martin since these were never seen on Romanian roads.

I was curious how many car makes and models exists, so I started collecting information. I had lack of sources of information, in first years my parents rarely bought me car magazines, also the car magazines show new launched models, rather than a worldwide list of cars models including historical models, like an encyclopedia. A friend gave me Auto Catalog 1997 (a car magazine released once per year, showing about 120 makes and technical data for about 2000 worldwide model versions).

I also have an obsession for making tables and statistics about everything. Since I had a computer, knowledge of Microsoft World and Excel, car magazines, and free time, I began writing my own automobile encyclopedia, to organize my knowledge about cars and fulfill my hobby of data analysis.

I started by writing in Notepad the list of car models (one TXT for each brand) sorted by manufacturer and car classes, with years of production (no technical data), to sort out the cars and understand which is the successor of which model. Later the TXT were combined in a single file Car Models List.DOC, additionally I made Car Models Timeline.XLS. Also I wrote a Car Body List for selected brands, because some successive models have different production years for each body style.

Early automobile encyclopedia made in Word

My dad taught me to use Microsoft Word and even set me rules how to write a nice book: body text with 12pt font, titles with 16-20pt font, centered, bold, underlined, etc. Writing about cars was my idea (I was writing also a geography encyclopedia, as well many other stuff).

My dad told me to finish my works and print them because “what is not finished have ZERO value“. I never understand why wanted to print… an automobile database is a thing that need to be updated constantly and cannot be “finished” to be printed.

My parents encouraged my hobby, printed few pages for me, and promised that some day will help me publishing a book, but this never happened. There is possible that they lied me intending to keep me BUSY at computer to prevent me disturbing their busy lives (instead of allowing me to make friends and be busy with a social life, as I wanted).

My access to information was limited, I was collecting data from all sources that came in my hand, sometimes copying articles word by word: AutoCatalog from Auto Motor si Sport and AutoSpecial from ADAC (copying technical data and model advantages/disadvantages), a Catalog of used cars (copying model history), monthly car magazines, etc. I wanted to include car photos too, but I had photos just with few cars in computer, and no digital photo camera to take photos.

The resulted encyclopedia was a MESS, no standard format across various car models and impossible to make it complete, because with limited access to information I did not know how many other engine versions of same model does exist. My car encyclopedia can be compared with Wikipedia (it also do not have a standard format across various car models), but mine had more tables than text, was printer-friendly, but most importantly, was 1-person work!

I wrote in this way about 80 car models on 200 pages, during 2 years (2-4 pages per model).

Download SAMPLE: Car encyclopedia made in childhood, what is your opinion? Probably a total MESS!

Since 2003 I broke away from what my dad taught me, for future works I used 10pt font, titles with full-width colored background (similar with the current theme of website), optimized for on-screen display rather than printing. Also started working more in Excel than in Word.

In same 2001-2003 I also made in Excel some tables with formulas… like a case study for selected car models. Also a database dedicated to sport cars, but today I do not see them so important to worth maintaining them.

I started in 2005 a new Word file, currently sold as Car Models Encyclopedia.

AutoKatalog, one of most reliable car publications in the world, is published yearly in Germany since 1957 and in other ~20 European countries during history, including Romania starting from 1996 under name AutoCatalog.

Started making automobile database in Excel in 2003

Probably the most important project was the Excel table with all car model variants displaying only 7 technical specs fields, based only on AutoCatalog and AutoSpecial, for faster data entry and clean-looking, currently sold as Car Models & Engines Database. Started in 2003, an experiment with just 100 model versions, but in school vacation of 2004 I decided to expand it to all cars, the first final version launched in January 2005 had 3600 car models produced from mid-1990s to present, but was still incomplete in case of non-European brands or SUVs as I was not interested in them.

I constantly updated it with new models (thanks to yearly releases of AutoCatalog), I also added older models (with less technical details) thanks to the internet connection and Wikipedia, reached 6000 model versions from 50 brands in January 2007 and 7800 models from 57 brands in 2009 edition, being complete database for European market.

Another project was Car Models Plus in both Word and Excel, started in 2005. Similar with earlier Car Body List, one entry per body style, plus some data about car dimensions and engine range.

The Word file, currently sold as Car Models Encyclopedia, with one paragraph per body style, a mini-encyclopedia compared with what I done in 2001-2003, with just FEW info about each car, written in a standard format, later turned in one paragraph per model for all car body styles.

It had an Excel equivalent, currently sold as Car Models Database, an Excel table with one row per body style, to compare cars over time.

Considering less important, they did not had any final complete version until 2010, when it reached about 500 car models produced in Europe. I added foreign imports in Europe in 2012 and at end of year the Car Models Encyclopedia reached 1200+ models on 160 pages, 4-10 models per page, when I realized that nobody is buying Word documents so I put ON HOLD future updates of Car Models Encyclopedia, concentrating on Car Models Database in Excel only.

I connected to the Internet in 2005

Gained access to Wikipedia and this allowed me to improve car databases, especially by extending historical coverage of Car Models List & Timeline towards World War II.

For a short moment I resumed working at the encyclopedia in Word, by adding older cars, this time getting inspired from Wikipedia, translating articles into Romanian, often writing with my own words and not direct translation. Shortly I abandoned that encyclopedia along with 80% of projects started in childhood, considering them useless as better products are available on internet. But I kept maintaining the car databases in Excel, as they had NO equivalent on internet.

Local friends praised my work (although some blamed me that I waste my life doing useless things) and one said that people are willing to pay money for such things and asked me why I do not post the car encyclopedia on internet?

Publishing on website in 2011 and doing first sales in 2012

In 2009 I created my personal website http://teoalida.webs.com/ to publish my works primarily my other hobby AutoCAD design field (2D and 3D models of building and cars).

In November 2010 I did a FULL update for 6 of the car database files and added them to my personal-portfolio website, under URL http://teoalida.webs.com/cardatabase.htm. I translated all Romanian into English (took just 10 min to find/replace all car terms in Car Models Encyclopedia, but rewriting introduction for every file took few hours).

I never not sold anything on internet (for money), but in the same time I did not wanted to give Car Models & Engines Database for free so I offered only a sample, being undecided whenever to sell and how to sell. I was waiting for some feedback.

A failed start:

  • I had huge knowledge about cars but zero knowledge about marketing.
  • I did not know what kind of audience my website have, and what database formats customers would be looking for.
  • I believed that my products have same target like car magazines: buyers of new and used cars, plus hobbyist studying automobile industry like me, but surprisingly, I got contacted by companies looking for vehicle database for commercial use.
  • I did not got any feedback for about 1 year, I became worried that I done a very BIG USELESS database and is better to abandon the hobby.

First feedback were like this “not what I needed though keep up good work“… but what they need?
Only after discovering a software to chat with website visitors in January 2012, I started getting significant feedback, I realized that the database was GOOD, but the presentation was BAD. While the rest of my website is aimed to architecture students and house builders (web amateurs), the Car Database page was visited by highly-skilled people, company managers and webdesigners who probably did not liked my cheap-looking website hosted for free under subdomain.

Mistakes done until April 2012:

  • Presentation like a BOOK, author info on first page. The Excel spreadsheets saved in Legend & About me sheet, people had to do extra clicks to see the Database sheet to realize that there IS a vehicle database, they may have been lazy and though that there are just biographies.
  • No prices were displayed, as well no BUY NOW or FOR SALE buttons, no wonder why people would not understand if I am selling or what the hell is this website…
  • No preview screenshots, text-only page, bounce ratio 75%, after adding the screenshot it reduced to 40%.
  • Offering too much for free: 5 files offered complete and 1 file “The BIG Car Database” was offered as one-brand sample, waiting if someone will contact me, to negotiate a price… 2-3 people contacted me but I refused the deal once they said that are buying “for their websites”, I wasn’t sure what they are doing, though that are publishing my Excel file on their website and I refused to sell them complete database.
  • Most customers weren’t looking for that big database with engines, but for car external dimensions, which was offered FREE but contained only cars produced in Europe as it was done for the purpose of research car evolution in Europe, instead of complete list of all cars sold (imported) in European market. Other customers were even looking for a simple make/model list in XLS or CSV for web development, which was offered FREE in wrong format, DOC optimized for reading/printing.

So, I updated the European car dimensions database with worldwide cars in April 2012 and put on SALE for a small price, after several days I made the first sale to an insurance company. Since that moment I started the constant updating…

During 2012, almost every buyer praised the database but criticized website presentation and gave me suggestions.

A successful business, decisive changes done in November 2012:

  • I moved to paid hosting and domain www.teoalida.com.
  • WordPress platform and Simple eCommerce plugin that allow people to pay and download digital products automatically.
  • Car Models List .DOC converted in XLS and put for sale instead of being given free, becoming the best-seller (I was surprised, I did not knew that people are willing to pay even for a DATAbase without (technical) DATA).
  • I bought a collection of german AutoKatalog 1991-2013 from eBay (I paid them with my own money made from several sales during six months of 2012)… I updated with new models but also backward updating with classic cars, making the most comprehensive database of cars produced last 20 years…
    I also made new databases, custom-made for individual customers, and the number of customers increased about 4 times.

Website redesigned in March 2013 further raised sales:

  • In late 2012 for the first time I googled and found that there are several other websites selling car databases, and got inspired to design my website in similar manner.
  • Installed a separate WordPress for Car Database section (URL remained the same), displaying on first page the products in grid layout with prices indicated, with buttons “Read more” going to individual pages of each database, also a FAQ section (as opposite of the previous single-page with a lot of rows of text and links to sample files, then “go in Store to buy full databases” (you can still see the old website design in http://teoalida.webs.com/cardatabase.htm).

Over time I was facing (and I am still facing) with the problem of insufficient feedback… LAZY people who, if they do not like a detail in the database, they go away instead of contacting me and requesting a change (probably many people think that I am just selling databases “as it is” instead of being the developer of database thus ready to make changes).

For example: Make | Model was originally on a single column, which pose no problem for a reader, but a programmer may not like it. As soon 1 customer bring this in attention, I separated Make | Model to 2 columns in December 2012. These changes helped to have in 2013 more sales per month than in entire 2012 year! If the first customers purchased it for reading in Excel, in 2013 about half of customers are webdesigners buying for importing CSV or SQL. By this way, when I moved to WordPress in 2012 I heard for first time about MySQL and realized that not all websites are made by static HTML as believed.

Expansion beyond European market – 2013

Car Models List included US automobile manufacturers, but did not included foreign cars imported in America, instead for Japanese manufacturers it included only models sold in Europe.

In January 2013, once a customer asked me for a database of cars sold in United States, with each year on separate row, I done an extensive research on Wikipedia and expanded my Car Models List making it complete for American market, with exact Model Years the car was sold in US.

Next project was to create a database of technical specs. I done a small experiment sourcing data from Edmunds website, writing it manually, but was overkill to do this for all 40,000+ car models. The salvation came from a customer who bought Singapore HDB Resale Flat Prices Database, he was a programmer so I told him to create a scraping script for Edmunds website, for FREE, in exchanging of giving FREE the database he purchased (refunded his purchase), but Edmunds is redesigned often, making his script obsolete.

Additional improvements that increased sale volume:

  • Changed plugin Simple eCommerce to Easy Digital Downloads (May 2015) and adding multiple price options to purchase small chunks such as 2000-present at smaller price, for people who do not need older cars 1945-present.
  • Removed product prices on home page and rearranging products (2015). Instead of putting the simplest and cheapest databases at top, I put the most detailed databases of Europe, America and India on 1st row. People had to click “more details” or image in order to see prices. While number of sales did not grew, monthly earnings grew because people went to purchase more expensive databases.
  • Wrote list of makes and list of columns included in each database (2015-2016), for people who are lazy to check this inside sample files (and also keywords for Google).
  • Added option to pay with credit card via 2checkout.com beside PayPal (September 2016).
  • Removed editing protection of sample Excel files (2016-2017). When you open a protected file in Microsoft Excel, you cannot edit it unless you go in Tools > Unprotect sheet and enter a password. But some non-Microsoft Office software ask user to enter password as soon you open it, or click “open read-only” which confuse visitors and they don’t open at all.

A new era: web scraping services – 2015

A new era started in August 2015 when I discovered www.import.io, a data scraping software which (at that times) was free (accounts made after April 2016 are limited to 500 pages unless you buy a paid plan). Although the software is free and theoretically you can scrap simple websites yourself, most people don’t have knowledge, or time to learn how to use it, so I am here to help you.

The first database made via web scraping was India Car Database, took about 1 week to figure out how to create it using import.io. The funny thing: one of the 3 indians who contacted me during that week and I informed what I am doing, though that I created Indian database because of his request, so requested me making additional databases of bikes too and other vehicles. For moment I refused, because I did not wanted to waste time on projects outside car field.

In November 2015 I recreated American Year-Make-Model-Trim-Specs allowing me to update it myself by using import.io extracting car specs from each URL although require to manually compile list of URLs of all cars, I also created other databases Singapore Condo Database (source: SingaporeExpats.com), Skyscrapers Database (source: Emporis.com).

Moreover, in November 2015 I allied with a programmer student from Pakistan to create scraping software for websites that are too complex for import.io.

Once I mastered scraping skills in 2016, I decided to offer freelance web scraping services, allowing me to serve people asking for specific data that I do not have, by quickly creating a new custom database scraping data from a website chosen at mutual agreement, even if just 1 person demand that particular data, once created I published database on website allowing future people to purchase ready-made (unless customer asked for a non-disclosure agreement).

Import.io turned to a paid service in April 2016 and suspended my free account in September 2016, I was ready to buy a paid plan although quite expensive. This gave idea to Pakistan programmer to create own universal scraping software in VB.NET for my own use, which turned to be faster and better than import.io, able to scrap multiple websites at same time without slowing down each other, allowing me to create even more databases and update them more often.

 

Other automobile data providers on internet do not even specify source of data, never mind of author info.
I am not sure if this About Me story will make you more willing to purchase a car database from me, or not, but…

…what is your opinion? Leave comments!

90 comments

1 ping

Skip to comment form

    • HOTROD on August 31, 2011 at 4:37 pm
    • Reply

    AWESOME LIST MAN. NOT WHAT I NEEDED THOUGH KEEP UP THE GOOD WORK

    1. So what you were looking for, more exactly?

    • Rene on November 28, 2011 at 10:05 pm
    • Reply

    Car dimensions database is not working. would you please send me a copy of your xls to [email protected] ?

    1. THANKS FOR REPORTING… I checked all 6 links and 2 were broken, one lacked “.doc” at end of URL and one ended in “.XLS” rather than “.xls”, can’t believe that CAPS matters in links. Solved now!

        • patrick on July 8, 2014 at 7:35 am
        • Reply

        hello,

        I also am looking for an updated car dimension database please ( 2010 to 2014/2015 models)

        How can i acquire it?

        Patrick

        1. Do you previously purchased the database and you’re asking for updates? Tell me your email used at purchase so I can search in Paypal.
          Or if you are new customer, are you asking if I can put for sale a “New cars only” 2010-present, instead of full database 1945-present? Yes I can do!

            • patrick on July 17, 2014 at 7:51 am

            Sorry for the late reply

            I am new customer and looking for 2010-present

            I need specifically:

            Footprint ( Width and track length)
            Weight
            Fuel economy

            Please contact me on [email protected]

    • fawzi on April 18, 2012 at 7:44 pm
    • Reply

    Hi,
    I am interested in seeing your final database.
    would it have MPG, MSRP and images as well?

    1. No idea what is MSRP. Consumption is in european-style litres/100km rather than miles per gallon. Images in an .XLS file would be not right, currently I am in doubt if I should add images in Car Database List.DOC file and how.

        • fawzi on April 20, 2012 at 5:51 pm
        • Reply

        MSRP is manufacturer suggested retail price.
        MPG can be converted from L/100km.
        Images in an excel is not a good idea, but if the xls is moved into a database, then images are possible in two ways: either include as a filename with the actual files in a separate directory. or include the actual images in the database itself. i am not skilled enough to know where the cutoff is in terms of image size and the tradeoff in separating it out.

        1. Years ago I wanted to include prices too, but now I know that they vary from country to country, people from other countries will accuse me that prices are wrong! I have no idea where to get manufacturer suggested prices. USA not only uses MPG but also different formula city/highway to calculate consumption. What kind of database are you trying to make?

  1. Many thanks to Fawzi for all suggestions, although I couldn’t help him because he is American and my database shows European market.
    We talked on the website chat…… now I visually-improved my database. For example, he though that “Fuel litres” is the gas tank, now I wrote “Fuel eff l/100km” for better understand.
    I saved the XLS files in Database sheet rather than Legend sheet, probably some people didn’t know that a Excel file may have multiple sheets, they saw only the legend (introduction), and though that I sell nothing?
    Added image preview of Excel table, visitors can see that there IS a car database (and not just a text-only page) without clicking any link.
    Hope to get friends (or buyers) like Fawzi!
    Please leave your opinion!

    • Ioannis on August 31, 2012 at 11:36 am
    • Reply

    Great support and well made car database especially for the european cars made in last two decades that I was interested!! I initially bought another database for 5 times as much and it was full of mistakes, got a refund next day. Teoalida’s database was great, some minor missing data he completed immediately and sent me the new file! Thanks for the good work at this unbeatable price!

  2. Until November 2012 this page was at teoalida.webs.com/cardatabase.htm.
    All the above comments have been copied from the old website.
    All the below comments are left by visitors of this website.
    If you do not trust that, feel free to visit the old website and check the comments’ date. on Webs.com the admin cannot edit comments, can only post and delete them.

    • John on January 10, 2013 at 10:38 pm
    • Reply

    Thanks! The database looks great, it will help us a lot!

    • anthony on January 30, 2013 at 5:21 pm
    • Reply

    Thanks a lot for sharing these informations about cars , it s such a useful and nice designed web site , thanks…

    • Damir on February 1, 2013 at 12:55 pm
    • Reply

    I was searching for EU cars database for a week and got random vendors offering me various data. By sheer chance I stumbled upon this site and got interested because I could download sample .xls files and see what I would get.

    Plus, owner came online and chatted with me, answered all my questions and offered great advice on PS to KW conversion. Bought the database via PayPal and at first mail with link to database didn’t come through. Owner immediately agreed to send file to another email account (non paypal) and I got the database within seconds.

    All in all, whole experience was exceptional, the database is great and easy to work with + I got everything I needed + more for great price!

    If you need car database, this is the place to buy! (owner can rearrange data for you if you really need it)

    • isik on April 7, 2013 at 1:30 am
    • Reply

    hello, do you have a database for wiper size for every car/suv make and model?

    also do you have a database for brake pads model for every car make and model?

    thank you.

    1. I have nothing about CAR PARTS, sorry, I have about cars as whole.
      Also I have no idea (but you made me curious) how does such database should look and what details it could have about each part?

  3. I have been looking for similar information as the Car Models Timeline and perfectly found what I needed here.
    This information has been very valuable for my research in the automotive industry.
    To learn about the product range of the different car brands .

    Thank you very much for this great website and rich source of information regarding the car databases!
    Keep up the good work and please continue like this.

    • robert on May 15, 2013 at 7:04 am
    • Reply

    Hello I bought the world list, but the link came in email is not working. you could send it to me. thanks

    1. Thanks for forwarding me the receipt.
      The link WORKS but it saves a 0-byte file… that’s STRANGE!!
      That’s why I am online everyday. I emailed you the file.

      1. SOLVED! Today I was playing around FTP by curiosity and I found a TEMP folder with the 0 bytes files, The eCommerce plugin create at purchase a temporary copy of the file and delete it after you download it. But the files were wrongly copied and were downloaded multiple times without being deleted. Many customers but only the customers of Worldwide Car Models List and EURO Car Models List were affected. The rest of databases worked fine and this put me in confusion what is the cause of problem. I have deleted now the 0-byte copies.

Leave a Reply

Your email address will not be published.