To get a word cloud in Excel, paste the text from your cells into the Word Cloud Generator, generate the preview, download the 1200-by-800-pixel PNG, and insert it into the workbook as a picture. The Word Cloud Generator turns an Excel-derived text block into a visual summary in which repeated terms receive larger type. The tool's input is a Text field rather than a workbook upload, so the practical route is to copy the relevant cell values first. All token counting, layout, drawing, and PNG creation happen locally in your current browser; your text is not uploaded to Lizely, sent to an analysis service, or saved to an account. This makes the workflow suitable for unpublished drafts, internal notes, student writing, and other text you do not want submitted to a remote processor. In Excel, the final object is a static image rather than a live chart, so regenerate and replace the picture after the source text changes. The image is useful for slides, documents, classroom materials, and social posts, but it should support your analysis rather than replace it.
Prepare the source text in Excel
The generator works from pasted text rather than Excel's row-and-column structure. Select the cells containing the language you want to analyze, copy them, and paste the resulting text into the generator. Cell borders, fill colors, number formatting, and charts do not become part of the visual; the tool extracts letter-and-number tokens from the text you supply.
Before copying, remove headers, navigation labels, names, boilerplate, or repeated instructions that do not represent the material. Repeated text receives larger type, so a footer copied across every row can outweigh the main subject. If a survey response includes an ID number, remove it when it is irrelevant because numbers can also be counted as tokens.
| Excel source | Best preparation | Effect on the cloud |
|---|---|---|
| One column of terms | Copy the cells and omit an irrelevant header | Repeated terms in that column compete by frequency |
| Many rows of responses | Copy only the relevant response text | Recurring language across responses becomes visible |
| Several relevant columns | Combine them into one pasted text block | All copied tokens enter the same frequency comparison |
| Headers, labels, or IDs | Delete them from the source or exclude them | Prevents boilerplate or numeric IDs from taking visual space |
Copying one column is useful when each cell contains a word or short phrase. Combining several columns can reveal repeated language across responses or records, but every copied term enters the same frequency comparison.
Generate the cloud from copied Excel text
Once the relevant cells are ready, use the following workflow to create and export the graphic.
- Copy the relevant Excel cells. Highlight the cells containing the words, responses, or notes you want to visualize and copy the displayed text. Leave unrelated records outside the selection.
- Paste into the Text field. Open the Word Cloud Generator and paste the copied content into its editor. The formatted range becomes a text input, so its row and column structure is not retained.
- Configure the optional rules. Enter unwanted terms in the Exclude words field. Leave case handling at its default setting to combine uppercase and lowercase forms, or enable the case-sensitive option when capitalization itself matters.
- Select Generate word cloud. The browser counts the extracted tokens and builds a preview in which more frequent words receive larger type.
- Review the preview and placement report. Confirm that the intended terms appear and read the message reporting how many words were placed and whether any terms did not fit.
- Download the full-size PNG. Download the generated image after the preview looks right. The export uses the full 1200-by-800-pixel canvas rather than a reduced screenshot of the on-page preview.
Because the export is a PNG, it captures the completed design rather than creating an editable Excel chart. Keep the downloaded file available for insertion into the worksheet.
Set exclusions and capitalization before generating
The settings determine which tokens compete for space in the visualization. Make those decisions before judging the final layout, and regenerate the cloud whenever you change an exclusion or case preference.
| Setting or limit | How it works | Practical response |
|---|---|---|
| Capitalization | Uppercase and lowercase forms are combined by default | Enable the case-sensitive option when forms such as “Cloud” and “cloud” should remain separate |
| Excluded terms | There is no built-in stop-word dictionary | Add unwanted words to the Exclude words field, then generate again |
| Word boundaries | Common punctuation separates words, while an internal apostrophe or hyphen can remain part of a term | Review unusual tokens and clean the source when punctuation was not intended as part of a word |
| Candidate limit | Up to 80 of the most frequent terms are considered | Remove low-value text, add exclusions, shorten long tokens, or focus on one section if terms are omitted |
| Export size | The generated canvas is 1200 × 800 pixels | Insert the downloaded PNG directly into the Excel worksheet |
Exclusions use the same tokenization and case setting as the main text. For example, an English article might have “the” and “and” excluded, while survey feedback may leave every term visible. Token matching is Unicode aware, allowing words written in many non-English scripts to be counted. The browser also applies compatibility normalization before counting so visually compatible forms are treated consistently.
Insert the PNG into your Excel worksheet
After downloading the image, add it to the workbook as a normal picture.
- Save the downloaded PNG. Keep the file in a location you can browse from Excel.
- Choose the worksheet position. In desktop Excel, select the cell where you want the upper-left area of the graphic to appear.
- Insert the picture. Open the Insert tab, choose Pictures, and select This Device.
- Browse for the PNG. Locate the downloaded word-cloud file, select it, and confirm the insertion.
- Move and resize the graphic. Drag the image into position and use a corner handle to resize it while preserving its proportions.
- Save the workbook. The word cloud remains a static image, so repeat the export and insertion process when the underlying text changes.
The image's natural export dimensions are 1200 × 800 pixels, which makes it suitable for a worksheet, slide, document, classroom handout, or social post. It does not remain connected to the Excel cells after insertion, so the downloaded PNG should be treated as a snapshot of the text at the time it was generated.
Interpret frequency without overreading the image
A word cloud is a frequency display, not a judgment of meaning. Font sizes are scaled by the square-root of frequency, so a larger word indicates more occurrences, but its size should not be used to estimate an exact count. The generator does not perform language detection, semantic analysis, sentiment analysis, or topic modeling.
- Frequency is not importance. Repeated boilerplate, quotations, names, navigation labels, and copied footers can dominate the visual even when they do not represent its central idea.
- Some terms may be skipped. The tool measures each candidate with the browser's canvas text metrics and places terms along a deterministic spiral from the center. A word is skipped when its rectangle cannot fit without crossing the canvas boundary or another word.
- Results are repeatable. The same input and settings produce the same arrangement, so an unchanged cloud will not shift unpredictably between renders.
- Long and crowded inputs need attention. An extremely long token, a large number of unique words, or a crowded cloud can leave less room for placement. The status message identifies when some terms did not fit.
Use a separate word-count or text-analysis workflow when you need an auditable numerical audit. For example, Word Counter can provide an overall total, while a suitable analysis workflow can supply exact per-term counts. Read the original material and apply human judgment before drawing a consequential conclusion from the graphic.
Keep Excel text private during the workflow
Counting, layout, canvas drawing, and PNG creation all happen locally in the current browser. Your pasted Excel text is not uploaded to Lizely, sent to an analysis service, or stored in an account, which is useful for unpublished drafts, internal notes, student writing, and confidential working material.
Local processing protects the text during generation, but it does not identify sensitive information or control where you share the finished image. Review the preview, remove unwanted terms where necessary, and inspect the downloaded PNG before placing it in a shared workbook or publishing it. Keeping the source file and exported image in appropriately controlled locations completes the workflow without turning a frequency visualization into a substitute for careful review.
If you're weighing options, How to Count Words in a Word Document covers this in detail.
If you're weighing options, How to Solve Scrambled Words: A Word Scrambler Workflow covers this in detail.