Creating CSV files
If you're interested in those lists: here are some tips for transforming them into importable CSV files. For example with Soundiiz, in combination with Deezer, Spotify, Tidal, Qobuz, etcetera. The Dutch formulas are all tested here.
But when it comes to Spotify: similar lists (except for the missing songs) are already on my own account.
Home // 15·25 | 2020s | 2010s | 2000s | 1990s | 1980s | 1970s | 1960s | Pre 1960 // ➔ Cultural eras (pink pages)
But when it comes to Spotify: similar lists (except for the missing songs) are already on my own account.
Home // 15·25 | 2020s | 2010s | 2000s | 1990s | 1980s | 1970s | 1960s | Pre 1960 // ➔ Cultural eras (pink pages)
··· SOME BASICS
To make the CSV files work correctly, they need a column with 'title' on top (A1) and a column with 'artist' on top (B1).
The best way to save CSV files is the 'CSV UTF-8' modus (separated by commas/semicolons).
Sometimes version info (mentioned on this site) is forgotten on streaming services. This can make it look like a specific track isn't on the streaming service of your choice - while it is. There's nothing to do about that.
Of course the formulas on this page are also useable with lists created by others.
··· REPLACE ALL DIACRITICAL CHARACTERS BY REGULAR ONES
This is very important when importing a CSV file in Soundiiz. This service doesn't accept diacritical characters.
If you're using the English version of Excel, and put the list in A1 & further:
=T(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE((A1),"à","a"),"á","a"),"â","a"),"ã","a"),"ä","a"),"å","a"),"ç","c"),"è","e"),"é","e"),"ê","e"),"ë","e"),"ì","i"),"í","i"),"î","i"),"ï","i"),"ð","d"),"ñ","n"),"ò","o"),"ó","o"),"ô","o"),"õ","o"),"ö","o"),"ù","u"),"ú","u"),"û","u"),"ü","u"),"ý","y"),"ÿ","y"),"È","E"),"É","E"),"Ë","E"),"Á","A"),"À","A"),"Ä","A"),"Ó","O"),"Ö","O"),"Ò","O"),"Ü","U"),"Ú","U"),"Ù","U"),"Í","I"),"$","S"))If you're using the Dutch version of Excel, and put the list in A1 & further:
=T(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN((A1);"à";"a");"á";"a");"â";"a");"ã";"a");"ä";"a");"å";"a");"ç";"c");"è";"e");"é";"e");"ê";"e");"ë";"e");"ì";"i");"í";"i");"î";"i");"ï";"i");"ð";"d");"ñ";"n");"ò";"o");"ó";"o");"ô";"o");"õ";"o");"ö";"o");"ù";"u");"ú";"u");"û";"u");"ü";"u");"ý";"y");"ÿ";"y");"È";"E");"É";"E");"Ë";"E");"Á";"A");"À";"A");"Ä";"A");"Ó";"O");"Ö";"O");"Ò";"O");"Ü";"U");"Ú";"U");"Ù";"U");"Í";"I");"$";"S"))➔ There's also a formula to detect diacritical characters in a cell. After this, you can go further with sorting and editing the results.
If you're using the English version of Excel, and put the list in A1 & further:
=IF(SUMPRODUCT(--(UNICODE(MID(B1,ROW(INDIRECT("1:"&LEN(B1))),1))>127))>0,"Contains accent","No accent")If you're using the Dutch version of Excel, and put the list in A1 & further:
=ALS(SOMPRODUCT(--(UNICODE(DEEL(B1;RIJ(INDIRECT("1:"&LENGTE(B1)));1))>127))>0;"Bevat accent";"Geen accent")
··· REMOVE ALL TEXT FROM 'CHARACTER X' ONWARD (in this example: ' ➔ ')
If you're using the English version of Excel, and put the list in A1 & further:
=IFERROR(LEFT(A1, FIND("➔", A1) - 1), A1)If you're using the Dutch version of Excel, and put the list in A1 & further:
=ALS.FOUT(LINKS(A1;VIND.SPEC("➔";A1)-1);A1)
··· REMOVE THE WORDS 'MIX', 'REMIX', 'EDIT' AND 'VERSION'
If you're using the English version of Excel, and put the list in A1 & further:
=LET(
text, A1,
remove, {" remix", " edit", " version", " mix", "(remix)", "(edit)", "(version)", "(mix)", "- remix", "- edit", "- version", "- mix"},
result, REDUCE(text, remove, LAMBDA(acc, word, SUBSTITUTE(LOWER(acc), word, ""))),
TRIM(result))If you're using the Dutch version of Excel, and put the list in A1 & further:
=LET(
tekst; A1;
te_verwijderen; {" remix";" edit";" version";" mix";"(remix)";"(edit)";"(version)";"(mix)";"- remix";"- edit";"- version";"- mix"};
versie; REDUCE(tekst; te_verwijderen; LAMBDA(acc;woord; SUBSTITUEREN(KLEINE.LETTERS(acc); woord; "")));
resultaat; SPATIES.WISSEN(versie);
resultaat)
··· REMOVE EXCESS SPACES
If you're using the English version of Excel, and put the list in A1 & further:
=TRIM(A1)If you're using the Dutch version of Excel, and put the list in A1 & further:
=SPATIES.WISSEN(A1)
