Google Sheets Archives

How To Move Data Between Google Sheets and Excel

May 22, 2018April 20, 2018 by Staff Writer

Let’s begin with a distinction between Google Sheets & Excel:

– Excel is a spreadsheet application that is a part of Microsoft Office 365.

– Google Sheets a spreadsheet app that is available with free consumer Gmail and also with G Suite (GMail for organizations).

Some people use only one or the other. Other people use both.

If a Google user who does not have Excel installed receives an Excel spreadsheet via email, the user can preview the spreadsheet within Gmail and then convert the spreadsheet to Google Sheets.

There are several ways to move spreadsheets and spreadsheet data between Google Sheets and Microsoft Excel. Here are examples of Google Excel information exchange.

Embed a “Live” Google Sheets Pricing Table in a Proposal Doc

December 1, 2018June 11, 2017 by Staff Writer

For salespeople who regularly send out long form proposals that contain pricing tables, there has always been a conundrum.

That is, a pricing table within in a document can’t be dynamically updated as easily as a spreadsheet table. The word processing capabilities within a spreadsheet are limited.

Often, a proposal’s pricing table is revised several times before the final version of a proposal is sent to the prospect or customer. This can require manual effort. Either the new bottom line in the document table needs to be hand calculated when line items are changed — or the spreadsheet table must be re-copied/pasted a into the document.

Google Analytics Reports in Google Sheets – Using Filters

September 1, 2018August 6, 2016 by Staff Writer

One of many benefits to using G Suite is that G Suite users with access to their organization’s Google Analytics account can easily share specific slices of Google Analytics data with their co-workers.

The Google Analytics Add-on for Google Sheets lets a Sheets user who has a Google Analytics login create a variety of comparative visualizations within Google Sheets.