Skip to content

Music Database

Free SAMPLE:
Music Database .xls (ranking of 114 artists + list of songs for 5 artists)

Buy FULL database (including free updates):
Can give free $1 version if you explain why do you need it

Quick links:
Background
List of updates
Song rating system
Artist ranking system
How I discovered music
How I started music database

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

Background

We all love music, but I may be the only (or first) person in the world who made an Excel database and show to everyone what are my musical preferences in the style of a data scientist.

Since 2005 I use Excel to organize the music I am listening, rate each songs from 0 to 16, then use complex mathematical formulas to calculate scores and rank best artists, best albums, best music genres, etc.

My intention was NOT to include every possible song released, nor Billboard Hot 100 or other official music charts, but to include complete discography of my favorite artists / bands, plus a selection of famous artists / bands representative for each region of the world and each music genre.

In the early years my local friends commented “what a waste of time to write songs in Excel, useless database, you have nothing else to do?” for your info: adding songs data takes less than 1 minute per album, listening songs to rate them takes much longer, and I listen them while doing my normal jobs.

Thanks to TV shows and YouTube I discovered many songs that I liked, and added in database whole discography of their artists, but never bothered to rate them, since 2009 been rating just few hundreds songs / year, I do not want to waste too much time on such useless project.

Until 2016 I was offering Excel database for free download including ONLY artists that I downloaded at least 1 whole album and rated songs (mp3 files downloaded from internet, Apple Music previews, or more recently Spotify). I ranked only artists that produced minimum 10 songs and rated at least half of their songs.

In March 2018 I put price $1 stating that you must contact me IF you want to download it for free. By end of year 10 people paid $1 without any communication with me, I emailed them asking scope for which they purchased, if my work helped their needs, if they have any suggestions to improve database, or to tell me if my work did not helped and they needed something else, but in 90% cases I haven’t got any reply… without YOUR feedback how I can offer better databases to YOU?

I believe that most people are NOT interested in my personal musical preferences, but just need artist, album, song name, etc, so in 2019 beside $1 version from 2016 I offered for $10 an expanded database including best-selling artists from Wikipedia regardless I rated their songs or not. Both packages updated in 2021 and the $1 is now a subset with artists having most songs rated.

Making custom databases: I can provide you list of songs (Excel / CSV) of any artists at your choice, in a matter of minutes, using an automated script that extract data from Apple Music at speed of ~2 seconds per album. See video how I am making database. Price: $1 per artist.

List of updates

Jun 2007 – 2000 rated songs, 37 artists ranked
Feb 2008 – 3000 rated songs, 57 artists ranked
Aug 2009 – 4000 rated songs, 71 artists ranked
Apr 2012 – 5000 rated songs, 92 artists ranked
Late 2013 – 7523 total songs, 5467 rated songs, 97 artists ranked
Jun 2016 – 8365 total songs, 6043 rated songs, 105 artists ranked
Feb 2019 – 32078 total songs, 6639 rated songs, 110 artists ranked
Oct 2021 – 34265 total songs, 6908 rated songs, 114 artists ranked

Songs rating system

rankingIn 2002 being fascinated by Base-16 numbering system, I rated songs from 0 to 15 (originally lower values being better, but in 2016 I inverted the ratings, making higher values better).

In 2004 I split up rating into 4 categories, each having 5 possible values (from 0 to 4) so total rating range now from 0 to 16 (17 possible values, which is my birthday and my favorite number), distributed like an asymmetric Gaussian curve.

Sound: I love instrumental diversity and guitars. Some rock and country songs achieve 4 in this category, pop songs are around 1-3, while hip-hop songs get 0.

Voice: I love nice voice and lyrics diversity, but I do not care about the lyrics content. The songs sung in languages unknown by me or artificial languages can win rating 4 too. Repeating lyrics lower rating, instrumental songs get 0.

Mix: I love songs with continuous and fast rhythm. Some dance songs achieve 4 in this category. most rock songs have rating 2-3, most pop songs have rating 1-3, slow songs or bad mixed songs gets rating 0.

Addiction: some songs makes me to listen them again and again for hours, they win rating 4 in this category, they are bubblegum dance, Japanese pop as well as songs from children show of Latin America (this is what attract negative comments from my friends, that I listen childish music, music for retarded people, etc). Rock and country despite of winning in other categories, makes me bored after listening few times so they have rating 1-2, while the louder songs like hard rock or hip-hop causing pain in my ears that I cannot listen a song until its end have rating 0 (addiction rating cannot be determined quickly and sometimes I modify it after days or months).

My everyday playlist is composed by songs rated from 12 to 16, temporarily including songs with rating 8-11 which I keep if addiction rating is 3 or higher. This create a playlist of about 20% of songs included in database.

gaussian curveThe 0-16 ratings can be easily converted to the more popular 5-star system:

5 stars = rating 16-13 = 7% of songs
4 stars = rating 10-12 = 23% of songs
3 stars = rating 7-9 = 30% of songs
2 stars = rating 4-6 = 25% of songs
1 stars = rating 0-3 = 15% of songs

Artist ranking system

ranking

In 2006 I added columns for number of songs and value of songs: 16 divided by every rating, a song rated 0 have value 1, a song rated 8 have value 2, a song rated 12 have value 4, a song rated 14 have value 8 (inverted binary logarithms), exception for rating 1 which have value 12 and rating 0 which have value 16. Artists were ranking by a SCORE made from average rating plus value of songs.

In 2008 I added diversity factor: total value of songs divided by number of songs divided by average song rating, sum resulted square rooted and multiplied by 2, resulting a number between 1 and 1.5. Artists having diversity, few good songs in a total of mostly bad songs, are helped by having higher multiply factor than the artists who have all songs at same medium rating.

How the score is calculated: square root of songs’ total value (ranging 4 for one-album rappers to 30 for Tatiana’s 20+ albums) plus average song rating (ranging from 0 to 16) multiplied with 4 (this multiply factor can be increased to boost artists releasing just few but good songs, or reduced to boost artists with long career), sum of these 2 is multiplied with diversity factor which is between 1 and 1.5, them multiplied with 128 to get a nice-looking 4-digit score for all artists varying from 2500 to 9000+. This 4-digit score have no other meaning than classifying artist in top. Do not consider an artist with score 8000 to be two times better than an artist with score 4000.

How my hobby for music started

In 1998 we replaced our 486 computer (200 MB hard disk and Windows 3.1) with an AMD K6-2 333 Mhz (4.3 GB hard disk and Windows 95) that allowed multimedia, my dad brought from friends some CDs with mp3 songs, mostly pop and rock songs from 1960s to 1990s, and made a selection of songs according his own preferences, unfortunately deleting many songs that I liked. The he burned the selected songs on 2 CDs. I had no rights to decide what to listen, only parents were putting music in our home, and for many years, my dad’s songs selection was the only music I was listening. I wonder, if I did not had these restrictive parents, were my music preferences different today?

Out of my dad selection, I also made my own playlist of few dozens songs which I was listening only when I was home alone.

My family gave me some freedom since 2003, I could listen music anytime and got bored by my playlist, I was desperate to get more music and started recording via TV-Tuner (ending in having lots of songs in bad quality recording). I wanted more songs from certain artists, I went to music stores in the city but my parents did not agreed to pay money for music CDs.

In November 2004 I accidentally turned TV on during Junior Eurovision Song Contest, won by Maria Isabel. In 2005 we connected to internet so I was able to download music freely for first time using DC++ file sharing network (YouTube was not yet launched), the first songs downloaded were Maria Isabel’s 2 albums and 2 more children artists discovered while looking for Maria Isabel: 3+2 and Danna Paola, additional songs from the artists I already had few songs (Aqua, Shakira, Shakin Stevens, Thalia), also originals of about 100 songs recorded from TV in bad quality.

In 2006 while looking on YouTube for Danna Paola I found accidentally a video with her singing with Tatiana, so I started looking for Tatiana music too, on ARES (file sharing software popular in Latin America) and direct downloads (like MegaUpload) and by this way I downloaded also Fandango, Flans, Timbiriche, R.B.D, and got addicted to Mexican 1980s-1990s pop-rock. In 2008 I had 3000+ songs of which 30% being from Mexico. At same time I started watching Mexican TV shows and I learned Spanish. Tatiana remaining my all-time favorite even in 2013.

I was looking for more diversity, so since 2009 I also downloaded music from other Latin American countries, and got addicted to Brazil country music (Rionegro & Solimões, Sandy & Junior) as well as 3 big artists hosting children shows (Angelica, Eliana, Xuxa), which generated bad comments from my overseas friends (are you retarded? why do you listen to children music?), by this way in just one year I learned Portuguese to the level I am able to understand lyrics of any song. I also downloaded American country music (Alan Jackson, Garth Brooks, Shania Twain, Taylor Swift, etc), British, French, German, Italian pop, rock and folk (ABBA, Al Bano & Romina Power, Alizee, Andrea Berg, Ricchi e Poveri, etc), Japanese and Chinese pop music (many small artists), I liked all them but none caused long-term addiction until 2013 discovery of Kyary Pamyu Pamyu. There is also music that I cannot tolerate: Arabic and Indian music, and most of hip-hop music.

Some local friends, the ones who know me in real life or the internet friends I showed my favorite songs, blamed me for listening shit music that cannot be understood, they also said that I should be MAD to create this Excel database, and suggested me to stop because is most useless thing ever seen. What is the problem if I rarely listen music from my own country? If I speak 4 languages and listen music in languages unknown for them but also languages unknown for me, does not mean that the music is bad? I love collecting music sung in as many languages possible and I do not always care about the lyrics.

The idea of creating an Excel music database

The idea of using Excel to make table with songs, and rate each song, dates back from 2002. I added in WinAmp all songs brought by my dad in computer, clicked “generate HTML playlist” and copied into Excel, then added a numerical rating. Database had just artist name, song name and rating. No genre or release year, and was not a complete discography for any artist. I expanded database with songs recorded from TV and in 2004 I breakdown rating by 4 categories.

After connecting to internet in 2005 I could get information about artists, I decided that is the time to start making a serious music database, with complete discographies, album names and release date.

In 2005 iTunes was the biggest music store and I could copy-paste whole album’s table of song with just few clicks, so columns in my database matched columns in iTunes. By 2009, the music database reached over 4000 rated songs, after which I continued to add new songs at slower rate. iTunes app was redesigned in 2010, copy-pasting whole album was no longer possible so I had to copy songs name one by one. Database also contains albums sourced from other websites if they are not available on iTunes, as well as names of mp3 files found on the internet (possible incorrect spelling). Is enough to listen 30-second preview on iTunes to rate each song, but I prefer to rate only when I download full songs.

I did not intended to include ALL songs from my computer, nor to reach certain number of songs in database within specified deadline. I just added artist by artist at random basis, originally adding only my favorite artists (most of them having short music career), and since 2008 I paid attention to famous artists, adding in database a selection of artists representative for every region of world and every genre of music.

In 2010 I published music database for first time, a simple download link in Biography page. In 2013 I created this dedicated article “Music Database”. In March 2016 I expanded article and in June 2016 published a new update with 6000 rated songs, this time using Easy Digital Downloads plugin, that require entering email address, so I can track how many does download (still FREE of charge).

Over 200 people downloaded it during 2 years, and I emailed ~30 of them hoping to get feedback: why did you purchased my music database, did it helped your needs or need something else?

In April 2018 I put price $1 stating that you must contact me IF you want to download it for free. By end of year 10 people paid $1 without any prior communication with me, meaning that people are willing to pay money for a music database, but I don’t understand what they expect to receive?

Among people emailed, only 3 people gave feedback: one said that “did not helped but $1 wasn’t a big waste” then did not replied anymore when I asked what would have helped him, while other 2 told me that needed “some data” to practice for a school project. They were not even interested specifically in music!

While my other hobbies from childhood such as car database and real estate databases attracted professionals paying me $$ for database, the music database turned to be one of most USELESS things that I ever made!

A new era started in 2018: I discovered Spotify, a music streaming service where you can listen full songs free of charge (useful for me to rate songs without having to dig for mp3 files). I also used for the first time a web scraping software to get data faster from Apple Music, at rate of 2 seconds per page (album). I expanded database with few extra columns such as Source URL or Record labels. Amazon Music Store may be bigger than Apple, I found many artists on Amazon that do not exist on Apple, but due to inconsistencies between various albums on Amazon I need to spend extra time to clean up scraped data, so I prefer to source data from Apple Music unless it miss my favorite artists.

In February 2019 I published a new version with 32,000 songs after using web scraping software to quickly add best-selling artists from Wikipedia (without rating songs) for sale at $10 beside 2016 edition that was $1.

Between January and November 2019 I placed web scraping video at top of page, but among dozens people who visited this page and contacted me, only about 10% were interested in such service, 90% asking random things unrelated to service I offer (one idiot asked for a database of artists phones and emails, LOL!).

People continued to pay $1 and $10 without contacting me prior to purchase, giving me impression that I can raise price to $100 and still get sales, but I am really intrigued for what scope does these people purchase my database and if it helped or not?

In October 2021 I started a new update for Music Database (after 2.5 years of hiatus due to lack of feedback). I used a newer Excel to include more formulas like COUNTIFS and SOUNDIFS (not available in Excel 97 used at the time I started this database), such formulas allow me to do more detailed data analysis and add new songs easier without screwing up formulas that were previously specified as absolute ranges. Instead of XLS, I saved as XLSX with macros removed (they raised security concerns), and visual changes to follow up design trends of other Excel databases made by me.

The future of this project is uncertain due to lack of feedback.

Tags:

18 comments

  1. you might wanna include in your database of music suggested songs THAT CAN MIX WELL (as in DJmixing) with a particular song’s INTRO – that would sell for sure. DJ is a big thing now with the kids

    1. What do you mean “with a particular song’s INTRO”
      Do you want to include song names or mp3 files? an Excel file can’t have mp3 files. Selling what and to who?

  2. just do what u always want to do and yeah thanks a lot this database just gave me an idea abt my college project…really appreciate ppl like u helping like this…..

    1. “just do what u always want to do” – NOOOO! I want to do what people demand! This is MARKETING!
      For few years after turning 18 I had very little income because I was doing things as I want rather than as people demand, and now I make a living from databases.
      Can you tell me more how my music database was helpful for your college project?
      I sent you email and you never replied 🙁

  3. Chat started on Wednesday, October 10, 2018 2:00:31 PM

    (2:00:31 PM) *** Visitor 80657908 has joined the chat ***
    (2:00:33 PM) Teoalida (site owner): Hi there… are you looking for a specific database? you are welcome for a chat!
    (2:00:51 PM) Visitor 80657908: music
    (2:00:57 PM) *** Teoalida has joined the chat ***
    (2:01:01 PM) Teoalida: more exactly?
    (2:01:23 PM) Visitor 80657908: album,song,genre,artist…
    (2:01:39 PM) Teoalida: do you need songs list of specific artists or…?
    (2:01:45 PM) Visitor 80657908: yes
    (2:02:19 PM) Teoalida: tell me one artist
    (2:02:27 PM) Visitor 80657908: pink floyd
    (2:04:49 PM) Teoalida: https://www.teoalida.com/pink-floyd.csv
    (2:04:50 PM) Teoalida: done
    (2:05:06 PM) Visitor 80657908: thank you
    (2:05:30 PM) Teoalida: let me know if you want more
    (2:05:46 PM) Teoalida: and the original database that I compiled since 2005 and rated 6000 songs… does have any use?
    (2:05:46 PM) Visitor 80657908: thank you ı will say
    (2:08:46 PM) *** Visitor 80657908 has left ***

    Was that CSV all what you needed or did it disappointed you?

  4. Hi. Congrats on your hard work!
    I am doing a PhD in musicology where part of it involves compiling and rating songs I have collected in Spotify playlists.
    I am also a Spotify artist (David Goldmann)
    Your music scraping software knowledge is interesting to me.
    At first, I need an Excel layout that includes artist name, album, genre, duration, BPM, texture, timbre, tempo, vocal (y/n), rhythm track (y/n) etc, plus URL hypertext fields and jpeg support if poss.
    Do you think you may be able to assist me/give advice on where I might find suitable templates/software?
    Many thanks, David

    1. I can do web scraping from Apple Music and other similar music websites, they do have artist, album, song, duration, genre, URL of jpeg album art, but not the rest. You can buy the ready-made database with my personal selections of artists or I can do another database with artists at your choice. I also checked your music… slow and instrumental, not my favorite.

  5. What is wrong with this guy?

    Chat started on Wednesday, March 27, 2019 12:29:18 AM

    (12:29:18 AM) *** Visitor 2985373 has joined the chat ***
    (12:29:20 AM) Teoalida (site owner): Hi there, visitor from United Kingdom, are you looking for a specific database? Let me know if I can help you!
    (12:29:47 AM) Visitor 2985373: a csv file with a list of songs and their artists
    (12:29:58 AM) *** Teoalida has joined the chat ***
    (12:30:03 AM) Teoalida: of which artists?
    (12:30:12 AM) Visitor 2985373: the song artists
    (12:30:31 AM) Teoalida: I do scraping artist by artist
    (12:30:33 AM) Visitor 2985373: both the title of the track and the artist
    (12:31:50 AM) Teoalida: have you seen the video how it works?
    (12:32:36 AM) Visitor 2985373: um, no
    (12:32:42 AM) Visitor 2985373: but thanks for your time
    (12:32:52 AM) Visitor 2985373: I found out what I was searching for
    (12:32:55 AM) Teoalida: watch it and tell me which artists do you want CSV for list of songs
    (12:33:02 AM) Teoalida: or if you need something different let me know
    (12:33:12 AM) Visitor 2985373: I didn’t need just artist
    (12:33:21 AM) Visitor 2985373: I found out what I was looking for
    (12:33:28 AM) Teoalida: what did you found? give me link?
    (12:33:29 AM) Visitor 2985373: thank you for looking into
    (12:33:46 AM) Visitor 2985373: I am not too sure if I should share the link
    (12:34:10 AM) Visitor 2985373: Thanks for your help
    (12:34:15 AM) Teoalida: would help me to clear out confusion and offer better databases for future customers
    (12:34:26 AM) Visitor 2985373: I am ending the conversation
    (12:34:32 AM) Visitor 2985373: it’s basic google
    (12:34:43 AM) Visitor 2985373: to search for songs csv files
    (12:34:48 AM) Visitor 2985373 has rated the chat Bad
    (12:35:25 AM) Teoalida: if you find ready-made CSV files for download, probably you don’t need my service anymore
    (12:35:26 AM) *** Visitor 2985373 has left ***

  6. Hi teo

    I am DJ Gimix from AU and liked your idea of the collection , There are few of my suggestion here
    I used Mixed in key software to determine what is the key of each song and BPM of the song.
    this could be useful for the DJ’s around the world since we / I always seek song which matches genres and key and bpm’s to create an impactful playlist to the audience. This could be an addition of a column to your existing database

    I was here to find a way a solution to look for the songs and create a playlist from the csv/Xls file to Spotify /Soundcloud. Do you believe it is possible?

    if you have not heard of Kado. Kado it was something similar that you have done Just on the web ( not xls ) .
    so all can make use of it paying a small fees . would you be interested in doing this project with me.

    there is more to add to make it really commercially successful .

    good Luck
    DJ Gimix

    1. BPM = beats per minute… and you’re not the first who ask for this info.
      But neither Apple Music, Amazon and DiscoGS provide this info, so what do you expect me to do in this case?

      Does Spotify/Soundcloud have function to import/export CSV? Even if it have, I would hardly believe that you can import CSV that was made from other sources, due to not matching song names. I checked same album on few music stores and there are few cases in which song names are written differently, uppercase vs lowercase, missing punctuation marks, etc.

      I also don’t know how to make commercially successful in sales since just few people contacted me to buy songs list, and each person require a different set of artists.

  7. HI Teo

    you can use the ” Mixed in key ” / Recordbox to analyse music .Once analysed this information is exported in the csv file .
    you can map the songs in the order in xls /csv ( write macros) / script it .

    Since this data base would be used a matching songs based on the BPM/ Key/Genres . I think subscription methodology would work as like 2-5 $ a month .

  8. Respect admin, Recently I see your sample music datasheet this is excellent.
    nice please keep this type of file more help us. Thank you again, Admin .

    Deleted link ajkatajanews.com (site no longer active)

Leave a comment

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