Laptop & desktop computers database

Download free SAMPLES:
Laptop Computers Database.xlsx
Desktop Computers Database.xlsx

Buy complete database + FREE updates for 1 year:

Don’t forget to check other databases made by me (100+ databases).

Computer brands included

Desktop brands included: Acer, Alienware, ASUS, bluechip, DELL, Fujitsu, Hiditec, HP, iiyama, Intel, ISY, Lenovo, MEDION, MSI, Samsung, Shuttle, Zoostorm.

Laptop brands included: Acer, Alienware, ASUS, DELL, Dynabook, Fujitsu, Gigabyte, HP, Huawei, Lenovo, LG, MEDION, Microsoft, MSI, Samsung, Sony, Thomson, Toshiba.

TV brands included: LG, Philips, Samsung, Sony.

Earliest laptop included is from 2006 but only 1178 models are included for 2006-2016, compared with 6046 models released 2017, 16557 models released 2018, 26511 models released 2019, 14929 models released 2020, 678 models released 2021. Desktop database don’t indicate release date to determine historical coverage.

Computer specifications included

Laptop database have 247 fields of specifications, grouped by 21 categories according source website: Naming (7 fields), Main specs (7 fields), Design (12 fields) Processor (15 fields), Memory (9 fields), Display (16 fields), Graphics (16 fields), Storage (15 fields), Optical drive (25 fields), Networking (12 fields), Ports & interfaces (19 fields), Audio (9 fields), Camera (11 fields), Keyboard (9 fields), Performance (6 fields), Software (7 fields), Battery (8 fields), Weight and dimensions (8 fields), Power (6 fields), Security (6 fields), Others (24 fields).

Desktop database have 266 fields of specifications, source website did not had any grouping so I tried to group them myself in similar fashion with laptops database.

Both source websites may have additional fields of specifications available for just a small number of laptops and desktops. I will check them deeper when I will be less busy and add next time I update databases.

History

Since I made in 2016 a very complete and accurate Mobile Phones Database sourcing data from gsmarena.com website, several people asked me if I can make a database of laptops or computers.

This is a trouble: while each phone model have certain specifications, and we have websites like GSM Arena which shows all phone models from most popular manufacturers from 1994 to present, laptop manufacturers produce them with a lot of different specifications under same case, and allow you to further customize them before ordering. Laptops can also be customized aftermarket by anyone.

For example: I was myself looking for a laptop of older generation that support Windows XP but not too old to be powerful and have FULL HD screen. I realized that HP EliteBook series was one of the latest laptops with Windows XP support until xx70 generation launched in 2012. While looking on OLX I found multiple sellers and had to ask each one for specifications. I bought an HP EliteBook 8770w which can be found with 3 screen options: 1600×900 TN 1920×1080 TN, 1920×1080 DreamColor IPS, multiple processor options: i5 and i7, RAM memory from 8 to 32 GB, default HDD is 500 MB but the one I bought had 1 TB HDD, and so on. Probably few hundreds different combinations of components under SAME name: Elitebook 8770w.

I could not find a reliable and complete website to source data from, and I was afraid that regardless where I source data for laptops, the resulted database risk having poor accuracy (not matching the specifications of laptops available for sale on other websites).

For a moment I was thinking whenever is useful to make a database of individual computer components rather than whole computers?

Examples (made in 2019):

In november 2020 a customer sent me this message:

Offline Message left on 26 Nov 2020, 05:21 AM (GMT+0)

Hi I would like to scrap desktop and laptop data from https://www.laptoparena.net/ and https://desktopfind.com/ Do let me if thats possible and the price . Thanks

I published on 8 Decemeber 2020 a desktop database with 266 columns and laptop database with 247 columns. I opened few laptops with many data fields, wrote xPath codes for all them, then ran scraper on all laptops and used Excel formula to find products with most data fields and check them for possible additional data fields. I ran scraper 3 times. I cannot guarantee that I included all possible fields, been already spending 3 days on this project and I had many other projects on TO-DO list.

In March 2021 a friend gave me idea of Excel formula + scraping that helped me to find missing data fields faster. I realized that for desktops there are at least 580 unique field names, and for TVs 657 unique field names. In case of laptops I could not count because Excel CRASHES due to file size.

What I can do now:

1. change database format, instead of 1 row per product, into 1 row for each specifications (100 rows in average for each product), so all specifications will be shown in 2 columns only: field label and value
3. pay extra $100-200 to my programmer partner (for each website, laptops, desktops, TVs) to make a custom scraper that automatically identify specifications available and create a column for each (this means that columns risk to be shifted each time I re-run scraper in the future to update database, will be this a problem for you?)
2. keep adding manually columns (xpath) for each specification available (this will take most effort, especially to make sure columns are displayed in same order like in source website, and maintain order at each future update)

I choose option 3 for moment, publishing an update in April 2021 (8296 desktops, 65961 laptops, 4401 TVs), with rest of fields to be gradually added in future updates.

Update 25 June 2021 (8715 desktops, 71478 laptops)

4 thoughts on “Laptop & desktop computers database”

  1. I do not understand your question and why did you said “yes correct” when I asked you to give me a website link?

    Chat started on Monday, April 06, 2020 12:20:25 PM

    (12:20:25 PM) *** Visitor 43145114 has joined the chat ***
    (12:20:27 PM) Teoalida (site owner): Hello visitor from India, are you looking for a specific database? Let me know if I can help you!
    (12:21:28 PM) Visitor 43145114: can get to know the database where i can find release year of all laptops from year 2010 to 2020
    (12:21:40 PM) *** Teoalida has joined the chat ***
    (12:21:42 PM) Teoalida: which database?
    (12:22:07 PM) Visitor 43145114: Like Gsmarena site have many info of mobile phones and Tablet PC.
    (12:22:30 PM) Visitor 43145114: where i can find the release year of all mobile phone and Tablet PC.
    (12:22:40 PM) Teoalida: so do you know any website similar with GSM Arena but for laptops?
    (12:22:49 PM) Visitor 43145114: yes correct.

    (12:22:53 PM) Teoalida: give me link, I am also interested so I can create an Excel database based on it
    (12:23:31 PM) Teoalida: without such website, I will need to use Wikipedia pages like https://en.wikipedia.org/wiki/HP_EliteBook
    (12:23:39 PM) Teoalida: this indicate laptop model names and release year
    (12:23:55 PM) Teoalida: but since page format vary from brand to brand, is impossible to compile data into ONE Excel table automatically
    (12:24:14 PM) Teoalida: and doing manually would take too much effort for the potential $ earnings from selling database
    (12:28:52 PM) Teoalida: beside release year you don’t need other specifications? these specifications are next trouble because they vary between laptops with SAME NAME
    (12:34:09 PM) Teoalida: see all databases I made so far https://www.teoalida.com/database/index … maybe you find others interesting too
    (12:38:03 PM) *** Visitor 43145114 has left ***

  2. hi,

    do you have any one can implement this database Laptop computers, 55616 models from 18 brands, 247 columns (full specs) – 300.00 USD in my website and to ensure the final product will be exactly the same as the original website

    1. I am also looking for a trusted and not too expensive web developer partner who can help customers LIKE YOU who don’t have a developer “in house”, and pay me a commission for each customers referred.

      I get 5-10 emails / day from Indian web developers that say that create websites as low as $200 but those “developers” spamming emails at random addresses are usually not trusted or skilled, they FAIL if you hire them for something more complex that a personal blog or 5-pages small business website. If you search “web development” on Google you will find popular companies who offer ridiculous expensive services. The key of success is to find someone “in the middle”.

Leave a Reply

Your email address will not be published. Required fields are marked *