So, I had this idea to make a soccer player name generator, you know, for fantasy leagues or just for fun. I’m not a coder, but I figured, how hard could it be? Well, let me tell you, it was a bit of a journey!

First, I brainstormed. What makes a good soccer player name? I thought about famous players, different nationalities, and common names. I jotted down a bunch of ideas in a notebook – first names, last names, even some nicknames.
Then, I decided to keep it simple. I figured I’d start with two lists: one for first names and one for last names. I spent a good hour just googling “popular soccer player names” and “common names from [country]” and added them to my lists. I ended up with, like, 50 of each. Plenty to start with, I thought!
Next, I needed a way to combine them randomly. I’m no programmer, so I used a spreadsheet. Yep, good old spreadsheet. I pasted my first names in one column and last names in another.
- Column A: First Names
- Column B: Last Names
I stumbled upon this “RANDBETWEEN” function. It picks a random number between two numbers you give it. So, I used that to pick a random row from each list.
Here’s what I did in the third column (Column C):
I created a formula: =INDEX(A:A,RANDBETWEEN(1,50))&" "&INDEX(B:B,RANDBETWEEN(1,50))
Basically, it grabs a random first name from column A and a random last name from column B, and sticks them together with a space in between. It’s like magic!
I copied that formula down a bunch of rows, and boom! Instant soccer player names. Some were pretty cool, some were kinda weird, but hey, it worked!

It was a little clunky, but it was my clunky creation. I learned a few things about spreadsheets along the way. I think with some refinements, maybe add some nickname options it might be even better.