There are sites where you can upload lists and pick a random winner, but it's probably best not to upload information to random sites. Here's how you can do it in Excel:

  • Click on the uppermost cell of your list after the final column of actual information
  • In the formula bar, type: =RAND() 
  • That will generate a random number in the cell, like 0.57450713
  • Double click the lower right corner of that cell to run the random list of numbers all the way down the column.
  • Sort the sheet based on that column.

What it does, is assign a random number to each row, then you sort, putting those random numbers in order, but mixing up everything else. BOOM! Just pick the new first X number of rows as your winners --- totally random!

rand