Google Sheets Update: Improved Data Analysis and Smart Fill Experience

Google today announced updates for Google Sheets to make spreadsheet creation and data analysis easier, such as Gmail-like Smart Fill. Google has previously offered its own email service a “smart compose” feature that automatically completes sentences, but Smart Fill, scheduled for later this year, helps Google Sheets spreadsheet users automate data completion.

Google Sheets Update: Improved Data Analysis and Smart Fill Experience

“If you want to split a full list into two columns of last name and first name, Google Sheets automatically detects the pattern and generates the corresponding formula when you start typing your first name in the column, and then automatically completes the rest of the column for you,” Google said in the announcement.

While this is a good feature, we can’t forget its competitors. Microsoft Excel, for example, has a deeper understanding of the user’s spreadsheet operations (also supports the creation of new columns automatically) with the addition of machine learning (ML).

PwC Uses Connected Sheets to scale data insights (via)

Clearly, both companies are trying to use similar technologies to simplify the creation of spreadsheets. Also at the Build Developer conference, Microsoft announced that it has expanded support for AI-driven data types to 100 plus.

However, Google Sheets’ implementation is something special, and it doesn’t automatically populate the column, but instead builds a formula to complete the fill. While providing sufficient flexibility, the data can be manipulated according to actual needs.

Google Sheets Update: Improved Data Analysis and Smart Fill Experience

The second feature that is coming soon is Smart Cleanup.

As the name implies, it helps users understand redundant data by looking for duplicate rows and formatting problems. The tool provides suggestions for modifications, but the final decision is still in the hands of the user (optionally accepted or ignored).

Google Sheets Update: Improved Data Analysis and Smart Fill Experience

Google also announced today the Company Sheets feature improvements: by linking to The BigQuery Data Warehouse and e-forms so that users who lack SQL or any programming language skills can easily analyze pb data in the form.

For users who know how to use spreadsheets to analyze data and create charts, Connected Sheets makes it easier to analyze big data, and interested users can experience it on G Suite Enterprise, Education, and Basics.