What Is It?

We have all been there: you receive a messy list in an email, a raw data dump from a CRM, or a collection of notes that need to become a structured report. Manually formatting this into a professional spreadsheet is often a tedious, time-consuming hurdle. Today, Google is changing that by introducing a new, AI-driven feature in Google Sheets that leverages Gemini to transform raw, unformatted text into organized tables automatically.

Whenever you paste content—be it bulleted lists, free-form text, or even JSON snippets—into a cell, Google Sheets will now surface a "Convert to table" button. With just one click, Gemini analyzes the structure of your data and intelligently maps it into columns and rows. It is a seamless transition from "chaos" to "clarity," allowing you to skip the tedious formatting phase and move straight to analysis.

What Is the Impact?

info
The impact of this feature on your daily business operations is profound. By automating the data entry process, you eliminate the repetitive manual labor that often leads to fatigue and transcription errors. This allows your team to focus on higher-value tasks, such as interpreting data patterns and making data-driven business decisions, rather than wrestling with spreadsheet alignment.

Furthermore, this feature acts as a bridge between disparate information sources. Whether you are pulling data from a meeting summary or a raw external report, Gemini ensures that the information is quickly standardized. This consistency is key for team collaboration; when everyone uses the same clean table structure, sharing insights becomes much more efficient across departments.

Ultimately, this is about operational agility. The faster you can transform information into a usable format, the faster you can act on it. By integrating Gemini directly into the paste workflow, Google is removing the friction that typically slows down data management, empowering businesses to remain competitive in a fast-paced digital environment.

Structure data in Sheets with Gemini

Who Is It For?

This feature is designed for professional teams and power users who rely on Google Workspace to manage their data.

  • check_circle**Business Standard & Plus:** Ideal for teams managing project data and client lists.
  • check_circle**Enterprise Standard & Plus:** For organizations that require advanced AI-assisted data workflows.
  • check_circle**Education:** Specifically for those with a Google AI Pro for Education license.
  • check_circle**Consumers:** Available to Google AI Pro and Ultra subscribers.

When Will It Roll Out?

The rollout is being handled in two phases to ensure a smooth transition:

  • Rapid Release domains: Starting April 22, 2026 (gradual rollout up to 15 days).
  • Scheduled Release domains: Starting May 6, 2026 (gradual rollout up to 15 days).

What Should You Do?

To leverage this feature, ensure that your Workspace settings are configured correctly to allow for "Smart features."

1
Step 1: Check Admin Settings
Navigate to the Google Admin console via
Appsarrow_forward_iosGoogle Workspacearrow_forward_iosGoogle Drive and Docsarrow_forward_iosSettings for Drive and Docs
and ensure that "Smart features" are enabled for your users.
2
Step 2: Paste your data
Copy any unstructured text, list, or data snippet and paste it directly into your Google Sheet.
3
Step 3: Convert
Look for the "Convert to Table" prompt that appears near your pasted text. Click it to let Gemini do the heavy lifting.
4
Step 4: Review and adjust
Verify the generated columns and rows; Gemini will handle the mapping, but feel free to tweak the headers as needed.