Saturday, July 11, 2020
Home Science Google Sheets picking up AI-powered Smart Fill and Smart Cleanup this year...

Google Sheets picking up AI-powered Smart Fill and Smart Cleanup this year – 9to5Google

Google’s goal with G Suite is to leverage AI to boost user productivity, with Smart Compose in Gmail and Docs being prime examples. Google Sheets is gaining similar features this year with Smart Fill and Smart Cleanup.

Google wants to automate data entry in Sheets in the same way Smart Compose saves you from typing repetitive phrases and reduces mistakes in the process. Smart Fill “detects and learns patterns between columns to intelligently autocomplete data.”

Suggestions highlight the affected column with users able to hit the checkmark in the overlay or use a keyboard shortcut.

Say you have a column of full names, but you want to split it into two columns (first and last name, for example). As you start typing first names into a column, Sheets will automatically detect the pattern, generate the corresponding formula, and then autocomplete the rest of the column for you.

Meanwhile, Smart Cleanup in Sheets is designed to “make data cleanup faster and more accurate.” After importing, a “Data cleanup” side panel generates suggestions to remove duplicate rows and address other formatting issues.

Once “Done with cleanup,” you can “Review column data” to see visualizations and stats:

You’ll also see column stats that provide a quick snapshot of your data, such as the distribution of values or most frequent value in a column, helping you quickly catch potential outliers and confidently move on to analysis.

These two features will be available for G Suite customers later this year.

More about G Suite:

FTC: We use income earning auto affiliate links. More.


Check out 9to5Google on YouTube for more news:

About the Author

Read More

4 COMMENTS

LEAVE A REPLY

Please enter your comment!
Please enter your name here

- Advertisment -

Most Popular

LinkedIn sued after being caught reading users’ clipboards on iOS 14 – 9to5Mac

LinkedIn was recently caught reading users’ clipboards on iPhone and iPad thanks to the new privacy features of iOS 14, as we reported last week. Even though the company claimed it was due a software bug, there’s now an iPhone user who’s suing LinkedIn for supposedly reading sensitive content from the clipboard without permission. According…

Dodge Challenger SRT Hellcat Redeye Widebody review: Business Insider – Business Insider – Business Insider

The Challenger SRT Hellcat Redeye is a whole lotta car. Matthew DeBord/Insider I drove a $92,245 Dodge Challenger SRT Hellcat Redeye Widebody, the most thoroughly insane trim level of Dodge's two-door, neo-muscle car.The car has a 6.2-liter supercharged V8 that makes 797 horsepower.That kind of power is staggering, but the Challenger is also a very…

Google Might Try to Save Its Fitbit Deal From EU Regulators By Promising Not to Use Health Data for Ads – Gizmodo

Fitbit’s devices, like the Versa 2 smartwatch, collect a ton of health data.Photo: Victoria SongEuropean regulators are examining Google’s deal to acquire Fitbit, even seeking perspective from healthcare providers and the company’s rival wearable device makers. This appears to be making Google sweat a little bit, according to a Reuters report, because the company may…

Upcoming Toyota Supra GRMN Will Get the 510-HP BMW M3 Engine: Report – The Drive

A manual transmission is not likely, however.ToyotaThe most common gripe with the fifth-generation Supra is not a lack of power, but the lack of a manual transmission. It's a bit odd, but I suppose still welcome, that our second-place prayers for an even faster Supra may soon be answered. The Japanese-language publication Best Car Web…