[CSV] How Can I Make a List of Words to be Random Instead of Alphabetical

2 min. readlast update: 11.06.2024

[The below can be done in an excel file / google sheets file or CSV file]

You have a list of words that are sorted alphabetically and you want them to be in random order for a word search. Just follow the steps below.

Your list will look something like this below in alphabetical order inside your .csv file.

undefined

Click on cell B1 and enter =rand() like you see below

undefined

Press the enter key on your keyboard and a random number will appear (odds are it will not be the same as below, since this formula is creating a random number).

Now click the cell one time. Double click on the little square on the bottom right of the cell. This will fill column B to the same row as Column A has information in it. Or you can left click on the square while holding down left mouse button and drag it down the column.

undefined

Next click the triangle at top left of cells to highlight the whole excel sheet.

undefined

Click the "Data" on the menu, and then click on the "Sort". Change sort by to Column B, press "OK".

undefined

Now your words in column A are randomized.

undefined

Now you need to click on column B to hightlight it all, then right click and pick delete.

undefined

Now save your file. But don't forget to make an empty row every 10, 12, 15, 20, or however many words you are putting into each word search. Then save again and it is ready to use.

Was this article helpful?