To find which words appear most often in a list of sentences, such as survey comments or product reviews, Power Query can split the text into words, count each one and sort the list, all refreshable with one click.
The data
Step 1: Load the data
Click in the list and go to Data → From Table/Range.
Step 2: Make the words comparable
Select the text column and apply Transform → Format → lowercase, so The and the count as one word. If the text has commas or full stops, replace them with nothing using Transform → Replace Values.
Step 3: Split into words
Home → Split Column → By Delimiter, choose Space and click OK. Each word goes into its own column.
Tip: under Advanced options, choose Split into Rows to skip Step 4.
Step 4: Unpivot into one column
Right-click the first column header and choose Unpivot Other Columns, then remove the ID and Attribute columns. All 659 words are now in one column.
Step 5: Count each word
Right-click the word column → Group By, choose Count Rows and name the new column Count.
Step 6: Sort and keep the top 10
Sort Count descending, then Home → Keep Rows → Keep Top Rows → 10. Rename the column Words and Close & Load To a cell on your sheet.
Add more sentences to the source and click Refresh: the counts update.
Remove common words
Little words like the, is and to usually top the list. Keep a one-column table of words to ignore, load it as a connection, and use Merge Queries with a Left Anti join to remove them. See Joins in Power Query.