How to create an Excel word cloud (3 methods)

Excel has no built-in word cloud. Microsoft’s own list of available chart types in Office runs from column and bar charts to maps and funnels, and a word cloud is not on it. So an Excel word cloud always means doing one of three things: install an add-in, paste your column into a free generator, or send the data to Power BI.

This guide walks through all three with the same example: a column of one-word answers from a workshop feedback form. If you want a tool roundup instead, see our comparison of collaborative word cloud tools.

Prepare the column first (all three methods)

Every method reads a list of words, so a little tidying in Excel pays off. Here is the sample data we used: 20 answers to “In one word, how did the workshop feel?” typed into A2: A21, with “Answer” as the header in A1.

1. Trim and lowercase. A stray trailing space makes “clear ” and “clear” count as two different words in COUNTIF. In B2 enter =LOWER(TRIM(A2)) and fill down. See Microsoft’s guides to TRIM dan RENDAH.
2. Remove stop words. For free text (sentences rather than single words), filter out words like “the”, “and” and “is” so they do not dominate the cloud.
3. Count the words. Copy B2:B21 to D2, select those cells and choose Tarikh, Maka Keluarkan Duplikat (see Microsoft’s remove duplicates guide). In E2 enter =COUNTIF($B$2:$B$21,D2) and fill down (see COUNTIF). On Microsoft 365, Excel 2021 or later you can skip Remove Duplicates and enter =UNIQUE(B2:B21) in D2 instead (UNIK).

For our sample the frequency table comes out like this, which gives you something to check each word cloud against:

A word cloud shows relative size only, so keep this table next to it when exact counts matter. Our own cloud made from the same column is further down.

Method 1: use an Excel add-in

An add-in builds the cloud inside Excel, so the words stay linked to your sheet. A well-known option is Bjorn’s Word Clouds. It is not free: the developer lists a subscription of $8.95 a month with a 7-day free trial, so check the current price before you commit.

Install the add-in

1. Buka Memasukkan tab dan klik Dapatkan Add-in.
2. In the Office Add-ins store, search for “word cloud”.
3. Klik Tambah next to “Bjorn’s Word Clouds”.

Generate the cloud

1. Pergi ke Memasukkan, Maka Tambah Saya, and open the add-in. Its panel appears on the right of your sheet.
2. Select your word list (or your word and count columns). The add-in picks up the selected range.
3. Choose the font, colours, layout and word orientation, and set how many words to show.
4. Export the cloud as an image, an animated GIF or a web page.

Method 2: paste your column into a free online generator

If you do not want to install anything, copy the column and paste it into a web tool. The AhaSlides penjana awan perkataan secara langsung works this way: no sign-up is needed to try it, and each repeated word makes that word larger.

Worked example with our 20 answers

1. In Excel, select B2: B21 (the cleaned words) and press Ctrl + C.
2. Open the generator and paste into the kata-kata awak box. Each line is read as one word.
3. Klik Menjana. The tool reported “6 unique words”, the same six as our frequency table.
4. Penggunaan Warna, Fon, Latar Belakang dan Sudut to restyle it, Susun atur kocok to rearrange it, then Muat turun PNG.

Because the tool counts repeats, you can paste the raw column and skip the COUNTIF step. Paste the cleaned column all the same: it keeps your COUNTIF table and the cloud in step, and not every tool ignores stray spaces.

Need the audience to supply the words live instead of collecting them in Excel first? That is what the AhaSlides slaid awan perkataan is for: people type answers on their phones and the cloud builds on screen. Our live word cloud examples show where it works well.

Method 3: use Power BI

Power BI suits you when you have thousands of rows. It does not ship a word cloud in its standard visuals, so you add one from AppSource first.

Connect your workbook

1. In Excel, select your text column and press Ctrl + T to make it a table. Give the table a clear name such as “WordData”, then save the file.
2. Open Power BI Desktop (a free download from microsoft). Pada Laman Utama tab choose Get data, Maka Buku kerja Excel, and open your file. Microsoft’s guide to connecting to Excel merangkumi pilihan-pilihan.
3. Dalam Navigator, tick your table and click Muatkan.

Add the word cloud visual

1. Dalam visualizations pane, click the ellipsis (…) and choose Get more visuals.
2. Search AppSource for “Word Cloud” and click Tambah. Microsoft explains this step in its guide to importing visuals from AppSource.
3. Select the new Word Cloud icon, then drag your text column into the kategori field. Power BI counts how often each word appears and sizes it to match.

Kaedah yang manakah patut anda pilih?

Tips for a readable Excel word cloud

• Clean first: lowercase, trim spaces and strip stop words and punctuation.
• If the words are spread over many cells, join them with =TEXTJOIN(" ",TRUE,A2:A51). TEXTJOIN needs Excel 2019 or later (see Microsoft’s TEXTJOIN guide).
• Merge near-duplicates (“meeting” and “meetings”) before counting.
• A cloud shows rank at a glance but not exact numbers. Pair it with the frequency table or a bar chart when someone needs the figures, as in the table above.