Tag Archives: Google Sheets

Pivot to the cloud: intelligent features in Google Sheets help businesses uncover insights

(Cross-posted from The Keyword)

When it comes to data in spreadsheets, deciphering meaningful insights can be a challenge whether you’re a spreadsheet guru or data analytics pro. But thanks to advances in the cloud and artificial intelligence, you can instantly uncover insights and empower everyone in your organization—not just those with technical or analytics backgrounds—to make more informed decisions.

We launched "Explore" in Sheets to help you decipher your data easily using the power of machine intelligence, and since then we’ve added even more ways for you to intelligently visualize and share your company data. Today, we’re announcing additional features in Google Sheets to help businesses make better use of their data, from pivot tables and formula suggestions powered by machine intelligence, to even more flexible ways to help you analyze your data.

Easier pivot tables, faster insights

Many teams rely on pivot tables to summarize massive data sets and find useful patterns, but creating them manually can be tricky. Now, if you have data organized in a spreadsheet, Sheets can intelligently suggest a pivot table for you.*

In the Explore panel, you can also ask questions of your data using everyday language (via natural language processing) and have the answer returned as a pivot table. For example, type “what is the sum of revenue by salesperson?” or “how much revenue does each product category generate?” and Sheets can help you find the right pivot table analysis.**


In addition, if you want to create a pivot table from scratch, Sheets can suggest a number of relevant tables in the pivot table editor to help you summarize your data faster.

*You can view pivot tables on all platforms, but you can only create and edit them on the web.
**The “Answers” feature in Sheets is only available in English at this time.

Suggested formulas, quicker answers

We often use basic spreadsheet formulas like =SUM or =AVERAGE for data analysis, but it takes time to make sure all inputs are written correctly. Soon, you may notice suggestions pop up when you type “=” in a cell. Using machine intelligence, Sheets provides full formula suggestions to you based on contextual clues from your spreadsheet data. We designed this to help teams save time and get answers more intuitively.

Even more Sheets features

We’re also adding more features to make Sheets even better for data analysis:
  • Check out a refreshed UI for pivot tables in Sheets, and new, customizable headings for rows and columns.
  • View your data differently with new pivot table features. When you create a pivot table, you can “show values as a % of totals” to see summarized values as a fraction of grand totals. Once you have a table, you can right-click on a cell to “view details” or even combine pivot table groups to aggregate data the way you need it. We’re also adding new format options, like repeated row labels, to give you more fine-tuned control of how to present your summarized data.
  • Create and edit waterfall charts. Waterfall charts are good for visualizing sequential changes in data, like if you want to see the incremental breakdown of last year’s revenue month-by-month. Select Insert > Chart > Chart type picker and then choose “waterfall.”
  • Quickly import or paste fixed-width formatted data files. Sheets will automatically split up the data into columns for you without needing a delimiter such as commas between data.
These new Sheets features will roll out in the coming weeks—see specific rollout details below. To learn more about how G Suite can help your business uncover valuable insights and speed up efficiencies, visit the G Suite website. Or check out these tips to help get started with Sheets.

Launch Details
Release track: 
Launching to Rapid Release, with Scheduled Release coming on January 24th, 2018*

*Due to the holidays, the launch to Scheduled Release will occur more than the standard two weeks after the launch to Rapid Release. The rollout to Scheduled Release domains will begin on January 24th, 2018.

Editions:
Available to all G Suite editions

Rollout pace:
Extended rollout (potentially longer than 15 days for feature visibility)

Impact:
All end users

Action:
Change management suggested/FYI

More Information
Help Center: See and use suggested charts and analysis in a spreadsheet
Help Center: Create and use pivot tables
Help Center: Customize a pivot table
Help Center: GETPIVOTDATA
Help Center: Chart and graph types
Help Center: Import data sets and spreadsheets
Help Center Separate cell text into columns


Launch release calendar
Launch detail categories
Get these product update alerts by email
Subscribe to the RSS feed of these updates

New languages now supported in Google Docs and Slides files, as well as Docs editors templates

No matter where you or your customers or colleagues are located, we want to make sure Google Docs and Slides work for you at work. That’s why we’re expanding the font catalogue in Docs and Slides to support 62 languages, including non-Latin scripts like Cyrillic and Devanagari (with more coming soon!).

To find these new fonts and others, simply click More fonts at the bottom of the Fonts menu. There you’ll also find suggested fonts, based on your document’s language.


In addition, we’re making Google Docs, Sheets, Slides, and Forms templates available in four new languages: European Spanish, Latin American Spanish, French, and Brazilian Portuguese. Stay tuned for additional languages, including Hindi, coming soon.

Launch Details
Release track:
Launching to both Rapid Release and Scheduled Release

Editions:
Available to all G Suite editions

Rollout pace:
Full rollout (1–3 days for feature visibility)

Impact:
All end users

Action:
Change management suggested/FYI

More Information
Help Center: Change how paragraphs & fonts look


Launch release calendar
Launch detail categories
Get these product update alerts by email
Subscribe to the RSS feed of these updates

Copy comments and suggestions in Google Docs, Sheets, and Slides

Google Docs, Sheets, and Slides make it easier than ever to collaborate on great content. Which is why it’s increasingly important not to lose a history of that collaboration when you duplicate a document, spreadsheet, or presentation. With that in mind, we’re making it possible to copy comments and suggestions any time you make a copy of a Docs, Sheets, or Slides file.

To copy your comments and suggestions, simply select “Make a copy” from the File menu and check the box for “Copy comments and suggestions” or “Copy comments.”


These comments and suggestions will then contain a note indicating that they were copied from the original document.


Check it out today, and collaborate—even on copies—with ease.

Launch Details
Release track:
Launching to Rapid Release, with Scheduled Release coming on November 29th, 2017

Editions:
Available to all G Suite editions

Rollout pace:
Full rollout (1–3 days for feature visibility)

Impact:
All end users

Action:
Change management suggested/FYI

More Information
Help Center: Create, view, or save a file


Launch release calendar
Launch detail categories
Get these product update alerts by email
Subscribe to the RSS feed of these updates

Turning down the in-app passcode feature in Google Drive, Docs, Sheets, and Slides on iOS

In the past, we’ve heard feedback that customers want more security for the files on their iOS devices, which led us to enable an in-app passcode feature specifically for the Google Drive, Docs, Sheets, and Slides iOS apps. Over time, however, we’ve come to learn that it’s not just the content within Google Drive that’s valuable to you. Your contacts, calendars, and emails—it's important that all of this is secure as well.

As a result, we began putting particular emphasis on supporting mobile device management (MDM) on iOS. For example, recent launches give G Suite admins greater visibility and control over enterprise-deployed iOS devices. In fact, with MDM, admins can enforce a passcode on all iOS devices that access corporate data, and they can wipe account data on a device if it’s compromised.

Owing to this increased investment in security on iOS devices, we’re ending support for the in-app passcode feature in Google Drive, Docs, Sheets and Slides on iOS devices signed in with G Suite accounts. Support will end on December 4th, 2017, and we’ll remove the feature entirely no earlier than January 8th, 2018.

We highly recommend that administrators use MDM to deploy passcode requirements at the system level on all of their iOS devices by following these instructions. This will provide better security than the in-app passcode feature in two key ways:
  • These passcode policies protect all of the content on your managed devices, including photos, contacts, and other content besides Google Drive, Docs, Sheets, and Slides content.
  • These passcode policies give you more control over passcode type, strength, expiration, and failure cases. See this Help Center article for more details.

Beginning on December 4th, 2017, any user signed in with a G Suite account who has this feature will see a message asking them to either acknowledge and turn off the functionality, or to ignore the message temporarily. Beginning on January 8th, 2018, all new versions of the Google Drive, Docs, Sheets, and Slides iOS apps will no longer contain in-app passcode functionality.


Launch release calendar
Launch detail categories
Get these product update alerts by email
Subscribe to the RSS feed of these updates

Create custom headers and footers in Google Sheets

To create professional-looking spreadsheets, it’s often critical that you can append them with certain information—for instance, your company’s name, a confidentiality notice, and any other important details. With this launch, we’re making it easier to do just that. Going forward, you can customize the headers and footers in your Google Sheets documents with the text of your choosing. In addition, you can select from many more pre-defined options (for date, time, etc.) and move those options around within your header and footer. Simply choose “EDIT CUSTOM FIELDS” from the Print settings menu to get started.



As a bonus, we’re also introducing saved print settings with this launch. Just modify your settings once, and they’ll be retained the next time you—or a collaborator—opens that same spreadsheet.

Launch Details
Release track:
Launching to Rapid Release, with Scheduled Release coming in two weeks

Editions:
Available to all G Suite editions

Rollout pace:
Full rollout (1–3 days for feature visibility)

Impact:
All end users

Action:
Change management suggested/FYI


Launch release calendar
Launch detail categories
Get these product update alerts by email
Subscribe to the RSS feed of these updates

Get on the same page: new Google Docs features help power team collaboration

(Cross-posted from The Keyword, with some additional details)

Getting people on the same page for a project can be tough. It requires managing a ton of opinions and suggestions. The last thing you should have to worry about is making sure your team is literally working on the same document. That’s why we built our powerful real-time editing tools to help with this—Google Docs, Sheets and Slides—so that teams can work together at the same time, using the most up-to-date version.

Today, we're introducing new updates to better help with "version control," to customize tools for your workflows, and to help teams locate information when they need it.

Track changes, make progress

It can take dozens of edits to make a document just right—especially a legal agreement, project proposal or research paper. These new updates in Docs let you more easily track your team’s changes. Now, your team can:

1. Name versions of a Doc, Sheet or Slide on the web.
Being able to assign custom names to versions of your document is a great way to keep a historical record of your team's progress. It's also helpful for communicating when a document is actually final. You can organize and track your team’s changes in one place under “Version history” (formerly known as “Revision history”) on the web. Select File > Version history > Name current version. For even quicker recall, there’s an option to select “Only show named versions” in Docs, Sheets or Slides.

2. Preview “clean versions” of Docs on the web to see what your Doc looks like without comments or suggested edits.
Select Tools > Review suggested edits > Preview accept all OR Preview reject all.

3. Accept or reject all edit suggestions at once in your Doc so your team doesn’t have to review every single punctuation mark or formatting update.
Select Tools > Review suggested edits > Accept all OR Reject all.

4. Suggest changes in a Doc from an Android, iPhone or iPad device.
Click the three dots menu in the bottom right of your Doc screen to suggest edits on the go. Turn on the “Suggest changes” toggle and start typing in “suggestion mode.”

5. Compare documents and review redlines instantly with Litera Change-Pro or Workshare Add-ons in Docs. 


Here’s a quick way to preview and accept all changes (or reject them) and name versions of your document.


Use new templates, add-on time-saving functionality

Teams use templates in Docs and Sheets to save time on formatting. At the same time, developers are building add-ons to customize functionality. We thought, why not bring these two together? That’s why today, we’re introducing new templates with built-in add-ons and the ability to create your own, so your templates not only look good—but they make sure the work gets done.

These templates allow you to customize and deploy tools specific to your organization’s workflows. We’ve launched five examples of this in the general template gallery, like the new Mutual Non-Disclosure Agreement (NDA) template from LegalZoom and DocuSign. With this template, businesses can quickly create an NDA and collect signatures using the DocuSign Add-on for Docs. Bonus: it also automatically detects the required signature fields on the template, which saves even more time when you request signatures. This is just one of a few new templates—we’ve also worked with Lucidchart to create a business process manual, PandaDoc for a consulting agreement, Supermetrics for a website paid traffic report, and EasyBib for an MLA report. Each should help you save time and maximize efficiency throughout your team’s workflows.

In addition, you can create your very own template with built-in add-on customized to your company’s workflows. For example, create a Sheets template paired with an add-on to gather internal approvals or an invoice template in Docs (paired with an add-on) that pulls information from your CRM system.

Admins, if you don’t currently allow your users to install add-ons, you can still use these new templates by deploying specific add-ons only. Or, if you’d prefer to allow your users to install only certain add-ons, you can block specific third-party OAuth scopes and whitelist only those add-ons you trust.

Note that templates paired with add-ons abide by the same Admin console settings as all other templates and are available in English only.


The new Mutual NDA template from LegalZoom and DocuSign lets you collect NDA approvals stat.


Find the information you need, when you need it

Sometimes the hardest part of creating a proposal or client presentation is tracking down the information you need to include in it. Starting today for G Suite Business and Enterprise customers, Google Cloud Search will integrate with Docs and Slides via the Explore feature. Using Machine Intelligence, Cloud Search surfaces relevant information to help you work more efficiently throughout your day.

To get started, open the Explore tab in Docs or Slides and type what you’re looking for. Cloud Search will show you important details from your information across your G Suite apps including Gmail, Drive, Calendar, Sites and more, to help you create top-notch Docs and presentations.


Now you can use Google Cloud Search through the Explore feature in Docs and Slides.


Teams are using Docs to collaborate in creative ways. Check out this post for inspiration, or visit the Docs site to get started.

Launch Details
Release track:
  • Versions and Cloud Search in Explore
    • Launching to Rapid Release, with Scheduled Release coming in two weeks
  • Suggestions
    • Mobile features launching to both Rapid Release and Scheduled Release
    • Web features launching to Rapid Release, with Scheduled Release coming in two weeks
  • Templates
    • Launching to Rapid Release, with Scheduled Release coming in two weeks*
*Templates created by our partners will appear immediately in all template galleries, but the add-on functionality associated with them will launch only to domains on the Rapid Release track. Domains on the Scheduled Release track will see add-on functionality in two weeks.

Editions:
  • Versions, Suggestions, and Templates
    • Available to all G Suite editions
  • Cloud Search in Explore
    • Available to G Suite Business and Enterprise editions with Cloud Search enabled only

Rollout pace:
  • Versions, Suggestions, and Templates
    • Gradual rollout (up to 15 days for feature visibility)
  • Cloud Search in Explore
    • Extended rollout (potentially longer than 15 days for feature visibility)

Impact:
  • Versions and Suggestions
    • All end users
  • Templates and Cloud Search in Explore
    • Admins and end users

Action:
  • Versions and Suggestions
    • Change management suggested/FYI
  • Templates and Cloud Search in Explore
    • Admin action suggested/FYI

More Information


Launch release calendar
Launch detail categories
Get these product update alerts by email
Subscribe to the RSS feed of these updates

Visualize data instantly with machine learning in Google Sheets

Sorting through rows and rows of data in a spreadsheet can be overwhelming. That’s why today, we’re rolling out new features in Sheets that make it even easier for you to visualize and share your data, and find insights your teams can act on.

Ask and you shall receive → Sheets can build charts for you

Explore in Sheets, powered by machine intelligence, helps teams gain insights from data, instantly. Simply ask questions—in words, not formulas—to quickly analyze your data. For example, you can ask “what is the distribution of products sold?” or “what are average sales on Sundays?” and Explore will help you find the answers.

Now, we’re using the same powerful technology in Explore to make visualizing data even more effortless. If you don’t see the chart you need, just ask. Instead of manually building charts, ask Explore to do it by typing in “histogram of 2017 customer ratings” or “bar chart for ice cream sales.” Less time spent building charts means more time acting on new insights.



Instantly sync your data from Sheets → Docs or Slides

Whether you’re preparing a client presentation or sharing sales forecasts, keeping data up-to-date can be time-consuming, especially if you need to update charts or tables in multiple sources. This is why we made it easier to programmatically update charts in Docs and Slides last year.

Now, we’re making it simple to keep tables updated, too. Just copy and paste data from Sheets to Docs or Slides and tap the “update” button to sync your data.



Even more Sheets updates

We’re constantly looking for ways to improve our customers’ experience in Sheets. Based on your feedback, we’re rolling out more updates today to help teams get work done faster:

  • Keyboard shortcuts: Change default shortcuts in your browser to the same spreadsheet shortcuts you’re already used to. For example, delete a row quickly by using “Ctrl+-.”
  • Upgraded printing experience: Preview Sheet data in today’s new print interface. Adjust margins, select scale and alignment options or repeat frozen rows and columns before you print your work.
  • Powerful new chart editing experience: Create and edit charts in a new, improved sidebar. Choose from custom colors in charts or add additional trendlines to model data. You can also create more chart types, like 3D charts. This is now also available for iPhones and iPads.
  • More spreadsheet functions: We added new functions to help you find insights, bringing the total function count in Sheets to more than 400. Try “SORTN,” a function unique to Sheets, which can show you the top three orders or best-performing months in a sales record spreadsheet. Sheets also supports statistical functions like “GAMMADIST,” “F.TEST” and “CHISQ.INV.RT.”
  • Increased support for charts in the Sheets API: Use the API to programmatically generate most charts with support for dozens of new operations.

These new features in Sheets are rolling out starting today. Learn how Sheets can help you find valuable insights.

One last thing—so that we can focus our efforts on the improvements to charts outlined above, we’re also deprecating one of the lesser-used chart types: the Motion chart. Beginning in July 2017, you will no longer be able to insert or create Motion charts, and, in September 2017, you will no longer be able to edit them.

No earlier than December 2017, any Motion charts still in Sheets will become static images and no longer update when their corresponding data changes.

We recommend trying Bubble charts instead.

Launch Details
Release track:

  • All mobile and API features launching to both Rapid release and Scheduled release on June 1st, 2017
  • All web features launching to Rapid release on June 1st, 2017, with Scheduled release coming on June 14th, 2017

Editions:
Available to all G Suite editions

Rollout pace:
Gradual rollout (up to 15 days for feature visibility)

Impact:
All end users

Action:
Change management suggested/FYI

More Information
Help Center: Add a chart or graph to a spreadsheet
Help Center: Chart types
Help Center: Add a chart or table to Google Docs or Slides



Launch release calendar
Launch detail categories
Get these product update alerts by email
Subscribe to the RSS feed of these updates

Google I/O session recap: how to build custom apps with App Maker

Posted by Geva Rechav, Product Manager, App Maker

Every company has workflows and processes that are unique to its business, customers and employees. Often, these are captured manually within large spreadsheets or ad-hoc databases with macros and scripts. But what if they could be turned into custom business apps instead? Apps that provide useful UIs and distinct user roles, while helping to minimize data entry errors and increase productivity?

This year at Google I/O, I shared reasons why businesses should use App Maker—our low-code, application development tool that lets companies quickly build custom apps in G Suite. Check it out here:


And for those who’d like more detail, here is a recap of my presentation.

Closing enterprise “app gaps” with App Maker 

“App gaps” are a reality for most companies, even those that embrace major SaaS products. Think about the edge cases that aren’t addressed with a standard CRM offering like conducting territory planning or tracking asset performance.

We experienced similar gaps at Google. A few years ago, our HR recruiters were overwhelmed with the thousands of monthly interviews that each generated lengthy feedback reports from multiple interviewers. This volume made it difficult for hiring committees to calibrate candidates and make timely decisions, and resulted in delayed responses. To fix this, our IT team decided to build an app by cobbling elements from our own infrastructure.

Over time, more app requests came in from other parts of Google, so we created App Maker. What started as a handful of apps within Google, evolved into nearly 400 internal apps used by thousands. Plus, the majority of these apps were built by non-engineers outside of IT.

Today, App Maker gives software engineers and citizen developers—like business analysts or coding enthusiasts—the ability to quickly build and deploy apps to get around their workflow challenges.

How does it work? 

App Maker makes it easy to build apps in days, not months, because of its easy data-binding and drag-and-drop UI design. You can also integrate your apps with various data sources, Google services or APIs to cover broad legacy assets. Any app you create is also a part of Drive in G Suite so your data never leaves your domain.

Here’s how to build an App Maker app in three steps:
  1. Define your data models, by importing existing Google Sheets to App Maker, connecting to Google Cloud SQL instances, or manually defining custom objects field by field.
  2. Build your UI by adding pre-built components like data entry forms, report templates and easily create event triggers and application flows. 
  3. Optionally, add open source HTML, CSS and JavaScript to run on the client UI and on the app server, implementing custom functionality that’s not provided out-of-the-box.
App Maker is currently in Early Adopter Program (EAP) for every G Suite Business customer. To get started, apply here.

Ideas to get started 

By now you’re probably wondering what you can build. Well, based on our customers’ experience, here are some good starting points:
  • If you have a large Sheet with more than a handful of users updating it regularly: Sheets usually have an underlying workflow. An App Maker app will provide a better UI for it—showing the workflow visually, prompting for actions and eliminating data entry errors. 
  • If you perform recurring bulk operations in Calendar or Gmail: Say an employee joins or leaves a department, you can build an App Maker app to generate the appropriate bulk-operations in a few clicks. 
  • If your company is already using Apps Script and BigQuery: This means you’ve already invested in customizing workflows. App Maker can increase the velocity of developing custom apps.
Go build your apps with App Maker in G Suite—sign up for the EAP today.

Upcoming changes to chat in Google Docs, Sheets, and Slides

Chatting in Google Docs, Sheets, and Slides makes collaboration easier, as users can discuss a document while they work on it—without leaving the document itself. As many of you know, the current Docs Editors chat functionality is built on Google Talk, which we previously announced will be shutting down at the end of June.

We want to be sure you can continue to use chat in Docs, Sheets, and Slides, so—over the course of the next few weeks—we’ll make a few small changes and decouple the feature from Talk. As of June 7th, 2017, shortly before the Talk shutdown, organizations on the Rapid release track that have the Google Hangouts service enabled will have chat available in the Docs Editors; organizations on the Scheduled release track with Hangouts enabled will have chat in the Docs Editors starting on June 21st.*

If you currently have the Hangouts service enabled but Talk disabled, chat in Docs, Sheets, and Slides is not available to your users at this time. After June 7th or 21st (depending on your release track), however, your organization will begin to be able to use chat in the Docs Editors.* We encourage you to communicate the new feature to your users ahead of time. There will be no in-app promotion; users will simply see the chat button below appear in Docs, Sheets, and Slides when collaborators are in the document.


If a user clicks on that button, a chat window like the one below will appear on the right side of the screen, allowing him or her to chat with others in the document.


We’ll be making further improvements to chat in Docs, Sheets, and Slides in the future, so stay tuned for additional updates.

*IMPORTANT: Please see the Help Center for a list of exceptions.

Launch Details
Release track:
Launching to Rapid release on June 7th, with Scheduled release coming on June 21st

Editions:
Available to all G Suite editions

Rollout pace:
Full rollout (1–3 days for feature visibility)

Impact:
Admins and end users

Action:
Change management suggested/FYI

More Information
Help Center: Chat with others in a file


Launch release calendar
Launch detail categories
Get these product update alerts by email
Subscribe to the RSS feed of these updates

Web clipboard to be removed from Google Docs, Sheets, and Slides on September 13th, 2017

The web clipboard in Google Docs, Sheets, and Slides was originally developed to improve the copy and paste experience in browsers with fidelity issues. As these issues have become less prevalent across many browsers, we’re looking to simplify the user experience by removing the web clipboard, which is rarely used, on September 13th, 2017. We’re also planning enhancements to the traditional copy and paste functionality in Docs, Sheets, and Slides, so stay tuned for more info.



Launch release calendar
Launch detail categories
Get these product update alerts by email
Subscribe to the RSS feed of these updates