Forum thread: HLTV Top 100 spreadsheet

i ain't click that.

2021-05-10 19:59

9 replies

2021-07-27 14:14

2 replies

2021-07-27 14:14

1 reply

2021-07-27 14:15

how to say im low iq without saying im low iq

2021-08-05 16:29

5 replies

Im from Romania

2021-09-20 20:25

3 replies

2021-11-22 20:41

2022-01-10 21:03

dayum

2022-01-10 21:05

I’m joking I respect Romania

2022-01-10 22:23

For people scared of bit.ly -links: docs.google.com/spreadsheets/d/1G61Ny_84..

2021-05-10 20:00

3 replies

What's the problem with those links?

2021-08-16 20:41

2 replies

They can easily hide some adscam links, so I know for fact, some people don't like clicking any bitly-links, but I can assure that the bit.ly-link in this post is just this same link shortened :)

2021-08-16 20:42

1 reply

Alright then, ty

2021-08-16 20:44

Updated for May 17th - IQUE coming up to the top 100, straight into 70th spot

2021-05-17 20:05

Updated for May 24th

2021-05-24 21:04

I love Finland!

2021-05-24 21:04

nice work mens

2021-05-24 21:06

Holy wow that s a lot of work

2021-05-24 21:07

Young ninjas>nip

2021-05-24 21:09

Updated for May 31st - Akuma straight to top 20 with a big jump!

2021-05-31 21:22

Updated for June 7th - RIP IQUE :(

2021-06-08 08:22

Nice thread, mens. Keep it up!

2021-06-08 09:04

GOAT spreadsheet mens

2021-06-08 09:10

Updated for June 14th - Astralis out of top 5; Only EU and CIS in top 10

2021-06-14 19:57

Updated for June 21st - Sorry for late update, not at home; bit.ly/HLTVTop100

2021-06-22 00:04

1 reply

Just a bump

2021-06-22 08:14

Updated for June 28th

2021-06-28 19:54

Updated for Jul 5th - Missing the team at No. 100, couldn't find it; Mongolia taking over in Asia too now!

2021-07-05 20:48

Updated for Jul 12th - Missing the team at no. 95, probably same as no. 100 last week, but still couldn't find it

2021-07-12 20:11

Updated for Jul 19th - Got bored, so it became Top 150, although nation stats are still from top 100; Missing couple of teams, but other than that, mostly on point again.

2021-07-19 21:36

2021-07-20 12:41

Updated for Jul 26th - Missing team n. 109, other than that, whole 150 is there :)

2021-07-27 14:08

spyware don't click

2021-07-27 14:17

Do you only update when the new rankings get released?

2021-07-27 18:52

4 replies

yeah, except when it comes to trades and free agents and stuff

2021-07-27 18:53

3 replies

Could I help updating it? I got a few thing that I could add

2021-07-27 18:54

2 replies

sorry, but no, this is just a fun project for me, so don't feel like adding anyone else to update it

2021-07-27 18:57

1 reply

well ok thanks, btw S0tF1k is new Spirit Academy Coach, replaced hally

2021-07-27 18:58

Do you use y0fl0w

2021-07-27 18:54

1 reply

no :)

2021-07-27 18:56

Late update, but updated for latest rankings... Not much happening during player break, still missing team no. 110, which I can't seem to find at all :D bit.ly/HLTVTop100

2021-08-05 09:20

3 replies

do you do this manually?

2021-08-05 09:36

2 replies

I update it manually, but there's a lot of automated cells in there too; But yeah, manual work

2021-08-05 10:56

1 reply

how do you find the teams below top30?

2021-08-05 16:11

i have caught a virus because of this link. Some indian guy says "Hello your computer has virus"

2021-08-05 09:43

2 replies

nice; you probably didn't click this link then :) Don't know what you kids are getting from these trolls :D

2021-08-05 10:55

1 reply

it was a joke. nice list and i see days of work, but I mostly disagree with top 10

2021-08-05 20:38

who is Triton and why did they steal AVANGARs logo?

2021-08-05 11:42

No one cars

2021-08-05 11:55

5 replies

cool :)

2021-08-05 12:09

4 replies

how did you made it, since HLTV doesn't have API supports, I made a web crawler back then for some stat check, did you did the same?

2021-08-05 12:25

3 replies

manual work, no API used :)

2021-08-05 15:01

2 replies

damnnnnnnnnn... you really did all that with hands. :O I appreciate you for this dedication, but would suggest you to use some automation in future, you might learn some cool skills.

2021-08-05 15:06

1 reply

I'm doing all this for fun anyway, and there is some automation in the spreadsheet itself, but can't really automate for getting rank from HLTV, for now at least

2021-08-05 15:07

Dosia is playing with a team now from what I remember

2021-08-05 12:17

2 replies

yeah, have forgot couple of the free agents from earlier down there; he's not the only one :D

2021-08-05 15:02

1 reply

fair enough

2021-08-05 19:14

nice list, how long did it take you? Brilliant effort

2021-08-05 15:03

5 replies

at first it took probably couple of hours to make the top 100 itself, been updating to have more stuff every now and then, so can't tell total time :D Updating takes like 30 min to 2 hours depending on changes in the rankings :)

2021-08-05 15:06

4 replies

what motivates you to do this?

2021-08-05 15:14

3 replies

boredom tbh :D been doing this weekly for like 1½ years now, so it's just something to do;

2021-08-05 15:17

2 replies

great work, I never have motivation to do anything these days even gaming. When I was 14 I was so full of passion now I'm like a relic lol

2021-08-05 15:20

1 reply

I used to make Excel spreadsheets for fun when playing like NHL games and stuff too as a kid, so I must have some kind of passion for statistics; not enough to make it my line of study tho :D

2021-08-05 15:23

Amazing work

2021-08-05 15:18

nice, good job bump

2021-08-05 15:21

Gj my man

2021-08-05 16:25

Keep up the great work, friend. :D

2021-08-05 16:27

HUNDEN still shows as heroic coach lol

2021-08-05 19:22

3 replies

thanks for noticing, fixed now :D Coach changes can be easily missed while updating for top 30 teams, since they don't show up in ranking-page itself :)

2021-08-05 19:27

2 replies

this spreadsheet is awesome mens))). Some other things are Nordavind are now ex-Nordavind, in the free agent sheet meyern is now playing for furious, motm shows up twice and is now playing for secret club, cxzi also plays for secret club, and bwills is still part of triumph im pretty sure.

2021-08-05 19:36

1 reply

Yeah, Nordavind thing is because of the fact, that update is from the ranking update, and technically the spot is now for empty team, so I rather just leave them like that for now, and update it on Monday after new rank update :) Thanks for free agent updates, that's the one page I tend to use least time on, and I miss updating it, if HLTV news don't show up something big :D

2021-08-05 20:03

Top

2021-08-05 19:27

I arent click that

2021-08-05 19:37

Updated for Aug 9, 2021. Small changes, since it's still a player break; Also still missing the team at ranking 109; that seems to be very hard to find :D bit.ly/HLTVTop100

2021-08-09 20:31

Updated for Aug 16, 2021 ; Still missing that one team, which is now at rank 107... Also there is two teams ranked 149 on HLTV, so I randomly picked one of them to be shown there... (The other team not shown is Meta BR)

2021-08-16 20:01

2 replies

this is dope bro

2021-08-16 20:36

1 reply

thanks mens))

2021-08-16 20:40

that's actually sick. nice work!

2021-08-16 20:17

THATS SO SICK, nicely done!

2021-08-16 20:19

I no click that

2021-08-16 20:39

2 replies

name no check out

2021-08-16 20:40

1 reply

Wtf

2021-08-16 20:40

Cool af dude

2021-08-16 20:47

Good job man. But wtf is wrong with the colors

2021-08-16 20:49

2 replies

If you're watching it on mobile, the colors break for some reason; I've noticed the same; like if you open it on dark theme on mobile, it breaks up; you can see it on mobile, if you put the app to light mode; Don't know if that was what you meant, but assumed it waS :D

2021-08-16 21:02

1 reply

probably was, thanks man

2021-08-16 21:02

Updated for Aug 23rd - Am late on updating; Lot of updates there tho, still missing that one team from top 150, now at 150th spot :D -- Ranking news: Astralis out of top 5, FaZe in. Eternal Fire straight to top 100. Akuma out of top 30.

2021-08-24 17:42

Updated for Aug 30th

2021-08-30 21:00

Updated for Sep 7th;

2021-09-06 23:12

Updated for Sep 13th; Missing team number 99, couldn't find it. Also HLTV again has two teams at same position in lower ranks, but idc :D

2021-09-13 21:36

Updated for Sep 20th;

2021-09-20 20:16

1 reply

nice job :) impressed by the dedication to this, keep it up!

2021-09-20 20:25

its ok but ec kyiv, bp5 and marten are too low, and gorillaz, infinity too high ranked (like wtf)

2021-09-20 20:20

7 replies

it's HLTV, so it's all mathematical :D

2021-09-20 20:21

6 replies

bruuuh

2021-09-20 20:22

4 replies

this is all by HLTV rank, so it counts latest games hltv.org/news/16061/introducing-csgo-tea..

2021-09-20 20:23

3 replies

#91 sorry im a retard

2021-09-20 20:23

2 replies

yeah, no worries mens))

2021-09-20 20:23

1 reply

thanks mens))

2021-09-20 20:23

im so fucking stupid

2021-09-20 20:22

Just use hltvranking.y0fl0w.de/ for the FULL ranking list

2021-09-20 20:24

6 replies

so FULL ranking, it's missing even more teams than my list most of the time :D But you do you, thanks for advertising it tho, hence it has nothing to do with my spreadsheet, other than it's HLTV ranking

2021-09-20 20:26

5 replies

Your list doesn't tell me how many points the teams have and how many they've lost/gained after the weekly update and it also doesn't tell me how many ranks a team has gone up/down

2021-09-20 20:31

4 replies

Yeah, because that's not what it is for :) As I said, if you want to check those things, use y0fl0w, I have nothing against using it, it's just not for same purpose that my list is for.. Enjoy your day mens)) Also, I used to use y0fl0w to make my list for a long time, until I noticed it started missing more and more teams from lower ranks, so I still had to manually search the teams even with using it. It fits its purpose tho

2021-09-20 20:32

3 replies

What's the purpose of your then? Why are you advertising your list?

2021-09-20 20:33

2 replies

to have a list of top 150 teams, and where players are from, and some stupid useless info you probably don't need. There are multiple tabs in that spreadsheet with other info than the ranking. I'm advertising it only because some people seem to like it, as far as comments go. If you don't need it, ignore it. I am doing all this just to waste my own time, and if someone gets something out of it, it's nice. Most people probably never check it, but at least most of them can keep themselves quiet while ignoring.

2021-09-20 20:36

1 reply

Yea, well #103 atleast seems to like it cya later men

2021-09-20 20:38

nice post men]]]

2021-09-20 20:34

Updated for Sep 27th; Rank changes now shown on there too.

2021-09-28 14:23

Updated for Oct 4th;

2021-10-04 20:53

1 reply

ty mens))

2021-10-04 21:09

Updated for Oct 11th; ENCE has been done dirty by HLTV, by leaving them out of top 10 and behind OG. Some big moves after RMR tournaments finish.

2021-10-11 20:46

Updated for Oct 18th; Did it already yesterday, but was surprised by temporary ban by HLTV :D

2021-10-19 17:46

Very nice spreadsheet and nicely organized too, well done

2021-10-20 02:59

Updated for Nov 1st; Challengers stage made some changes, also missing two teams (from 140's), so if you have any info, please let me know :)

2021-11-01 20:38

Updated for Nov 8th; Missing one team (at 115th) ; Some big movement on the top, after Major.

2021-11-08 21:15

Updated for Nov 15th; No big movements at the top (18 teams from top 30 unmoved), Spirit dropping out of top 150 (190th). Still waiting for the big roster shuffles tho.

2021-11-15 20:30

Updated for Nov 22nd

2021-11-22 20:38

1 reply

I would really like to ty, your work is awesome

2021-11-22 21:19

don't click my dad didn't return from the shop

2021-11-22 21:01

Updated for Nov 29th

2021-11-29 21:24

Updated for Dec 6th - Happy Independence Day for Finland!

2021-12-06 21:19

Updated for Dec 13th - Closing the end of the year and possible big shuffle; Note: AURA doesn't have a team anymore on HLTV, but they show up on HLTV rankings. To not put empty team there, I went with the team that was shown on the rankings, altho it's not active team anymore.

2021-12-13 21:03

Looks a lot better from last time i remember seeing it! gj

2021-12-13 21:04

bro ty so much

2021-12-13 21:05

not updated yet

2021-12-21 10:24

1 reply

#127

2021-12-22 17:17

Go to NATIONS MAP and look how big Russia and Denmark is Then you can see that Russia has 41 pros in TOP 150 and Denmark 54 Mental Russia's area would contain 399 Denmarks, then you could expect 21546 pros from Denmark :D

2021-12-21 10:39

3 replies

I know its depends most likely on population, but its dank

2021-12-21 10:40

Just to correct, the map is made to top 100 only, but that doesn't affect anything you've said tbh :D

2021-12-22 17:17

1 reply

That's also only because I haven't updated the nations tab to include top 150 :D

2021-12-22 17:22

Unfortunately I am not able to update for this week, since am out of town for christmas. Will most probably be updating again for 27th, if I get home in time. Happy holidays for you HLTV mens))

2021-12-22 17:16

Updated for Dec 27th; Not a lot of movement, because of the player break; Liquid out of list, since they benched everyone, same with Fiend. Also, first Italian since I started making this got into top 100; Gongrats FusioN (EC Brugge) on being the first

2021-12-27 20:41

1 reply

Note: I might not update for next week, if it seems like not a lot happening; depends if the roster changes will come up for next ranking update or not

2021-12-27 21:02

Updated for Jan 3rd; New year, not yet a lot of movement - And because people will complain because I put m0nesy as "substitute", it's just because my format can't handle 6 starters, which is the case in G2 atm, because they are yet to announce who will be leaving.

2022-01-03 21:46

Updated for Jan 10th; aleksib <> nexa move has not been confirmed yet, so they are still in their old teams; I am going with what HLTV tells, so no can do :)

2022-01-10 20:29

Updated for Jan 17th; Missing two teams from the bottom (148 and 150); Added ages to the spreadsheet, just because I can :)

2022-01-17 21:05

Updated for Jan 24th; A Finn in top 5, and new youngest in top 30, since G2 moves finally come to the rankings. Also new team Apeks making entrance straight to no. 70 spot :)

2022-01-24 23:35

Updated for Jan 31st; 4 new NA teams up to ranks (Liquid, Orgless, EG and Disconnected); Other than that, no big changes in rankings;

2022-01-31 21:04