Tag Archives: Google Sheets

Migrate your apps to the latest Sheets API by March 2020

Quick launch summary 

We’re retiring the Sheets v3 API on March 3, 2020. To ensure that projects that were originally built on the v3 API continue to work, migrate your apps to the Sheets v4 API before that date. To learn more about this change, see our post on the Cloud blog. For information on transitioning your apps, check out our migration guide.

  Stay up to date with G Suite launches

New fonts intended to help improve reading speed now available in Google Docs, Sheets, and Slides

Quick launch summary

The Google Fonts team has teamed up with Thomas Jockin to create a series of fonts that are aimed at improving reading speed. To learn more about the research behind this initiative, see here for more details.



These fonts take into account typographical factors, such as size and spacing, that the font developers hope will improve reading speed. This can be particularly helpful for educators who want to leverage new tools that can improve reading among their students, especially those who are sensitive to visual crowding.

We now offer eight different Lexend font families that have varied widths and spacing, so users can choose the font style that’s best for their reading speed.

To access these fonts in Google Docs, Sheets, or Slides:

  • From the Font menu in the toolbar, select “More fonts”.
  • Then, search for Lexend and select the fonts to add them to your saved fonts. These will now appear in the “My fonts” list and in the Font menu in the toolbar. 

Availability

Rollout details

  • These fonts are already available to both Rapid and Scheduled domains.

G Suite editions

  • Available to all G Suite editions

On/off by default?

  • These fonts will be available by default.


Stay up to date with G Suite launches

Additional tools for enhanced reporting in Google Sheets

What’s changing

We’re adding three new tools to help you generate more compelling reports and better display data in Google Sheets:

  • Slicers
  • Scorecard Charts
  • Themes

Earlier this year we announced several new features for objects in Sheets. Together, these new features make for a more impactful reporting experience in Sheets.


Using Slicers, Scorecard Charts, and Themes together to enhance reporting.

Who’s impacted

End users

Why you’d use them

You can use these tools to filter, display key data, and customize the look and feel of your spreadsheets, making it easier and faster to generate more engaging and informative reports.

How to get started


  • Admins: No action required.
  • End users: See below for how to use each new tool in Sheets.

Additional details

Slicers:
Slicers are a new way of filtering for reports or dashboards by condition and by values. To learn more about using Slicers in Sheets, see our Help Center.

Scorecard charts:
Scorecard charts is a new way to call out key metrics, such as KPIs or a key stat, within your sheet. You’ll have the option to show your stat in comparison to another number, for instance illustrating percentage increase or decrease over time. See our Help Center for more information on how to insert a Scorecard chart in Sheets.

Themes:
You can now quickly alter the look and feel of an entire spreadsheet—including charts, pivot tables, and cells—to ensure a consistent look and feel for your spreadsheets. To apply a preset theme, select Format > Theme and choose an option, or to create a custom theme, select Customize in the top right.

Helpful links



Availability

Rollout details

G Suite editions

  • Available to all G Suite editions.

On/off by default?

  • These features will be ON by default.

Stay up to date with G Suite launches

Improving active account awareness when opening files with multiple sign-ins

Quick launch summary 

We’re making it easier for you to identify which Google account is active when opening and contributing to Docs, Sheets, and Slides files.

When you’re logged into multiple accounts, like switching between your work and personal accounts, it can sometimes be confusing to determine which account is active when opening and collaborating on a Doc, Sheet, or Slide. We’re introducing a new dialogue that better indicates which account is active, and gives you the option to quickly change accounts.

This will help eliminate confusion and ensure you’re using the correct account when contributing to content.


Availability 

Rollout details 


G Suite editions 

  • Available to all G Suite editions 

On/off by default? 

  • This feature will be ON by default. 

Stay up to date with G Suite launches

Remove or select a custom color for chart borders in Google Sheets

Quick launch summary 

You now have more options for customizing chart borders in Google Sheets. Currently, the default border for a chart is dark gray — now, you can change the border to a custom color or remove the border:

  • Double click on any chart to open the Chart editor and select the Customize tab. 
  • Under Chart style, you can select a border color or select “None” to remove the border. 

The default border is shown on the left, customization options shown on the right. 


We hope this new feature helps you better customize your Sheets.

Availability 

Rollout details 



G Suite editions 

  • Available to all G Suite editions 


On/off by default? 

  • This feature will be ON by default.


Stay up to date with G Suite launches

Request and review formal document approvals with a new beta

What’s changing 

We’re launching a new beta that allows you to request and review formal approvals on Google Docs, Sheets, and Slides. This feature gives you a direct way to get binding approvals on a file, and to see who’s approved them.



To learn more about this beta and to apply, see here.

Who’s impacted 

Admins and end users

Why you’d use it 

With this beta, you can easily request approval on specific files from a single or multiple reviewers. Once you add a reviewer to a file, they’ll receive a notification via email.

You’ll also have the option to specify a due date when requesting an approval. As the due date approaches, reviewers will receive reminders via email that their approval is needed. Reviewers will also receive reminders if their approval is past due.

For a single reviewer, the file is automatically approved or rejected once the reviewer makes their choice. For multiple reviewers, the file gets approved once all reviewers have selected “approve” and rejected once any reviewer selects “reject.”

 If you need to add additional reviewers to a request, you can do so as long as an approval is still pending. In addition, editors and pending reviewers can choose to re-assign a review request to a more appropriate party.

How to get started 

  • Admins: To apply for the Google Drive Approvals beta, see here
  • End users: 
    • Once this feature is enabled for your domain, to request an approval: 
      • In Google Drive, right-click the file you want to get approved and select “Approvals” from the list of options. 
      •  If you have the file open in preview mode, this option is also available in the actions listed in the three-dot drop-down menu. 
  • To approve or reject a file: 
    • If your approval is requested on a document, you’ll receive a notification email and can take action within Gmail: 
      • You can approve or reject the document in the preview pane, and add comments.
      • From Drive, you can see a pending request for approval in the action items associated with a file, or by right-clicking and choosing “View approvals.” 

Additional details 

Once you send a file for review, the content of the file cannot be modified, including leaving and resolving comments within the document. Only comments regarding the approval itself can be added.
Only editors can unlock the file, in which case the review request is cancelled. Reviews can be requested again once all revisions are made.

Helpful links 



Availability 

G Suite editions 

  • Available to G Suite Business, G Suite Enterprise, G Suite for Education, G Suite Enterprise for Education, and G Suite for Nonprofits 
  • Not available for G Suite Basic 

On/off by default? 


Stay up to date with G Suite launches

View the edit history of a cell in Sheets

What’s changing 

“Show edit history” is a new feature in Sheets that will help you easily see the edit history of a cell, including who made the last edit, when that edit was made, and the cell’s previous value.


Who’s impacted 

End users

Why you’d use it 

Tracking edits made by collaborators is important for keeping information accurate and understanding why specific changes were made and by whom. This is especially critical when there are several collaborators working in a sheet.

Previously, you would need to open up Version History and manually look through past versions of a sheet to determine who changed a cell and when. With Show edit history, you can quickly surface the edit history of a cell: who edited, when, and the previous value.

How to get started 


  • Admins: No action required. 
  • End users: To start using Show edit history: 
    • Right click on any cell and select “Show edit history” from the dropdown menu. 
    • A dialogue box will appear that will show you: 
      • The user who last made a direct edit in the cell 
      • A timestamp of the edit 
      • The previous value and current value of the cell 
      • Arrow keys in the top right corner which toggle back and forth between edits 

Additional details 

The following changes are considered previous edits to a cell:

  • Adding, editing, or removing content — like changing the value of a cell from “3” to “5”
  • Changing a formula — like changing “=A1+B1” to “=A1+C5” 
  • Adding, editing, or removing a link from a cell 
Note: Some changes may not show up in the edit history. Some examples are:

  • Added or deleted rows and columns 
  • Changes to the cell’s format 
  • Changes made by formulas 

Helpful links 



Availability 

Rollout details 


G Suite editions 

  • Available to all G Suite editions 

On/off by default? 

  • This feature will be ON by default.


Stay up to date with G Suite launches

View the edit history of a cell in Sheets

What’s changing 

“Show edit history” is a new feature in Sheets that will help you easily see the edit history of a cell, including who made the last edit, when that edit was made, and the cell’s previous value.


Who’s impacted 

End users

Why you’d use it 

Tracking edits made by collaborators is important for keeping information accurate and understanding why specific changes were made and by whom. This is especially critical when there are several collaborators working in a sheet.

Previously, you would need to open up Version History and manually look through past versions of a sheet to determine who changed a cell and when. With Show edit history, you can quickly surface the edit history of a cell: who edited, when, and the previous value.

How to get started 


  • Admins: No action required. 
  • End users: To start using Show edit history: 
    • Right click on any cell and select “Show edit history” from the dropdown menu. 
    • A dialogue box will appear that will show you: 
      • The user who last made a direct edit in the cell 
      • A timestamp of the edit 
      • The previous value and current value of the cell 
      • Arrow keys in the top right corner which toggle back and forth between edits 

Additional details 

The following changes are considered previous edits to a cell:

  • Adding, editing, or removing content — like changing the value of a cell from “3” to “5”
  • Changing a formula — like changing “=A1+B1” to “=A1+C5” 
  • Adding, editing, or removing a link from a cell 
Note: Some changes may not show up in the edit history. Some examples are:

  • Added or deleted rows and columns 
  • Changes to the cell’s format 
  • Changes made by formulas 

Helpful links 



Availability 

Rollout details 


G Suite editions 

  • Available to all G Suite editions 

On/off by default? 

  • This feature will be ON by default.


Stay up to date with G Suite launches

Mail merge with the Google Docs API

Posted by Wesley Chun, Developer Advocate, Google Cloud

Students and working professionals use Google Docs every day to help enhance their productivity and collaboration. The ability to easily share a document and simultaneously edit it together are some of our users' favorite product features. However, many small businesses, corporations, and educational institutions often find themselves needing to automatically generate a wide variety of documents, ranging from form letters to customer invoices, legal paperwork, news feeds, data processing error logs, and internally-generated documents for the corporate CMS (content management system).

Mail merge is the process of taking a master template document along with a data source and "merging" them together. This process makes multiple copies of the master template file and customizes each copy with corresponding data of distinct records from the source. These copies can then be "mailed," whether by postal service or electronically. Using mail merge to produce these copies at volume without human labor has long been a killer app since word processors and databases were invented, and now, you can do it in the cloud with G Suite APIs!

While the Document Service in Google Apps Script has enabled the creation of Google Docs scripts and Docs Add-ons like GFormit (for Google Forms automation), use of Document Service requires developers to operate within the Apps Script ecosystem, possibly a non-starter for more custom development environments. Programmatic access to Google Docs via an HTTP-based REST API wasn't possible until the launch of the Google Docs API earlier this year. This release has now made building custom mail merge applications easier than ever!

Today's technical overview video walks developers through the concept and flow of mail merge operations using the Docs, Sheets, Drive, and Gmail APIs. Armed with this knowledge, developers can dig deeper and access a fully-working sample application (Python), or just skip it and go straight to its open source repo. We invite you to check out the Docs API documentation as well as the API overview page for more information including Quickstart samples in a variety of languages. We hope these resources enable you to develop your own custom mail merge solution in no time!

Three new features to format and work with data in Sheets

What’s changing 

We’re introducing three new features that will help you clean up and work with your data in Sheets. These features are: 

  • Remove duplicates 
  • Trim whitespace 
  • Compatible spreadsheet shortcuts 

Who’s impacted 

End users

Why you’d use them 

Remove duplicates: 
A highly requested feature, you can use this tool to easily remove duplicate values from your sheet, saving you time by eliminating the need to write an app script or manually remove duplicate data.



Trim whitespace: 
Sometimes when you add data to a sheet, it may not be the format you need. Now, you can easily keep your sheet standardized by using the trim whitespace feature to remove any leading, trailing, or excessive whitespace from a cell or array of data.



Compatible keyboard shortcuts: 
You can now use popular keyboard shortcuts from other spreadsheets in Sheets. These familiar shortcuts will make navigating and working with data in Sheets quicker for users.



How to get started 

Admins: No action required.
End users:
  • To remove duplicates from a range of data: 
    • Select range of data in your sheet 
    • From the toolbar, select Data > Remove duplicates. In the dialogue box, you’ll see your selected range of data. 
    • Select Remove duplicates. You’ll see an additional dialogue box that details how many duplicates were removed from your dataset.
  • To trim whitespaces: 
    • Select a cell or range of data that contains whitespace on your sheet 
    • From the toolbar, select Data > Trim whitespace 
    • You’ll then see a dialogue box that details how many cells whitespace was removed from. 
  • To enable compatible keyboard shortcuts: 
    • Users can access keyboard shortcuts by going to Help > Keyboard shortcuts
      • From here, you can see a list of keyboard shortcuts and their corresponding commands. Note that compatible shortcuts will be denoted with an info icon. 
      • At the bottom, you can enable compatible spreadsheet shortcuts. 
      • You can click “View compatible shortcuts” at the bottom right to see a complete list of all newly available shortcuts. 

Additional details 

The remove duplicates and trim whitespaces features will be supported in Apps Script, macro recording, and one platform APIs in early June 2019.

Helpful links 

Keyboard shortcuts for Google Docs. 
Split text, remove duplicates, or trim whitespace in Sheets.
Separate cell text into columns. 

Availability 

Rollout details 


G Suite editions 

  • Available to all G Suite editions. 

On/off by default? 

  • This feature will be ON by default.

Stay up to date with G Suite launches