Google Sheets will soon be able to autocomplete data for you

Frederic Lardinois

Google today announced a couple of updates to Google Sheets that will make building spreadsheets and analyzing data in them a little bit easier.

The most interesting feature here, surely, is the upcoming launch of Smart Fill. You can think of it as Smart Compose, the feature that automatically tries to finish your sentences in Gmail, but for spreadsheets. The idea here is that Smart Fill, which will launch later this year, can autocomplete your data for you.

"Say you have a column of full names, but you want to split it into two columns (first and last name, for example)," Google explains in today's announcement. "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."

That's a nifty feature, though it's worth noting that Microsoft has made some major strides in bringing a lot of ML-based features to Excel, too, which can now automatically create new columns based on its understanding of what your spreadsheet is about, for example. It just extended the number of these AI-driven data types to well over 100 at its Build developer conference. The use case here is a bit different, but both companies are using similar techniques to make building spreadsheets easier.

One feature that's nice about how Google built this is that it doesn't so much auto-magically fill a column but that it builds a formula to fill it, giving you quite a bit of flexibility to then manipulate that data as needed.

The second new feature that will be coming in the near future is Smart Cleanup, which, as the name implies, can help you clean up your data by finding duplicate rows and formatting issues. The tool will suggest changes, which users can then accept or ignore.

The company also today announced the general availability of Connected Sheets, a feature that connects a BigQuery data warehouse with Sheets so that you can analyze petabytes of data in sheets without having to know SQL or really any programming language. This feature aims to democratize access to big data analytics by giving anybody in a company who knows how to use a spreadsheet the ability to analyze that data and create charts based on it.

Connected Sheets is now available to G Suite Enterprise, G Suite Enterprise for Education and G Suite Enterprise Essentials users.

More From

  • Ford blends tech and nostalgia in the 2021 Bronco

    After 24 years, Ford relaunched the 2021 Bronco in a splashy reveal streamed Monday evening on ABC, ESPN and National Geographic, each short film showcasing a different member of the family: the Bronco 2-door, Bronco 4-door and Bronco Sport. The Bronco 2021 — Ford's flagship series of 4x4 vehicles — is a brand that leans heavily on nostalgia, customization, functional design and technology such as the automaker's next-generation infotainment system and a digital trail mapping feature that lets owners plan, record and share their experiences via an app. This is not the 1966 Ford Bronco, the first year that the rugged two-door off-roader came to market to compete with the Jeep CJ-5.

  • BigCommerce files to go public

    As expected, BigCommerce has filed to go public. BigCommerce, similar to public market darling Shopify, provides e-commerce services to merchants. Given how enamored public investors are with its Canadian rival, the timing of BigCommerce's debut is utterly unsurprising and is prima facie intelligent.

  • Snapchat tests TikTok-style navigation for exploring public content

    Snapchat could be gearing up to more directly challenge TikTok. The company confirmed it's testing a new experience that allows users to move through Snapchat's public content with a vertical swiping motion -- a gesture that's been popularized by TikTok, where it allows users to advance between videos. Snapchat says the feature is one of its experiments in exploring different, immersive visual formats for community content.

  • Mighty Health created a wellness app with older adults top of mind

    Virtual classes might make it easier to work out anywhere, anytime, but not for anyone. Mainstream fitness tech often targets the young and fit, in advertisements and cardio-heavy exercises. This gap between mainstream fitness and elders is where Mighty Health, a Y Combinator graduate, comes in. Mighty Health has created a nutrition and fitness wellness app that is tailored to older adults who might have achy hips or joint problems.