以前，我们写过Google Docs 和 Microsoft Word 之间的区别(differences between Google Docs and Microsoft Word)，在这篇文章中，我们将讨论电子表格。
电子表格是我们现代社会的支柱。电子表格对工作、记录保存、协作或个人组织很有用。目前，我们在电子表格领域拥有两个顶级竞争者——Google Sheets和Microsoft Excel。
在这两个电子表格应用程序中，我们希望更深入地了解两者之间的差异，并了解哪个更好。快速浏览一下，事实证明两者都有其优点和缺点，但Excel和Google 表格(Google Sheets)之间的差距正在日益缩小。以下是您需要了解的关于仍然存在的差异的信息。
功能 - Excel 胜出
当Google 表格(Google Sheets)首次推出时，它远远落后于Excel。这也不足为奇。Excel已经存在了几十年，微软(Microsoft)推出定期迭代的时间比我还活着的时间还要长。
微软(Microsoft)的麻烦在于，谷歌(Google)很快就赶上了。今天，Excel和Google 表格(Google Sheets)之间的功能非常相似。这两个程序都有易于掌握的界面、广泛的知识库以及大量的工具和功能。
但是，如果您需要更高级的功能或处理大量数据，我发现Excel更合适。Google 表格在一定程度上得到了很好的优化——随着您的表格填充更多的列、行和数据选项卡，我发现它与(Sheets)Excel相比开始变慢。
如果您需要轻松的体验来访问和管理数千个数据单元格，那么Excel是赢家。但是，如果您只需要使用少量命令创建简单的电子表格，Google 表格(Google Sheets)同样出色。
协作——谷歌表格获胜
Microsoft正在努力为他们的Office应用程序套件创建更具协作性的体验，但它并没有完全超越从一开始就与Google Docs、Sheets等提供的无缝共享。
Google 表格(Google Sheets)上提供的共享设置令人难以置信——您可以控制谁可以看到您的文档、谁可以编辑它以及谁可以评论它。你可以发送特定的邀请，或者只是创建一个链接来分享。或者，您可以创建可供公众查看的电子表格。
可以实时查看所做的任何编辑和评论，并且您可以快速查看其他用户在哪些单元格上。您还可以通过单击工具栏顶部的“上次编辑...”文本来跟踪所做的每一个更改。
Microsoft Excel允许共享和协作，但不能达到Google 表格(Google Sheets)的程度。您只能通过电子邮件共享文件，而且您无法获得与Sheet相同的协作级别。如果您使用的是Office 365，您现在可以访问类似的跟踪编辑页面，以及查看其他用户活动的类似选项。协作方面的差距正在缩小，但目前谷歌表格(Google Sheets)获胜。
云(Cloud)和同步——谷歌表格获胜(Syncing – Google Sheets Wins)
谷歌表格(Google Sheets)再次名列前茅，这是有道理的。Google 表格(Google Sheets)从一开始就被构建为Microsoft Excel的基于云的替代品。您可以从您的Google帐户访问所有内容，并且您可以从Google Drive查看和访问您的所有文件。
同步很容易，因为这一切都是自动完成的。如果您创建了一个文件，它会保存在您的Google Drive上，以便在其他地方立即访问。
如果您使用的是Office 365，则可以在设备之间获得相同级别的即时同步，但Office 2019或更早版本的(Office 2019)Excel需要进行一些设置。这是谷歌表格(Google Sheets)领先的另一个领域，但微软(Microsoft)正在缩小差距。
离线访问 – Excel 胜出
离线(Offline)访问可用于Google 表格(Google Sheets)，但您将难以访问之前在线创建的文件。您需要安装离线扩展程序才能广泛离线处理文件，并且该扩展程序无法始终正常工作，就满足离线用户的需求而言， Google 表格(Google Sheets)处于一个尴尬的位置。
如果您需要离线访问，我绝对推荐Excel —— Microsoft Office套件几十年来一直在离线状态下完美运行，现在您可以对其进行设置，以便在您重新访问 Internet 后立即通过OneDrive自动同步文件。(OneDrive)
函数和公式 - Excel 胜出
谷歌(Google)在这方面正在迅速追赶，他们不断地添加新的函数和公式，但Excel的领先优势要大得多。这意味着Excel用户比(Excel)Google 表格(Google Sheets)用户有两个优势。
首先，可用的函数和公式的数量要多得多——如果您需要在电子表格上完成某些事情，Excel上可能会有一个命令。在Google Sheets上，仍然缺少一些公式。
接下来是Excel的文档要大得多。它已经存在了很长时间，并且长期以来一直是工作场所的行业标准。正因为如此，Excel的免费学习资料远远超过Google 表格(Google Sheets)。
定价 – 谷歌表格
这个很好而且很简单——谷歌表格(– Google Sheets)完全免费使用，而Excel需要一次性支付Microsoft Office或订阅Office 365。归根结底，如果您手头拮据，谷歌表格(Google Sheets)就是答案。
概括
总而言之，我想说Excel是目前的首选，但谷歌(Google)推出的谷歌表格(Google Sheets)软件更新速度比微软(Microsoft)快得多。结果，这两种选择之间的差距正在迅速缩小。但是，Google Sheets也可能是大规模协作和公共文件共享的明确选择，而且您不能免费。
想(Want)了解更多关于Google 表格(Google Sheets)或Excel的信息吗？浏览我们网站的其余部分，或在下方发表评论，我会尽快回复您。
Google Sheets vs Microsoft Excel – What are the Differences?
Previously, we wrote about the differences between Google Docs and Microsoft Word and in this post, we’re going to talk about spreadsheets.
Spreadsheets are the pillars for our modern day society. Spreadsheets are useful for work, record keeping, collaboration, or just personal organization. Right now, we have two top contenders in the spreadsheet world – Google Sheets and Microsoft Excel.
Out of these two spreadsheet apps, we wanted to take a deeper dive between the two to find out their differences and understand which one is better. At a quick overview, it turns out both have their pros and cons, but the gap between both Excel and Google Sheets is growing smaller day by day. Here’s what you need to know about the differences that remain.
Functionality – Excel Wins
When Google Sheets first launched, it was miles behind Excel. It was no surprise, either. Excel has been around for decades and Microsoft has been pushing out regular iterations for longer than I have been alive.
The trouble for Microsoft is that it didn’t take long for Google to play catch up. Today, the functionality between Excel and Google Sheets is very similar. Both programs have interfaces that are easy to get to grips with, extensive knowledge bases, and a plethora of tools and functions.
However, if you need more advanced functions or you’ll be working with massive amounts of data, I’ve found that Excel is more suitable. Google Sheets is well optimized up to a point – as your sheet fills with more columns, rows, and tabs of data, I’ve found it to start slowing down in comparison to Excel.
If you need a headache-free experience to access and manage thousands of cells of data, Excel is the winner. However, if you just need to create simple spreadsheets with a small selection of commands, Google Sheets is just as good.
Collaboration – Google Sheets Wins
Microsoft is working harder to create a more collaborative experience for their suite of Office apps, but it doesn’t quite beat the seamless sharing that came with Google Docs, Sheets, and so on from day one.
The sharing settings available on Google Sheets are incredible – you have control over who can see your document, who can edit it, and who can comment on it. You can send specific invites, or just create a link to share. Alternatively, you can create spreadsheets that are available for viewing to the public.
Any edits and comments made can be seen in real time and you can quickly see what cells other users are on. You can also keep track of every single change made by clicking the ‘last edit…’ text at the top of the toolbar.
Microsoft Excel allows sharing and collaboration, but not to the extent that Google Sheets does. You’re restricted to sharing files via email and you don’t quite get the same level of collaboration that Sheet does. You can now get access to a similar tracked edit page if you are using Office 365, and similar options for seeing activity from other users. The gap on collaboration is closing, but for now Google Sheets wins.
Cloud and Syncing – Google Sheets Wins
Once again, Google Sheets comes out on top, and it makes sense why. Google Sheets was built from the ground up to be a cloud based alternative to Microsoft Excel. Everything is accessible from your Google account and you’ll be able to see and access all of your files from Google Drive.
Syncing is easy because it’s all done automatically. If you create a file, it’s saved on your Google Drive, making it immediately accessible elsewhere.
If you’re using Office 365, you do get the same level of instant synchronization between devices, but Excel on Office 2019 or earlier requires a bit of setting up. This is another area where Google Sheets comes out ahead, but Microsoft is closing the gap.
Offline Access – Excel Wins
Offline access is available for Google Sheets, but you’ll have difficulty accessing files you previously created whilst online. You need to install an offline extension to be able to work on files extensively offline, and the extension doesn’t work correctly at all times, leaving Google Sheets in a bit of an awkward position as far as catering for offline users goes.
If you need offline access, I’d absolutely recommend Excel – the Microsoft Office suite has worked perfectly offline for decades and now you can set it up so that your files automatically sync via OneDrive as soon as you regain internet access.
Functions and Formulas – Excel Wins
Google is quickly catching up in this area, and they’re constantly adding new functions and formulas, but Excel has had a much greater head start. This means that Excel users get two advantages over Google Sheets users.
Firstly, the number of available functions and formulas is far larger – if you need to accomplish something on a spreadsheet, there’s likely to be a command for it on Excel. On Google Sheets, some formulas are still missing.
The next thing is that documentation for Excel is far greater. It’s been around for much longer and it has been the industry standard in the workplace for a long time. Because of this, free learning material for Excel is far greater than Google Sheets.
Pricing – Google Sheets
This one is nice and straightforward – Google Sheets is completely free to use, whilst Excel requires a one time payment of Microsoft Office or a subscription to Office 365. Ultimately, if you’re strapped for cash, Google Sheets is the answer.
Summary
To summarize, I’d say that Excel is the top choice for now, but Google is pushing out updates to their Google Sheets software far faster than Microsoft is. As a result, the gap between the two options is getting smaller very quickly. However, Google Sheets may also be the clear choice for large scale collaboration and public file sharing, and you can’t beat free.
Want to know anything more about Google Sheets or Excel? Take a look through the rest of our website, or leave a comment below and I’ll get back to you soon.
