Google 表格(Google Sheets)是Microsoft Excel的一个很好的免费替代品。谷歌表格(Google Sheets)最好的部分是你可以安装各种插件来增强工作流程。通过使用附加组件,您可以节省大量宝贵的时间。以下是一些有助于提高工作效率的 Google 表格插件。(add-ons for Google Sheets)
最佳 Google 表格插件
1]电动工具(1] Power Tools)
PowerTools是一个非常有用的Google 表格(Google Sheets)插件,可帮助用户删除所有空格、前导/尾随空格、单词之间的空格、HTML实体、分隔符、非打印字符、子字符串、逐位字符、空行/列、等等。除此之外,您还可以将文本转换为数字、将文本转换为符号、包括各种数学公式、清晰的格式等等。当有人犯了错误或有人需要一次更改几件事时,它基本上可以帮助用户。
2]另存为文档(2] Save As Doc)
很多时候,我们希望以.docx 格式保存Excel工作表。(Excel)如果您是其中之一,并且使用Google 表格(Google Sheets),您可以轻松地将Google 表格制作的任何电子表格转换为可以使用(Google Sheets)Google Docs打开的 .docx 文件。您也可以将转换后的文件保存在本地硬盘上。要开始使用,请下载SaveAsDoc插件。启动后,您将看到一个侧边栏。现在,选择电子表格中的所有行和列,在边栏中命名您的文档文件,然后点击Save as Doc按钮。
3]高级查找和替换(3] Advanced Find and Replace)
尽管Power Tools可以很好地完成这项工作,但如果您想要一个具有简单功能的简单用户界面来查找和替换一些值或注释,您可以选择Google Sheets的(Google Sheets)AdvancedFindandReplace插件。您可以一次查找和替换多个值、公式、注释、超链接等。最好的部分是您可以选择是否需要在所有打开的工作表或当前工作表中执行任务。
4]电子邮件地址提取器(4] Email Address Extractor)
假设您有一家在线业务,并且您已经向/从您的客户发送和接收了大量电子邮件。现在您要提取所有这些电子邮件地址以用于促销目的。使用这个用于谷歌表格的(Google Sheets)EmailAddressExtractor插件——它可以让你一次提取所有的电子邮件地址。但是,唯一的限制是您只能提取前 500 个电子邮件地址作为免费用户。安装此插件后,您需要选择Gmail标签(收件箱(Inbox)、垃圾邮件(Spam)、已发送(Sent)或任何内容)、主题行、包含的字词和字段。还可以添加高级过滤器——例如从公司提取 30 天之前的电子邮件ID 。(IDs)
5]翻译我的工作表(5] Translate My Sheet)
如果您经常需要在Google 表格(Google Sheets)中将文本从一种语言转换为另一种语言,您可以使用两种方法。首先(First),您可以从电子表格中复制文本,将其粘贴到谷歌翻译器(Google Translator)中,再次从那里复制并粘贴到电子表格中。当您在工作表中有数百行时,这是一项耗时的工作,您可以选择一个插件,让您一次转换整个工作表。它被称为TranslateMySheet。您可以将整个电子表格或任何特定范围从当前语言转换为任何其他语言。它速度很快,而且做得很好。
Google 表格还有数百个其他附加组件,但这些可能是最有用的工具。(There are hundreds of other add-ons for Google Sheets, but these are probably the most useful tools out there.)
Best Google Sheets add-ons to improve productivity
Google Sheets is a good free alternative to Microsoft Excel. The best part of Google Sheets is that you can install various add-ons to enhance the workflow. You can save a lot of valuable time by making use of an add-on. Here are some add-ons for Google Sheets that will help improve your productivity.
Best Google Sheets add-ons
1] Power Tools
PowerTools is a very helpful Google Sheets add-on that helps users in removing all spaces, leading/trailing spaces, spaces between words to one, HTML entities, delimiters, non-printing characters, substring, character by position, empty rows/columns, etc. Apart from that, you can convert text to number, text to sign, include various mathematical formulas, clear formatting, and much more. It basically helps users when someone has made a mistake, or someone needs to change several things at once.
2] Save As Doc
Many times, we want to save an Excel sheet with a .docx format. If you are one of them, and you use Google Sheets, you can easily convert any spreadsheet made by Google Sheets into a .docx file that would open with Google Docs. You can save that converted file on your local hard drive as well. To get started, download the SaveAsDoc add-on. After starting it, you will see a sidebar. Now, select all the rows and columns in the spreadsheet, name your document file in the sidebar and hit the Save as Doc button.
3] Advanced Find and Replace
Although Power Tools can do the job pretty well, if you want a simple user interface with simple functionalities to find and replace a few values or notes, you can opt for AdvancedFindandReplace add-on for Google Sheets. You can find and replace multiple values, formulas, notes, hyperlinks, etc. at once. The best part is that you can choose whether you need to perform the task in all opened sheets, or current sheet.
4] Email Address Extractor
Let’s assume that you have an online business and you have sent and received tons of email to/from your customers. Now you want to extract all those email addresses for promotion purpose. Use this EmailAddressExtractor add-on for Google Sheets – it will let you extract all the email addresses at once. However, the only restriction is that you can extract only first 500 email addresses being a free user. After installing this add-on, you need to select a Gmail label (Inbox, Spam, Sent, or anything), subject line, included words, and fields. It is also possible to add advanced filters – eg to extract email IDs from a company which came before 30 days.
5] Translate My Sheet
If you often need to convert text from one language to another in Google Sheets, you can use two methods. First, you can copy the text from a spreadsheet, paste it in Google Translator, again copy it from there and paste it in the spreadsheet. As it is a time-consuming work when you have hundreds of rows in a sheet, you can opt for an add-on that will let you convert the whole sheet at once. It is called TranslateMySheet. You can convert the whole spreadsheet or any particular range from the current language to any other language. It is fast and does the job pretty well.
There are hundreds of other add-ons for Google Sheets, but these are probably the most useful tools out there.