Tag Archives: Google Sheets

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

Work anywhere with Google Docs, Sheets, and Slides in new offline mode

What’s changing 

It’s now possible for users to work on Docs, Sheets, and Slides files when your device is offline or have a bad internet connection within Google Drive. You can also preview which files are available offline with a new offline preview mode.

Right click on Docs, Sheets, and Slides files from within Google Drive to make those files available offline.

You can preview which files are available offline using the Offline preview mode

Who’s impacted 

Admins and end users.

Why you’d use it 

We know it’s important for users to access and work on their files while traveling or when there’s low connectivity. With offline mode, it’s now possible to create, edit, and comment on Docs, Sheets, or Slides files. Any changes made to files while offline will then sync in Drive once the user is connected again.

How to get started 

  • Admins: Admins can enable this feature for all or some users:
    • To let users enable offline access (recommended), go to Apps > G Suite > Drive and Docs.
    • To enable offline access for specific devices, see this article in our Help Center.
    • Note: The default for this feature is that all users can enable offline access on any device they sign into, but it is not enabled automatically except on Chromebooks 
  • End users: To work with your files while offline, you’ll need to enable offline access in your Drive settings:
    • From Google Drive, click the gear icon at the top right corner, select Settings > General and select Sync Google Docs, Sheets, Slides, and Drawings files to this computer so that you can edit offline.
    • Once offline access is enabled, a checkmark icon will appear in the top right next to Settings (gear icon) and Support (question mark). When you click this icon, you can find the offline preview toggle. 



Additional details 

To make files available offline in Google Drive, right click on any file and toggle Available offline from the menu while connected.

When offline access is enabled, Google Drive also automatically and intelligently makes a certain number of Google Docs/Sheets/Slides files available offline based on how recently you accessed them. You can preview which files are already available offline automatically using the offline preview mode. You can also mark a file available offline -- so that it always remains available offline -- while in offline preview mode, as long as you are connected.

Helpful links 

Availability 

Rollout details 
  • Rapid Release domains: Gradual rollout (up to 15 days for feature visibility) starting on April 24, 2019 
  • Scheduled Release domains: Extended rollout (potentially longer than 15 days for feature visibility) starting on May 21, 2019. 
G Suite editions 
  • Available to all G Suite editions.
On/off by default? 
  • This feature will be ON by default for users who already have offline enabled.
Stay up to date with G Suite launches

Work with Google Docs, Sheets, and Slides in Dropbox with a new beta

What’s changing 

This Dropbox beta will allow Dropbox users to work with Google Docs, Sheets, and Slides directly in Dropbox.

G Suite admins with a Dropbox Business subscription for their organization can find more details and apply for the beta here.

Who’s impacted 

Admins and end users.

Why you’d use it 

When users are signed in to both their Google and Dropbox accounts, they can create and store Docs, Sheets, and Slides files in any Dropbox folder, alongside traditional files. You’ll be able to:

  • Create and edit web-based files: 
    • You can start a shared Docs, Sheets, or Slides file right from dropbox.com or from apps on Windows and Mac, and have it stored in Dropbox. When you open files, you’ll be taken straight to familiar Google editors within Dropbox.
    • You can also open .docx, .xlsx, or .pptx files from Dropbox in Docs, Sheets, or Slides, and save them back to Dropbox in their original format. 


Create Docs, Sheets, and Slides from within Dropbox Web UI

  • Share Files and manage access: 
    • Adding a Docs, Sheets, or Slides file to a shared Dropbox folder will automatically grant members access. You can also share files on a one-off basis without adding it to a shared folder by inviting people from Dropbox or creating a shareable link. 


    • Whether sharing files directly from Dropbox or with a link, you can set edit or view-only access. You’ll also have the option to set permissions to team only when sharing within your organization or anyone when sharing files outside your organization.


Dropbox sharing modal overlaid on Slides presentation 



  • Search your files: Docs, Sheets, and Slides files will show up when searching in Dropbox, including results from the content within your Docs, Sheets, and Slides in addition to file names. 


  • Collaborate: You’ll be notified of any comments or edits made on your Docs, Sheets, and Slides files in your Dropbox notifications, so you can easily stay on top of what’s happening with your files. 

We hope this feature will streamline workflows by reducing the time spent switching between multiple tools helping you use data more effectively.

How to get started 



Additional details 

Dropbox users on desktop, web, and mobile can view, comment, search, move, copy, and delete files. Note that mobile users will not be able to edit files.

Helpful links 

For more details and how to apply for the beta, see here.

Availability 

G Suite editions 

  • Available to all G Suite editions.

Stay up to date with G Suite launches

More collaboration insights in the Activity dashboard

This announcement was made at Google Cloud Next ‘19 in San Francisco. Check out Next OnAir to tune into the livestream or watch session recordings following the event.

Quick Launch Summary 

We’re introducing two new features to the Activity dashboard in Google Docs, Sheets, and Slides:

Sharing history
Sharing history provides users with granular visibility into how your document is being shared with others across your organization and elsewhere. You’ll now see who shared access with who and what level editing access they’ve been granted.



Comment trend 
Comment trend will help users visualize the conversations in a particular document, showing the number of comments, suggestions, and replies created per day. A graph will display the number of new comment threads, replies, and unresolved comments over the lifetime of a document.



These updates add more context to the Activity dashboard, a feature we launched last year to help users see who’s viewed a particular document and viewer trends. These additions will further flesh out the Activity dashboard, making it a centralized hub where document owners and editors can see how other collaborators are engaging with their 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

Office editing makes it easier to work with Office files in Docs, Sheets, and Slides

This announcement was made at Google Cloud Next ‘19 in San Francisco. Check out Next OnAir to tune into the livestream or watch session recordings following the event.

What’s changing 

With Office editing, you can now edit, comment, and collaborate on Microsoft Office files using Google Docs, Sheets, and Slides. This feature brings the collaboration benefits of G Suite to Office files while streamlining workflows by eliminating the need to convert file types.


Who’s impacted 

End users

Why you’d use it 

Office editing will make it easy for G Suite users to open and edit Microsoft Office files that have been shared by partners, vendors or other teams. In cases where some members of your organization use Office while others use G Suite, this ensures seamless collaboration and eliminates the need to consider or convert file types.

Office editing brings everyone the benefits of G Suite’s real time collaboration tools and intelligence features to Office files.

How to get started 

Admins: If your organization uses the Office compatibility app in Chrome, you may experience issues using this feature. To learn more about disabling this app for your domain or having users remove it, see here.
End users:
  • In Google Drive, double-click your Office file. This will open a preview of the file. 
  • At the top, click Open in Google Docs, Sheets, or Slides
  • From here, you can edit, share, view version history, collaborate in real-time with others, and more. 
  • All changes you make will be saved to the original Office file. 

Additional details 

The following Office file types are supported: 
  • Word files: .doc, .docx, .dot 
  • Excel files: .xls, .xlsx, .xlsm (macro enabled Excel files), .xlt 
  • Powerpoint files: .ppt, .pptx, .pps, .pot 
Note: If you edit Word, Excel, or PowerPoint documents older than Office 2007, files will be saved to a newer format when editing using Office editing. 

Helpful links 

To learn more about removing the Office compatibility app, see here

Availability 

Rollout details
  • Rapid Release domains: Extended rollout (potentially longer than 15 days for feature visibility) starting on April 17, 2019. 
  • Scheduled Release domains: Extended rollout (potentially longer than 15 days for feature visibility) starting no earlier than May 6th, 2019. 
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

Work with billions of rows of BigQuery data with connected sheets, launching in beta

This announcement was made at Google Cloud Next ‘19 in San Francisco. Check out Next OnAir to tune into the livestream or watch session recordings following the event.

What’s changing 

We’re introducing connected sheets in beta (coming soon). This new type of spreadsheet activates when using the Sheets data connector and will allow users to access, analyze, visualize, and collaborate on up to 10 billion rows of BigQuery data without the need for SQL scripts.

With connected sheets, it’s easier for users to surface insights in Sheets and make sense of that data using tools and features already familiar to them — like formulas, Explore, pivot tables, and charts. 

Admins can learn more about the beta here.


Who’s impacted 

Admins

Why you’d use it 

Connected sheets makes it easier to do the following:

  • Access and refresh large volumes of connected data without CSVs or SQL scripts 
  • Streamline reporting workflows and easily build data driven reports 
  • Simplify collaboration with other analysts and stakeholders. 

How to get started 



  • Admins: To learn more and apply to the connected sheets beta, see here
  • End users: No action required. 

Additional details 


Users can refresh their data which in turn will refresh any associated data within a chart, pivot table, function or table.

Data can also be set to refresh automatically, making it even easier to stay up to date on the latest and greatest data.

Helpful links 

To learn more about connected sheets, see here. 
To apply for the connected sheets beta, see here. 

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 to G Suite Basic.


Stay up to date with G Suite launches

Minor updates related to the Activity Dashboard in Editors and the Admin console

Quick launch summary 

We’re making two minor updates to verbiage found in the Activity Dashboard in Editors and related settings within the Admin console. As we launch more features to the Activity Dashboard, these updates will help keep things clear for both admins and end users.

In the Admin console: 
In the Activity dashboard settings, where it previously read “Access to activity dashboard” on the left hand navigation, it will now read “Access to view history.”



From here, Admins can set the ability for users to access Viewers and Viewer trend activity in the dashboard to ON/OFF. To learn more about file activity visibility, see this article in the Help Center.

In Editors: 
Within the Activity dashboard, the “View time” tab has been renamed to “Viewers.” From this tab, document owners can see the last time users with Edit access viewed the file and take action to follow-up. To learn more about view history in Docs, Sheets, and Slides, see this Help Center article. 

We’re also changing the icon for the Viewers tab — previously it was a clock, now it will be a person. This change is to better indicate the purpose of this tab, which is viewer history, not time viewers spent in the document.



Availability 

Rollout details
G Suite editions 
  • Available to all G Suite Editions.

Stay up to date with G Suite launches

It’s now easier to insert images in cells in Google Sheets

What’s changing  

We’ve made it simpler to add images inside of cells in Google Sheets. Previously, it was only possible to insert publicly hosted images into a cell using the IMAGE function.

Now, you can insert any image, like those saved on your desktop or mobile device, into a cell by using the IMAGE function or the new option found inside the Insert menu.


Who’s impacted 

End users

Why you’d use it 

  • You’ve told us this feature would be helpful for many tasks like: 
  • Adding receipts to expense-tracking spreadsheets 
  • Adding icons to icon libraries 
  • Adding logos to better brand your resources 
  • Adding product images to inventory lists, and more. 

How to get started 

  • Admins: No action needed. 
  • End users: You can add images directly to cells in two ways on Desktop: 
    • Use the IMAGE() function 
    • Via the menu bar at the top of a Sheet: Insert > Image > Image in cell 
      • Select image from Drive or upload one. 

  • On Mobile: 
    • Tap once on a cell to select 
    • Tap again to bring up menu: Insert > Tap the “+” at the top of the screen > Image > Image in cell 
    • Select an image from the options presented to you. 

Additional details 

You can have multiple cells containing an image in a Sheet, but note that only one image per cell is possible at the moment. 

Images inside cells will be associated with a row and move along with the data—so, if you move rows, filter or sort them, the images will move with the content in the row, unlike previously when images would sit on top of the grid. 

Using the formatting and alignment tools, you can pin the image to a specific corner of the cell or set the alignment how you’d like. By default, images will align to the bottom left corner of the cell.

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 

Accessibility settings are now easier to access on Docs, Sheets, and Slides

Quick launch summary

It’s now easier to discover accessibility features like screen reader support, braille support, and screen magnifier support in Docs, Sheets, and Slides.

While these accessibility features were previously available, they required additional steps to access the accessibility menu. This change will make these settings more readily available by placing the Accessibility settings in the Tools menu.

Access the Accessibility menu by selecting Tools > Accessibility settings.

The accessibility settings dialog showing screen reader, braille, and screen magnifier support options.
If the screen reader option is selected from the accessibility settings dialog, an Accessibility menu will be displayed at the top of Docs, Sheets, and Slides for easy access.

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

Easily refresh Salesforce data in Sheets

What’s changing 

You now have the option to refresh the Salesforce data populated in Sheets using the Salesforce data connector. You can refresh this data manually or schedule the data to be refreshed.

Currently, the Salesforce data connector for Sheets gets data from reports or imports when the sidebar is opened and has been configured. In order to get updated data, users would need to go through the same configuration steps in the sidebar.

Who’s impacted 

End Users

Why you’d use it 

If you use Salesforce to track important conversations with key leads, you can make sure this data is consistently fresh by scheduling a refresh rather than reimporting the Salesforce data.

If your Sales team uses the add-on to import details of their accounts from Salesforce into Sheets, they can schedule this data to refresh daily or even multiple times a day to stay on top of the current data.

How to get started 

Admins: No action needed.
End users: Here’s how to refresh your Salesforce Data in Sheets:

  1. Open the Data connector from Salesforce Add-On and select Refresh
  2. Select Manual Refresh to refresh the current data on your sheet or Auto Refresh to schedule a refresh every 4, 8, or 24 hours. 
  3. Review your selections and select Create. 

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