Random Name Generator Excel
Realistic sample names to paste into any spreadsheet
Tap a name to copy itPress Space for a new batch500 names in this generator
Generate realistic random full names to drop straight into an Excel or Google Sheets column for test data, mail-merge demos, mock customer lists and raffle draws, with formulas for building your own random name picker.
About random excel names
"Random name generator Excel" usually means one of two things: you need a column of realistic names to fill a spreadsheet, or you want Excel itself to pick a random name from a list. This page covers both. The list above is 200 unique full names with a realistic mix of first names (drawn from recent US and UK popularity tables) and surnames from a range of backgrounds, so a mock customer or employee table looks like real data rather than John Smith repeated forty times.
To pick a random name in Excel from a list in A2:A201, use =INDEX(A2:A201, RANDBETWEEN(1, ROWS(A2:A201))). Every recalculation (F9) picks a new one, which is handy for raffles and classroom call-outs. In Excel 365 or Google Sheets, =INDEX(A2:A201, RANDARRAY(10,1,1,200,TRUE)) returns ten random names at once, and =SORTBY(A2:A201, RANDARRAY(200)) shuffles the whole list. To freeze results, copy the column and Paste Special as Values.
Sample names for test data should avoid real people, look plausible for the region your product serves, and include enough variety in name length and origin to catch layout and sorting bugs. Names such as Ivy Sundqvist, Ezekiel Adebayo and Kai Matsumoto do exactly that job.
Tips for choosing a name
- Paste the names into a single column, then use =INDEX(range, RANDBETWEEN(1, ROWS(range))) to pull one at random; press F9 to redraw.
- In Excel 365 or Google Sheets, =SORTBY(range, RANDARRAY(ROWS(range))) shuffles the whole list in one formula, ideal for assigning random order or teams.
- Split names into first and last columns with Data, Text to Columns (delimiter: space) or with =TEXTBEFORE(A2," ") and =TEXTAFTER(A2," ") if you need separate fields.
- Convert random results to static values with Copy, Paste Special, Values before sharing, otherwise every recalculation changes the picks.
- For test databases, mix name lengths and origins so you catch truncation, sorting and Unicode bugs; a table of only short Anglo names hides problems.
Frequently asked questions
How do I pick a random name from a list in Excel?
Put the names in a column, for example A2:A201, then in another cell enter =INDEX(A2:A201, RANDBETWEEN(1, ROWS(A2:A201))). Press F9 to recalculate and draw a new name. RANDBETWEEN is volatile, so paste as values if you need to keep a result.
Can Excel generate random names by itself?
Not without a source list. Excel has no built-in name dictionary, so you supply a list of first names and surnames and combine them, for example =INDEX(First, RANDBETWEEN(1, ROWS(First)))&" "&INDEX(Last, RANDBETWEEN(1, ROWS(Last))). Copying the list from this page is the quickest way to get started.
How do I generate many random names at once in Excel?
In Excel 365, =INDEX(A2:A201, RANDARRAY(20,1,1,200,TRUE)) returns 20 random picks with possible repeats, and =TAKE(SORTBY(A2:A201, RANDARRAY(200)), 20) returns 20 unique names. In older Excel, fill the INDEX/RANDBETWEEN formula down as many rows as you need.
Are these names of real people?
No. They are randomly assembled combinations of common first names and surnames intended as sample or placeholder data. Any match with a real person is coincidental, so they are safe for demos, mock-ups and test databases.
All 500 random excel names
Browse the full list
- Olivia Bennett
- Liam Fitzgerald
- Emma Castellano
- Noah Whitfield
- Ava Lindqvist
- Elijah Okafor
- Sophia Marchetti
- James Holloway
- Isabella Nguyen
- Benjamin Sato
- Mia Delgado
- Lucas Andersson
- Charlotte Reyes
- Henry Kowalski
- Amelia Thornton
- Alexander Petrov
- Harper Osei
- Ethan Brennan
- Evelyn Marsh
- Sebastian Cruz
- Abigail Fontaine
- Jack Sullivan
- Emily Rasmussen
- Owen Takahashi
- Elizabeth Moreau
- Theodore Blake
- Sofia Vasquez
- Aiden Chowdhury
- Avery Lindgren
- Samuel Achebe
- Ella Prescott
- Joseph Ferreira
- Scarlett Dawson
- Levi Hartmann
- Grace Ishikawa
- Mateo Alvarez
- Chloe Whitaker
- David Mensah
- Victoria Lambert
- John Kavanagh
- Riley Sorensen
- Wyatt Beaumont
- Aria Kaplan
- Matthew Duarte
- Lily Okonkwo
- Luke Sandoval
- Aubrey Halvorsen
- Asher Nakamura
- Zoey Callahan
- Carter Lindstrom
- Penelope Ruiz
- Julian Novak
- Layla Hassan
- Grayson Pierce
- Nora Bergman
- Leo Santangelo
- Camila Odhiambo
- Jayden Kirkland
- Hannah Voss
- Gabriel Ortega
- Lillian Sheridan
- Isaac Bhatt
- Addison Reilly
- Lincoln Farrow
- Eleanor Vasiliev
- Anthony Romano
- Natalie Ferreira
- Hudson Abernathy
- Luna Espinoza
- Dylan Mackenzie
- Savannah Kim
- Ezra Goldstein
- Brooklyn Adeyemi
- Thomas Whitmore
- Leah Guerrero
- Charles Ostrowski
- Zoe Fairbanks
- Christopher Ma
- Stella Devereaux
- Jaxon Meyer
- Hazel Bakker
- Maverick Doyle
- Ellie Karlsson
- Josiah Mbeki
- Paisley Rowe
- Isaiah Barrera
- Audrey Lennox
- Andrew Fischer
- Skylar Ahmed
- Elias Thibodeaux
- Violet Harrington
- Joshua Perkins
- Claire Montague
- Nathan Ellingsen
- Bella Ramirez
- Caleb Winslow
- Lucy Ambrose
- Ryan Castellanos
- Anna Sokolova
- Adrian Marchand
- Caroline Whitley
- Miles Okoro
- Genesis Trujillo
- Eli Bradshaw
- Aaliyah Foster
- Nolan Kristiansen
- Kennedy Ashford
- Christian Ibarra
- Kinsley Nakagawa
- Aaron Halloran
- Allison Steinberg
- Cameron Fitzpatrick
- Maya Sinclair
- Ezekiel Adebayo
- Sarah Whitcombe
- Colton Ashby
- Madelyn Ochoa
- Landon Sorenson
- Adeline Rutherford
- Hunter Vaughn
- Alexa Petrakis
- Jonathan Mendes
- Ariana Cassidy
- Santiago Villarreal
- Elena Novakova
- Axel Lindberg
- Gabriella Marino
- Easton Pruitt
- Naomi Kessler
- Cooper Hemsworth
- Alice Tanaka
- Jeremiah Coleman
- Sadie Blackwood
- Angel Figueroa
- Hailey Drummond
- Roman Volkov
- Eva Sorrentino
- Connor Galbraith
- Emilia Ferrante
- Jameson Ridley
- Autumn Delacroix
- Robert Chandra
- Quinn Mahoney
- Greyson Falk
- Nevaeh Winters
- Jordan Abubakar
- Piper Ellsworth
- Ian McAllister
- Ruby Castellan
- Carson Ludwig
- Serenity Vance
- Jaxson Oyelaran
- Willow Hargreaves
- Leonardo Bianchi
- Everly Sandoval
- Nicholas Trask
- Cora Weatherby
- Dominic Farouk
- Lydia Ramsay
- Austin Beckett
- Clara Lindahl
- Everett Sinclair
- Vivian Okwuosa
- Elliot Rasmus
- Reagan Holt
- Xavier Delgado
- Mackenzie Boyd
- Jose Villanueva
- Madeline Archer
- Jace Whitworth
- Peyton Nystrom
- Kai Matsumoto
- Brianna Calloway
- Bryson Achterberg
- Isla Fenwick
- Ivan Dragomir
- Josephine Ashcroft
- Adam Sterling
- Margaret Okolie
- Brayden Kirchner
- Delilah Vega
- Emmett Halstead
- Athena Kouris
- Parker Winslow
- Iris Lindemann
- Rowan Blackwell
- Valentina Costa
- Silas Marchbanks
- Eliana Fadel
- Jasper Thorne
- Rose Ashworth
- Weston Caldwell
- Georgia Nakashima
- Amir Rahimi
- Sienna Whitlock
- Bennett Ostrander
- Ivy Sundqvist
- Daniel Whitehead
- Sophie Lindqvist
- Marcus Oyelowo
- Freya Hendricks
- Tobias Reinholt
- Priya Ramaswamy
- Oscar Delaney
- Imogen Falconer
- Rafael Montoya
- Harriet Blomqvist
- Felix Adeyinka
- Rosalind Carver
- Arjun Mehta
- Beatrice Lang
- Declan Murphy
- Yasmin Haddad
- Miguel Torres
- Eloise Fairweather
- Ravi Chandrasekar
- Martha Kingsley
- Diego Herrera
- Alina Petrova
- Callum Beattie
- Zara Siddiqui
- Patrick Nolan
- Frances Whitmarsh
- Kenji Watanabe
- Lorna Buchanan
- Idris Bello
- Ingrid Solberg
- Tomas Varga
- Nadia Karimi
- Bruno Almeida
- Heidi Aaltonen
- Vincent Okumu
- Juliet Pemberton
- Stefan Bauer
- Rhea Kapoor
- Cormac Doherty
- Amara Nwosu
- Peter Halvorsen
- Elsa Grondahl
- Anthony Baptiste
- Fiona Macleod
- Hugo Lefevre
- Tamsin Rooke
- Omar Sharif
- Kirsten Dahl
- Reuben Ashcroft
- Mila Novotna
- Louis Berger
- Bianca Ferraro
- Malik Johnson
- Celeste Rivard
- Erik Nyström
- Ayesha Rahman
- Alastair Grant
- Marisol Peña
- Jonah Blackburn
- Greta Lindholm
- Kwame Asante
- Philippa Renshaw
- Emil Kristoffersen
- Rosa Delgado
- Fergus Campbell
- Anika Sharma
- Wesley Trent
- Simone Beaulieu
- Ahmed Farouk
- Poppy Wilkinson
- Roland Meissner
- Carmen Iglesias
- Jerome Whitaker
- Elin Sjöberg
- Rory Gallagher
- Leila Nazari
- Gideon Marsh
- Nina Kowalczyk
- Marco Bellini
- Ada Okonjo
- Simon Pritchard
- Cassandra Vale
- Youssef Mansour
- Tessa Holbrook
- Aleksander Wojcik
- Maria Fernandes
- Duncan Roth
- Amelie Dubois
- Tariq Hussain
- Rebecca Stanhope
- Otto Lindgren
- Sunita Patel
- Bartholomew Cole
- Louisa Trevelyan
- Enzo Ricci
- Kaya Yilmaz
- Winston Achebe
- Genevieve Marlow
- Sven Eriksson
- Farah Qureshi
- Julian Whitlock
- Esme Sutherland
- Alonso Cabrera
- Meredith Frost
- Rashid Bello
- Astrid Halvorsen
- Gareth Llewellyn
- Nell Ashford
- Ibrahim Diallo
- Delphine Marchand
- Conrad Ostrowski
- Jade Whitcombe
- Mateus Oliveira
- Sigrid Andersen
- Percy Radcliffe
- Ana Lucia Serrano
- Reginald Okafor
- Willa Kirkpatrick
- Nikolai Sorokin
- Lucia Moretti
- Bram Van der Berg
- Kiara Desai
- Hamish Douglas
- Ottilie Fenwick
- Cyrus Rahimi
- Millie Sandford
- Anders Lund
- Ruth Abernathy
- Kofi Boateng
- Blanche Devereux
- Ignacio Ruiz
- Kirsty Macrae
- Elliott Vance
- Yuki Hayashi
- Benedict Alder
- Alma Rodriguez
- Jasper Whitfield
- Ottoline Grey
- Rowan Fitzwilliam
- Saoirse Byrne
- Emmanuel Adjei
- Vera Lindstedt
- Zachary Holm
- Isadora Vasquez
- Angus Ferguson
- Salma Elmasry
- Lorenzo Greco
- Karin Vestergaard
- Terrence Blackwood
- Anya Volkova
- Cillian Reagan
- Rosalie Thibault
- Rahul Iyer
- Petra Novak
- Marlon Ashby
- Ines Carvalho
- Bastian Fischer
- Thandiwe Mokoena
- Ellis Cartwright
- Zainab Yusuf
- Frederick Halloran
- Chiara Lombardi
- Nathaniel Osei
- Edith Whitmore
- Kasper Holt
- Leonie Baumann
- Malachy Quinn
- Serena Wakefield
- Alvaro Mendez
- Rita Sandoval
- Ewan Sinclair
- Adaeze Nnamdi
- Casimir Zielinski
- Sylvie Renaud
- Deshawn Carter
- Odette Laurent
- Ivar Magnusson
- Sara Lindahl
- Marcel Fontaine
- Bronwyn Hughes
- Nasir Malik
- Camille Roux
- Ansel Weber
- Maeve Cullen
- Guillermo Ortiz
- Roxanne Ellery
- Kieran Walsh
- Solveig Nilsen
- Boris Antonov
- Talia Rosenberg
- Emeka Obi
- Josie Marchbanks
- Rasmus Jensen
- Constance Hale
- Amos Whitfield
- Renata Souza
- Barnaby Lockwood
- Anneli Kallio
- Darius Petrakis
- Georgina Rowntree
- Yannick Moreau
- Selin Kaya
- Ellis Radford
- Mariam Osman
- Fabian Krause
- Verity Ashdown
- Toby Blackwell
- Aisling Doyle
- Rocco Marino
- Hana Kobayashi
- Wilfred Hastings
- Paloma Guerrero
- Sander Bakke
- Effie Calloway
- Uriel Benavides
- Nadine Schuster
- Cato Lindqvist
- Rania Aziz
- Griffin Sayers
- Lottie Farrant
- Ivo Petrov
- Priscilla Ndlovu
- Warren Ashcombe
- Chidera Eze
- Lars Pedersen
- Juno Whitlock
- Enrique Salazar
- Marguerite Blanc
- Silas Okoye
- Beatrix Lindemann
- Jarrod Kingsley
- Kavya Nair
- Absalom Grange
- Katya Morozova
- Bertram Cole
- Amira Khalil
- Cassius Fenn
- Rosanna Bianchi
- Teodor Novak
- Elodie Marchetti
- Kobe Mensah
- Wren Fairbanks
- Alfie Prescott
- Sunniva Berg
- Everard Locke
- Zofia Kaminski
- Malik Toure
- Ffion Rees
- Rupert Delacroix
- Ilse Van Dijk
- Julius Ferreira
- Mabel Thornbury
- Kwabena Owusu
- Rosalind Ashe
- Nikhil Rao
- Coral Winters
- Anselm Vogel
- Yara Sabbagh
- Piers Hollingsworth
- Danica Horvat
- Emrys Vaughan
- Cordelia Fox
- Santiago Beltrán
- Livia Rossi
- Torsten Kraus
- Ngozi Okwu
- Percival Ashworth
- Klara Sundberg
- Jethro Bramble
- Aurelia Sandström
- Riordan Kelly
- Suki Nakano
- Amadou Sow
- Hattie Longstaff
- Valentin Dumitru
- Colette Beaufort
- Ephraim Sanders
- Xiomara Reyes
- Baxter Ridley
- Alessia Conti
- Marley Osgood
- Helka Rantanen
- Obadiah Trent
- Isolde Marner
- Renzo Caruso
- Melody Whitworth
- Corin Ashgrove
- Zuri Adebayo
- Sylvester Halloway
- Odile Fournier
- Ludo Marchesi
- Perpetua Nwachukwu
- Vaughn Kingsley
- Britta Holmgren
- Adil Rehman
- Clementine Ross
- Tadeo Villalobos
- Nadira Osei
- Hamza Choudhury
- Fenella Grieve
- Ansel Whitford
- Bettina Roth
- Caspian Ellery
Related generators
Random Name Generator in Excel
Build a random name picker with Excel formulas or VBA
AI Email Name Generator
Professional and Personal Email Address Ideas
Chatbot Name Generator
Names for AI assistants, support bots and virtual agents
Random African American Name Generator
Authentic Black American First and Last Names
Random Mexican Name Generator
Real Mexican First Names and Surnames
Random Arabic Name Generator
Real Arabic First Names and Family Names
More in Technology & Internet
Search Engine Name Generator
Brandable names for search engines, finders and discovery tools
Minecraft YouTube Name Generator
Channel Names for Minecraft Creators, Builders and SMPs
GitHub Name Generator
Memorable GitHub usernames, org names and handles
UwU Name Generator
Cutesy uwu usernames for Discord, Twitch and TikTok
Blog Name Generator
Unique, Brandable Blog Name Ideas by Niche
Funny Email Name Generator
Hilarious Email Usernames That Are Still Typeable