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 scrapers.
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 files with borders in correct place (since 2013 I came to conclusion that majority of customers import the database into MySQL instead, so the visual enhancements for Excel visualization are useless), but they prove how much CARE I spend developing car databases.
Just look at there metrics comparing with other car database providers
(you can check yourself on smallseotools.com)
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!