• Skip to main content
  • Skip to secondary menu
  • Skip to primary sidebar
  • Skip to footer
WebSetNet

WebSetNet

Technology News

  • Technology News
    • Mobile
    • Games
  • Internet Marketing
  • System Admin
    • Windows 11
    • Linux
    • Mac & Apple
    • Website Scripts
      • Wordpress

How to create a Word Cloud in Microsoft Excel

May 16, 2021 by billy16

Word Cloud or Tag Cloud is a kind of graph used to visualize important keywords and tags used in a text data. It is generated based on the frequency and prominence of words used in text. In this guide, I will be sharing a tutorial on how to create a word cloud in Microsoft Excel.

Before I start, let me mention that there is no native feature in MS Excel that lets you generate a word cloud. However, there are some add-ons that you can install to create tag clouds in it, like Bjorn’s Word Clouds, ChartExpo, etc. But, most of them are paid and others are trials. To add a word cloud in Excel for free, you will need to try a simple trick that I am going to share in this article. I will be using a free online word cloud generator service to create a tag cloud from Excel data and then import it into Microsoft Excel. Let’s checkout the web service and steps for doing so.

How to create Word Cloud in Excel

Basic steps to add a word cloud in Excel are:

  1. Create a worksheet in Excel and export it in XLSX format.
  2. Launch a web browser and open WordClouds.com website.
  3. Import created Excel file to it, generate a tag cloud, customize the word cloud, and export it to an image file.
  4. Go to Excel and add the saved word cloud image to your spreadsheet.

Let’s discuss these steps in detail.

Firstly, you need to create a spreadsheet or open an existing one in Excel, for which you want to generate a word cloud. After adding your data to the spreadsheet, save it in XLSX Excel format using the File > Save As option.

Now, open a web browser and go to this web service called WordClouds.com. This web service lets you create a word cloud from Microsoft Office documents, text files, and PDFs.

Next, go to the File menu and click on the Open MS Office document option to import the Excel spreadsheet file you created.

After that, it will analyze and process your XLSX spreadsheet and generate a word cloud from the imported Excel data. You can then customize a lot of parameters to edit the word cloud accordingly.

For example, it allows you to change word cloud size, customize gap size between words, select a theme, edit colors, change font type and size, choose direction of words, etc. It also lets you select a shape for the word cloud from various available shapes and letters.

You can also manually edit the word list fetched from Excel data by clicking on the Word list button. Additionally, it allows you to import a custom word list or export the current list to a CSV file.

When done with customizing your word cloud, you can download it as a normal or HD image in JPG, PNG, or SVG file format using its File > Save as Image options.

Now again go to the spreadsheet in Microsoft Excel, and from the Insert tab, click on Illustrations > Pictures > This Device option.

This will allow you to browse and import the word cloud image that you downloaded previously. It will be added to the Excel sheet and you can place it anywhere in the spreadsheet. Furthermore, you can arrange, resize, crop, change picture style, and format added word cloud graphic.

This article shows you an easy method to create a word cloud from Excel data and then add it to your Excel worksheet using a free online service. Try it and add tag clouds to Excel worksheets without much hassle.

Original Article

Related posts:

  1. How to Use Excel Like a Pro: 18 Easy Excel Tips, Tricks, & Shortcuts
  2. How to Learn Excel Online: 17 Free and Paid Resources for Excel Training
  3. Microsoft Excel Basics Tutorial – Learning How to Use Excel
  4. How To Import Passwords Into Chrome From CSV File
  5. How to Securely Password Protect an Excel File
  6. How to Record a Macro in Excel
  7. How to Cross Reference Cells Between Excel Spreadsheets
  8. How To Start A Premium WordPress Blog (Step-by-Step Guide)
  9. The Ultimate Guide to Google Sheets
  10. Introducing the new Microsoft 365 Personal and Family subscriptions

Filed Under: Windows 11 Tagged With: cloud, excel, Microsoft, word

Primary Sidebar

Trending

  • 5 Ways to Fix “Your SIM sent a Text Message” Issue on iPhone
  • 3 Ways to Disable GetApps on Xiaomi, Redmi, and Poco Phones Running MIUI
  • 8 Best Sites to Read Manga Online for Free
  • How To Extract & Install tar.gz Files In Ubuntu
  • How to find a lost Apple Pencil using your iPad (1st and 2nd gen)
  • How to Highlight Duplicates in Google Sheets
  • GeForce Experience not finding games? Fix it fast
  • How to Track a Stolen or Lost Nintendo Switch
  • Discord Stream Has No Sound? 6 Ways to Fix
  • Troubleshooting “E: Unable to locate package” Error on Ubuntu [Beginner’s Tutorial]
  • How To Calculate CAGR in Excel
  • Exclamation Mark on Network Signal, Mobile Data Not Working? 8 Ways to Fix
  • How to Fix YouTube Server Connection Error [400] on Android
  • What is Android System Intelligence, and why is it on your phone?
  • How to Make Any Wired Printer Wireless in 6 Different Ways
  • How to check if your Android device supports Widevine DRM
  • How to Change the Last Modified Date, Creation Date, and Last Accessed Date for Files and Folders
  • 17 Cool Arduino Project Ideas for DIY Enthusiasts

Footer

Tags

Amazon android Apple Asus available download: edge feature features first free from galaxy Game games gaming gets google install Intel iPhone launches linux Microsoft more OnePlus phone release released review: samsung series support this Ubuntu update using video watch what will windows with xbox your

Archives

  • September 2023
  • August 2023
  • July 2023
  • June 2023
  • May 2023
  • April 2023
  • March 2023
  • February 2023
  • January 2023
  • December 2022
  • November 2022
  • October 2022
  • September 2022
  • August 2022
  • July 2022
  • June 2022
  • May 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • September 2021
  • August 2021
  • July 2021
  • June 2021
  • May 2021
  • April 2021
  • March 2021
  • February 2021
  • January 2021
  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • August 2020
  • July 2020

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org