GOOGLE SHEETS, Will Soon Autocomplete Data For Users!


Google Sheets

The search and Android giant updated its Google Sheets yesterday, however, this comes with the company’s sets of updates aimed at making building spreadsheets and data analysis in these tools easier than they were. A feature viewed as ‘Smart Compose’ which automatically attempts to wrap-up a user’s sentences in Gmail, however, for spreadsheets.

In the company’s yesterday’s announcement, it talked about the ‘Smart Fill’ feature – a feature that can autocomplete user’s data appears to be the most interesting thing but will launch later this year. Based on this, Google made it clear in an explanation:

“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”.

Elsewhere, efforts have also been made by OS giant – Microsoft with the introduction of a good number of ML-based features to Excel, that could as well automatically create new columns based on its understanding of what an individual’s spreadsheet is meant for. However, it’s understood, both companies are currently using similar techniques to make building spreadsheets a lot easier. Though Google’s implementation and use are quite different, while for Microsoft’s Build developer conference – saw the extension of a good number of AI-driven data types to well over 100.

Meanwhile, don’t get so excited about the new feature of Google sheets yet. One unique thing about how Google actually built this is the fact that it does not auto-magically fill a column irrespective of the AI, but builds a formula to fill it. That will rather give users a bit of flexibility for them to make changes to that data as needed. Another feature that users should expect in future is the ‘Smart Cleanup’ that will be used to clean up data by finding duplicate rows and formatting issues. This tool will suggest some changes, and a user could either accept or ignore.

Lastly, which was announced is the accessibility of ‘Connected Sheets’, currently available to G Suite Enterprise, which includes G Suite Enterprise for Education and G Suite Enterprise Essentials users. The ‘Connect Sheets’ is practically a feature that connects a BigQuery data warehouse with the aid of Sheets so that users can analyze petabytes of data in sheets without having to know about SQL or knowing any programming language.

Be the first to comment about Google Sheets latest update?