Summary  
The chapter covers automated data cleaning and formatting techniques—such as trimming extra spaces, standardizing inconsistent entries and date formats, handling missing values, and converting data types—by describing desired transformations rather than fixing each cell manually.

General domain of usage  
Spreadsheet data processing


Raw data is often messy and hard to use.
Gemini helps you clean and format it so you can work with it faster.





## Situation

You receive a spreadsheet from a colleague.

The data has problems:
* Inconsistent formatting;
* Mixed text styles;
* Extra spaces;
* Missing or unclear values.

For example:

* Names written differently;
* Dates in different formats;
* Numbers stored as text.

You need to clean it before using it in reports.




Inside Google Sheets, you select the data and describe what needs to be fixed.



Generate a clean data table based on the data provided.

Prompt

Gemini formats and prepares the data for use. You can provide further guidance if needed.

You don't need to fix each cell manually. Instead, describe the problem, and Gemini will handle the cleanup. Your focus is on utilizing the data rather than fixing it.

Discover how to use Gemini across Google Workspace to handle everyday work tasks faster. Write emails, create documents, analyze data, build presentations, manage meetings, and find information across files using practical workflows. Focus on real scenarios and clear results while reducing manual work and saving time.

Explore how Gemini works inside Google Workspace and where it appears across your daily tools.
Understand how access and pricing work, and what affects availability in your account.

Explore how to write, reply, and manage emails faster using Gemini inside Gmail.
Turn notes into structured messages, respond using thread context, and summarize long conversations. Focus on communication, not formatting, while keeping emails clear and professional.


Generate, improve, and structure documents faster using Gemini inside Google Docs. Rewrite messy content, summarize long text, and adjust tone and structure for professional results. Focus on clarity and readability while reducing manual writing and editing.

Create tables, clean data, and build formulas faster using Gemini in Google Sheets. Analyze datasets, extract insights, and turn numbers into clear reports.
Focus on decisions and results instead of manual data work.

Generate slide content, convert existing text into slides, and simplify presentation content using Gemini in Google Slides. 

Capture conversations, summarize meetings, and extract action items using Gemini in Google Meet. Turn discussions into clear notes, tasks, and follow-ups without manual note-taking. Focus on participation during meetings while Gemini handles documentation and next steps.

Find files, ask questions, and extract key information using Gemini in Google Drive. Compare documents, summarize content, and combine insights from multiple sources. Focus on getting answers and building clear outputs instead of searching through files.

Cleaning and Formatting Data

Situation