turn name into gender in excel

[tcteng712360]

Hi, if i've a column full of names (like James and Jane), how can i create another column to turn these names into gender like male and female? Thanks

[#2]

@tcteng712360 

Afraid that's only manually, Excel has no idea about the genders. If there are many repeating names, you may create dict table which maps James on male and Jane on female, etc. After that VLOOKUP or INDEX/MATCH it to fill the data.

[#3]

@tcteng712360
Take a look here: https://api.nameror.com/en/blog/post/determine-gender-of-names-in-excel-spreadsheet/

Cheers and happy holidays!

[#4]

@michelwehrli 

And what it returns for unisex names like Sasha?

[#5]

@Sergei Baklan It returns "both". You can try names here: https://www.nameror.com/en/Sasha

[#6]

@michelwehrli 

Interesting. However, I don't think such tool could be build within Excel.

[#7]

What If I know to identify them.
Like with annotation in name.
Like Shri=means "Male" & Smt= "Female".
So now How can I create a column for male and females.
Please help me on this.

[#8]

@the_analyzer found this website that does the conversion of names to gender

CSV and Excel Tool | Namsor