Draw every workshop participant once from a pasted roster
Admin ·
A workshop needs a random order for three introductions. Two spreadsheet rows show the same name with different accent encodings. Start with one chance per participant, then compare a round that keeps both rows.
Load three participants from four roster rows
Select Load example. The input has four lines. The first and last lines both spell Amélie, once with a precomposed é and once with a combining accent. The two other lines are نور and Ren Ito.
Merge matching names compares NFC-normalized, lowercase forms after trimming outer whitespace. The tool reports 3 entries loaded and 1 duplicate merged. The Available names list shows Amélie, نور and Ren Ito.
Unicode Standard Annex #15, Unicode Normalization FormsAback Tools Random Name Picker
Draw the complete introduction order
Keep Remove selected entry after each draw checked. Select Draw a name three times, waiting for each result. The available count falls from 3 to 2, then 1 and 0. The history contains each of the three names exactly once in a random order.
The wheel keeps the sectors from the completed draw so the pointer still identifies that result. The Available names list shows the entries eligible for the next draw. At zero, select Reset round to restore all three names and clear the draw history.
Keep both entries when the same name represents two people
Change Duplicate names to Keep every entry, and select Load roster with the same input. The tool now loads four entries. Two rows look like Amélie. Each row can be drawn once even when removal is enabled.
Add an initial to each of those rows if the two spellings refer to different people. Reload the roster and use the history to verify which person was selected. Leave One per line selected for roster entries written as Family, Given.
Common questions
Can I bring my roster from a text file?
Select Open UTF-8 roster. Review the imported text and choose a separator before selecting Load roster. Your browser reads the file locally.
Will the roster and history return after a reload?
The roster and recent draw history live in the active tab during the session. Reload the original roster file to start a new session.