词云(Word Cloud )或标签云( Tag Cloud)是一种用于可视化文本数据中使用的重要关键字和标签的图表。它是根据文本中使用的单词的频率和突出度生成的。在本指南中,我将分享一个有关如何在Microsoft Excel中创建词云的教程。
在开始之前,让我提一下MS Excel中没有可以让您生成词云的原生功能。但是,您可以安装一些附加组件来在其中创建标签云,例如Bjorn 的词云、ChartExpo(Bjorn’s Word Clouds, ChartExpo)等。但是,它们中的大多数是付费的,而其他的是试用版。要在Excel(Excel)中免费添加词云,您需要尝试我将在本文中分享的一个简单技巧。我将使用免费的在线词云生成器服务从Excel数据创建标签云,然后将其导入Microsoft Excel。让我们检查一下 Web 服务和这样做的步骤。
如何在 Excel 中创建词云
在Excel(Excel)中添加词云的基本步骤是:
- 在Excel(Excel)中创建工作表并以XLSX格式导出。
- 启动 Web 浏览器并打开WordClouds.com网站。
- 将创建的Excel(Excel)文件导入其中,生成标签云,自定义词云,并将其导出为图像文件。
- 转到Excel并将保存的词云图像添加到您的电子表格中。
让我们详细讨论这些步骤。
首先,您需要创建一个电子表格或在Excel(Excel)中打开一个现有的电子表格,您要为其生成一个词云。将数据添加到电子表格后,使用“ File > Save As”选项将其保存为XLSX Excel格式。
现在,打开一个 Web 浏览器并转到这个名为WordClouds.com的 Web 服务。此 Web 服务可让您从Microsoft Office 文档、文本文件(Microsoft Office documents, text files,)和PDF(PDFs)创建词云。
接下来,转到“文件(File)”菜单并单击“打开 MS Office 文档”(Open MS Office document )选项以导入您创建的Excel电子表格文件。
之后,它将分析和处理您的XLSX电子表格,并从导入的(XLSX)Excel数据生成词云。然后,您可以自定义很多参数来相应地编辑词云。
例如,它允许您更改(change) 词云大小、自定义单词之间的间隙大小、选择主题、编辑颜色、更改字体类型和大小、选择单词的方向(word cloud size, customize gap size between words, select a theme, edit colors, change font type and size, choose direction of words, )等(select a shape)。它还可以让您从各种可用的形状和字母。
您还可以通过单击单词列表(Word list)按钮手动编辑( edit the word list)从Excel数据中获取的单词列表。(Excel)此外,它还允许您导入自定义单词列表或将当前列表导出到CSV文件。
完成自定义词云后,您可以使用其“File > Save as Image选项将其下载为JPG、PNG或SVG文件格式的普通或高清图像。
现在再次转到Microsoft Excel中的电子表格,然后从“插入(Insert)”选项卡中,单击“Illustrations > Pictures > This Device 选项。
这将允许您浏览和导入您之前下载的词云图像。它将被添加到Excel工作表中,您可以将其放置在电子表格中的任何位置。此外,您可以对添加的文字云图形进行排列、调整大小、裁剪、更改图片样式(arrange, resize, crop, change picture style,)和格式。(format)
本文向您展示了一种从Excel数据创建词云的简单方法,然后使用免费的在线服务将其添加到Excel工作表中。(Excel)尝试一下,轻松地将标签云添加到Excel工作表中。
相关阅读:(Related Read:) 在 PowerPoint 中创建词云。(Create a Word Cloud in PowerPoint.)
How to create a Word Cloud in Excel
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:
- Create a worksheet in Excel and export it in XLSX format.
- Launch a web browser and open WordClouds.com website.
- Import created Excel file to it, generate a tag cloud, customize the word cloud, and export it to an image file.
- 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.
Related Read: Create a Word Cloud in PowerPoint.