ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Paste Spotify Song URLGroup or ArtistTrack NameTotal StreamsStep 1: File-> Make A Copy
2
Example ->
https://open.spotify.com/track/1ttNlwhsAwCvSKWGxA6fDk
 TOMORROW X TOGETHER Stick With You 48,247,894<- Do not edit "C", "D", or "E" columns, you will break the formulas.
3
Example ->
https://open.spotify.com/track/5XsrVitCrmP41A6pq827Yq
 JEON SOMI CLOSER 15,657,514Notes:ac
4
Only enter data in the B column. Columns C-E will auto-populate.
5
This grabs the song url tag from the Spotify URL and then uses mystreamcount.com to grab the on page data. Only use this for personal use. If you abuse this you're likely to be blocked by MSC.
6
7
8
9
If Spotify change how their URL works, or MyStreamCount changes their page layout at all, its likely to not work, but you can grab the new page tags easy enough.
10
11
12
13
You do need to manually grab the spotify URLS' but this will make your life 100x easier. To keep track of months etc, simply CTRL+A and then paste values only into a new tab. If you styreaigh tup paste you will carry the formula across and the numbers will keep changing.
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100