Web Analytics Made Easy -

Mobile phones database

If you are looking for a database of mobile phones specifications in Excel format to create a website, use in a GSM shop or anything similar, I created an Excel database for you using a scraping software to extract data from www.gsmarena.com.

Download SAMPLE: Mobile Phones Database.xls.
LITE version include 7 columns: Brand, Phone, Notes, Image URL, Technology, Announced, Status. Instant download (example email).

Buy complete database + 1 year of FREE updates every month:

Buy & download

DO NOT ask for phone numbers database. I do not support telemarketing / SMS spamming. Please check above sample Excel file and watch video below to understand what I sell before wasting my time asking things that I don’t sell (like this guy).

Looking for digital cameraslaptops, TV, and other electronics? Suggest websites where I can extract data and create databases!

Mobile phone database coverage

The mobile phone specification database include classic phones and smartphones, tablets and smartwatches, from most popular phone brands in western world. There may be missing brands especially from China which have a lot of brands totally unknown outside their domestic market.

Earliest phones included are Ericsson models launched in 1994, but I guess that some early phone models are missing, as number of gadgets launched per year is significant only after 2003. See changelog.

114 mobile phone brands included

Acer, alcatel, Allview, Amazon, Amoi, Apple, Archos, Asus, AT&T, Benefon, BenQ, BenQ-Siemens, Bird, BlackBerry, Blackview, BLU, Bosch, BQ, Casio, Cat, Celkon, Chea, Coolpad, Dell, Emporia, Energizer, Ericsson, Eten, Fujitsu Siemens, Garmin-Asus, Gigabyte, Gionee, Google, Haier, Honor, HP, HTC, Huawei, Icemobile, i-mate, i-mobile, Infinix, Innostream, iNQ, Intex, Jolla, Karbonn, Kyocera, Lava, LeEco, Lenovo, LG, Maxon, Maxwest, Meizu, Micromax, Microsoft, Mitac, Mitsubishi, Modu, Motorola, MWg, NEC, Neonode, NIU, Nokia, Nvidia, O2, OnePlus, Oppo, Orange, Palm, Panasonic, Pantech, Parla, Philips, Plum, Posh, Prestigio, QMobile, Qtek, Razer, Realme, Sagem, Samsung, Sendo, Sewon, Sharp, Siemens, Sonim, Sony, Sony Ericsson, Spice, TECNO, Tel.Me., Telit, Thuraya, T-Mobile, Toshiba, Unnecto, Vertu, verykool, vivo, VK Mobile, Vodafone, Wiko, WND, XCute, Xiaomi, XOLO, Yezz, Yota, YU, ZTE.

Mobile phone specifications included

Database include 85 columns, each one having the following completion percentages (as 1 August 2019 update):

Naming: ID 100.00%, Brand 100.00%, Phone 100.00%, Notes 34.57%;

Images: Picture URL small 100.00%, Picture URL big 80.02%, Fans 100.00%, Hits 100.00%, Hits % 100.00%;

Network: Technology 100.00%, 2G bands 100.00%, 3G bands 60.73%, 4G bands 26.41%, 5G bands 5.73%, Speed 61.01%, GPRS 41.49%, Edge 41.57%;

Launch: Announced 99.84%, Status 100.00%;

Body: Dimensions 99.78%, Weight 99.06%, Build 7.72%, Keyboard 7.26%, SIM 99.99%, Other 12.49%;

Display: Type 99.96%, Size 87.46%, Resolution 87.46%, Multitouch 0.00%, Protection 18.62%, Other 29.37%

Platform: OS 61.37%, Chipset 48.45%, CPU 60.66%, GPU 47.28%;

Memory: Card slot 100.00%, Phonebook 37.94%, Internal 81.92%, Call records 37.18%;

Main Camera: Single 81.98%, Dual 4.30%, Triple 0.94%, Four 0.15%, Features 52.61%, Video 86.65%;

Selfie Camera: Single 51.74%, Dual 0.79%, Triple 0.02%, Four 0.00%, Features 9.09%, Video 12.34%;

Sound: Alert types 25.37%, Loudspeaker 100.00%, 3.5mm jack 100.00%, unnamed 26.50%;

Comms: WLAN 99.97%, Bluetooth 99.98%, GPS 99.69%, NFC 11.40%, Radio 99.09%, USB 90.66%;

Features: Sensors 58.04%, Messaging 38.62%, Browser 37.95%, Clock 5.02%, Alarm 5.02%, Games 37.96%, Languages 2.86%, Java 38.06%, Other 58.36%;

Battery: Battery 99.97%, Charging 8.85%, Stand by 70.40%, Talk time 73.43%, Music play 7.76%;

Misc: Colors 93.77%, SAR US 21.46%, SAR EU 25.00%, Price group 60.42%;

Tests: Performance 60.42%, Display 6.49%, Camera 7.95%, Loudspeaker 9.37%, Audio quality 8.54%, Battery life 6.26%.

Indian mobile phones

This page has been getting significant traffic from India, with many people contacting me but refusing to buy above worldwide mobile phones database and asking me if I can create another mobile phones database with only models currently sold in Indian market. Job done in 2018!

I sourced data from 91mobiles.com, this website have 10 category of products, such as Tablets, Cameras, TVs, Home Theaters, Smartwatches, Washing machines, Air conditioners, Refrigerators, Microwave oven, but I do not intend to scrap all categories and create databases for each, because would take a lot of time to regularly update each of them, for their sale volume, they will become products sell-able only in India and we all know how little indians pay, if people from western world contact me if they are able to make a purchase, many indians contact me regardless they are willing to pay or not, and just few leads actually convert to sales.

In April 2019 I paid a programmer to make a custom scraper for 91mobiles.com that can get discontinued phones too, , but the file resulted is 150 MB full of spaces and line breaks and I am not able to clean it because while I can open with Excel, it crashes when I try to edit and clean it, due to file size.

It took 20 hours to scrap 18k phone models (compared with 1 hour to scrap GSM Arena’s 9k phone models), and because in 1 year, only 3 people purchased India phone database (compared with 20+ who purchased worldwide phone database), I decided to STOP updating this database, to focus on other databases with higher sale volume.

Download SAMPLE: India Mobile Phones Database.xls.

Buy FULL database + 1 year of FREE updates at request basis:

Buy & download

How the Excel phone database can be used

Filter the mobile phone database and get a list of mobile phones having specific features.
Filter the mobile phone table by year and make list of features introduced in each year of history.
Analyze data and make statistics what are the best phones in each price range.
Convert Excel spreadsheet to CSV or MySQL and create your own phone comparison website or mobile app.

Actually I do not recommend using this database in making websites. Feel free to use it for research and analysis purposes. I am NOT responsible for any copyright troubles you may face if you use their data commercially, making own website, etc. This is NOT an original database “Made by Teoalida”, but rather a database showcasing abilities of data scraping, and the data belongs to www.gsmarena.com. Please consider the price a fee for data scraping service from website rather than author of data.

Mobile phones specifications database


11 pings

Skip to comment form

    • Tom on January 10, 2017 at 6:05 pm
    • Reply

    Thanks! Database seems to be what we just needed!

  1. Hi Dear,
    Thanks for your good job. But I have some query should I ask here?

    1. Ask directly any query you have. Or you posted comment just to SPAM a backlink to your website?

  2. Does anyone knows what does mean ERD? I lost a customer because didn’t understood him

    Chat started on Monday, April 10, 2017 11:37:04 AM
    Country: Pakistan

    (11:37:04 AM) *** Visitor 83172926 has joined the chat ***
    (11:37:06 AM) teoalida: Hello from website admin… are you looking for a specific database? you are welcome for a chat!
    (11:38:14 AM) Visitor 83172926: hey
    (11:38:20 AM) *** Teoalida has joined the chat ***
    (11:38:22 AM) Teoalida: what’s up
    (11:38:33 AM) Visitor 83172926: i need a database of mobile spec
    (11:39:17 AM) Teoalida: This is what I offer
    (11:39:25 AM) Visitor 83172926: what ?
    (11:39:39 AM) Teoalida: what is the confusion more exactly?
    (11:40:01 AM) Visitor 83172926: give me an ERD
    (11:40:24 AM) Teoalida: what is ERD?
    (11:41:35 AM) Visitor 83172926: WHATS YOUR NAME?
    (11:41:43 AM) Teoalida: just call me Teoalida
    (11:41:52 AM) Teoalida: like website URL
    (11:41:53 AM) Visitor 83172926: ARE YOU A GUY ?
    (11:42:03 AM) Teoalida: yes, even if the name sounds female
    (11:42:41 AM) *** Visitor 83172926 has left ***

    • Raman on June 6, 2017 at 2:19 pm
    • Reply

    I am interested in buying the mobile phone database, I like to know about the charges for the updates you release over the time.

    1. I was in another room and speakers too low and when I came back and answered you, you quit!

      Chat started on Tuesday, June 06, 2017 5:17:35 PM

      (5:17:35 PM) *** Visitor 21321368 has joined the chat ***
      (5:17:35 PM) Visitor 21321368: hi
      (5:17:52 PM) Visitor 21321368: hello
      (5:19:37 PM) Auto-respond @ 2 min: I am busy or out of office for a moment. Try messaging again in 10 minutes. Or leave a message with your email address and I will contact you when I come back!
      (5:20:06 PM) Raman: Hi, I like to know about the pricing for updates?
      (5:20:23 PM) Raman: Kindly mail me the details. Thanks.
      (5:22:19 PM) *** Teoalida has joined the chat ***
      (5:22:22 PM) Teoalida: free updates for one year
      (5:22:30 PM) Teoalida: pay 50% for next year
      (5:23:12 PM) *** Raman has left ***

    • c on December 30, 2017 at 6:17 am
    • Reply

    your posts contain a good information about smartphones. The posts are helping me a lot. Thanks for sharing.

  3. Really Your blog is very interesting, I also suggest to my friends to read your post. looking forward to reading more. Great and Thanks for sharing.

  4. thanks a lot by this article posting very helpful for me

  5. Hi, I just bought the database, looks good! However I would very much appreciate a copy in .csv format, so the data processing would be a lot easier and faster. Hate the idea of formatting the file every time I need to update my database. Also the product images in a .zip would be a blast!

    1. Isn’t hard to delete header rows, column A and other unneeded columns, and save file as CSV.
      Use https://chrome.google.com/webstore/detail/tab-save/lkngoeaeclaebmpkgapchgjdbaekacki?hl=en to download images (I added now link within article)

  6. Mobile phones are nice, but the need of security has emerged with growing crimes. CP Plus security cameras must be your first choice. If you want to get them installed , then you can contact us.

  1. […] Phone database […]

Leave a Reply to Manoj Kumar Cancel reply

Your email address will not be published.