Google Brings Cleanup Suggestions and Column Stats Features in Google Sheets


Google launches two new features: Cleanup suggestions and Column stats, that will helps to prepare and analyze data in Google Sheets. Cleanup suggestions will help ensure your data is accurate by identifying and suggesting fixes for common data errors. And Column stats will provide automated insights about the values within a column, so you can identify outliers and quickly get a sense of what your data looks like.

These features assist you in the identification of possible cleanup actions and help you be more confident that your data isn’t distorted by simple errors. It will enable quicker analysis by generating intelligent views that can help surface insights, so you can choose to look into more closely.

Cleanup suggestions will help you by surfacing intelligent suggestions in the side panel, these suggestions may include removing extra spaces, removing duplicate rows, adding number formatting, identifying anomalies, fixing inconsistent data, and more. This feature will help make data cleanup faster and more accurate.

When you’re in Google Sheets, go to Data > Cleanup suggestions, when you import data into Sheets and suggestions will be detected, then a Data cleanup notification will appear on the bottom right > click See all. When the sidebar is open, click on the (! button) on each column to view detected suggestions. When you scroll over a suggestion, the related cells are highlighted in your Sheets.

Google Brings Cleanup Suggestions and Column Stats Features in Google Sheets

Column stats will help you to quickly get a sense of your data by automatically generating visualizations and key stats that provide insight into the data in a specific column. This will include count and distribution charts, frequency tables, and summary statistics. When you’re in Google Sheets, go to Data > Column stats and review the stats in the sidebar. Once you have reviewed your suggestions, click Review Column Stats. At the top of the sidebar, use the arrows < > to switch between columns.

Google Brings Cleanup Suggestions and Column Stats Features in Google Sheets

Follow Us
Shop by Brands
Shop by Category
Accessories58 ProductsClothing89 ProductsHoodies2 ProductsAdapters1 ProductsAir Purifier3 ProductsAmino Acids1 ProductsAppliances4 ProductsAudio7 ProductsAudio Cables1 ProductsBatteries1 ProductsBeauty1 ProductsBoots1 ProductsCables1 ProductsCables & Adapters1 ProductsCamera6 ProductsCases and Covers17 ProductsCasual Dresses8 ProductsChocolates and Desserts82 ProductsCoffee20 ProductsComputer Cases1 ProductsCondenser Microphones1 ProductsCreatine1 ProductsDiet & Sports Nutrition4 ProductsDisposable Batteries1 ProductsEarbud Headphones19 ProductsElectronics99 ProductsFootwear1 ProductsFor iPhone16 ProductsFor LG Mobiles1 ProductsFor Men1 ProductsFor Mens2 ProductsGaming Consoles2 ProductsGaming Controllers12 ProductsGaming Mice2 ProductsGaming Monitors1 ProductsGraphic Shirt3 ProductsGraphic Shorts2 ProductsGraphic Tees18 ProductsGraphic Trousers1 ProductsGrocery102 ProductsHair Care1 ProductsHair Serums1 ProductsHeadphones26 ProductsHealth & Household6 ProductsIn-Ear Monitors2 ProductsInstant Coffee20 ProductsInternal HDD1 ProductsiPhone 7/8/SE 2020/SE 202216 ProductsJacket2 ProductsJogger3 ProductsLaptop Bag1 ProductsLavalier Microphones1 ProductsLEGO Toys5 ProductsLens Mount Adapters1 ProductsLenses1 ProductsLG G7 ThinQ1 ProductsLighting & Studio2 ProductsMasks1 ProductsMassage Chairs1 ProductsMassagers1 ProductsMens60 ProductsMice2 ProductsMicrophones1 ProductsMicrophones2 ProductsMicrophones & Accessories1 ProductsMobile36 ProductsMobile Accessories17 ProductsMonitors1 ProductsOutdoor Backpack1 ProductsPC Components7 ProductsPersonal Care & Beauty2 ProductsProtein Supplements1 ProductsShirts12 ProductsShorts4 ProductsShotgun Microphones1 ProductsSling bag1 ProductsSmart Displays13 ProductsSmart Home14 ProductsSmart Lighting1 ProductsSmart Speakers & Displays13 ProductsSmartwatch6 ProductsSoftware6 ProductsSpa & Relaxation1 ProductsSports Nutrition4 ProductsStreaming Media Players2 ProductsSweater Jacket1 ProductsT-Shirts3 ProductsT-Shirts31 ProductsTablets1 ProductsTea & Beverages1 ProductsToys5 ProductsTripods1 ProductsTripods & Supports1 ProductsTripods Legs1 ProductsTrousers1 ProductsTRS M to XLR Cables1 ProductsTVs1 ProductsVacuum Cleaners1 ProductsVideo Games9 ProductsVideo Lighting1 ProductsVitamins/Minerals Supplements2 ProductsWearable14 ProductsWellness2 ProductsWhey Proteins1 ProductsWhistle1 ProductsWireless Speakers4 ProductsWomen1 ProductsWomen29 Products

Copyright © 2019 – 2022 All Right Reserved. Disclosure: is supported by its readers & shoppers like you. When you purchase through links on our site, we may get paid by brands or deals, including promoted items at no extra cost to you, this will help us to keep our website running. Read our ethics HERE. Note: The pricing and availability are accurate as of the time of publication but are subject to change in the future.