Create word cloud in excel

Creating word clouds using text2data’s Excel Add-in.

  Word cloud is a visual representation of words used in a particular piece of text or series of texts. Tags are usually single words, and the importance of each word is shown with font colour and size. It is a splendid way to reveal the essential data. Word cloud has another advantage – it is quick to create using our Excel Add-In. Thus, you save your time and you do not have to analyse every single sentence by your own. Automated process will do it for you in just a few moments. Word clouds are not only more visually attractive than a table of data but also they are really easy to understand.

To generate word cloud using text2data’s Excel Add-In, select your text data and run the analysis. When analysis is done, click “Create word cloud” icon and wait a few moments. The word cloud will be displayed in a new sheet presenting the most essential words from your text document. It is worth to mention, the word size is driven by its sentiment and number of occurrences.

In ‘Service Settings’ you can configure word cloud according to your needs.
(1) You can set the word cloud to display revealed data with the colour of the sentiment of each word/phrase or just set the colour to display it in a random way. By default, the Add-in displays sentiment in six colours. For negative it is red and dark red, for neutral grey and dark grey and for positive green and dark green – which depends on sentiment level.
(2) However, you can adapt colours according to your needs and set custom colours for each sentiment.
(3) Moreover, the type of word cloud can be set too – you can switch between circular or in-line style.
(4) You can also adjust the minimum and maximum size of font according to your preferences.
(5) Setting the font family will let you change the overall look and feel of the word cloud.

Below you can find prepared examples of word clouds. Each of them contains different configuration which is set in ‘Service Settings’.

To start creating word clouds using our Excel Add-in click here and download the tool. If you had used Excel Add-in before, please download and install it once again to have a current version [3.5.1].