Forum Discussion

Copper Contributor

Jun 10, 2020

turn name into gender in excel

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

excel

michelwehrli

Copper Contributor

Dec 22, 2020

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

Cheers and happy holidays!

SergeiBaklan
MVP
Dec 22, 2020
michelwehrli

And what it returns for unisex names like Sasha?
- michelwehrli
  Copper Contributor
  Jan 14, 2021
  SergeiBaklan It returns "both". You can try names here: https://www.nameror.com/en/Sasha
  - SergeiBaklan
    MVP
    Jan 14, 2021
    michelwehrli
    
    Interesting. However, I don't think such tool could be build within Excel.