Spreadsheets boring? Not at all! Google has recently given Sheets a significant boost with smart AI features and handy upgrades. Whether you navigate through gigantic datasets daily or simply try to keep track of your holiday budget: Sheets works faster, more intuitively, looks better, and can again import more intelligently from Excel (with tables and linked pivot tables, including formatting and filters). Sheets now retains the linking structure and formatting, so your data continues to work directly.
AI as your personal spreadsheet wizard
With the deeper integration of Gemini, Google Sheets is getting a significant (artificial) intelligence injection.
1. From table to Kanban board with Ask Gemini
Do you have a long list of tasks, projects, or leads in a table? From now on, you no longer have to desperately scroll through them. Using the Ask Gemini sidebar (or Sheets Canvas), you can ask in plain language to convert your data into a visual Kanban board or interactive overviews. With a single command, you can transform a boring data dump into a clear board with cards and buttons based on status or category.
2. Magically fill data with Fill with Gemini
Manually retyping or categorizing data is so 2025. With Fill with Gemini Sheets immediately understands what you mean. Fill one cell as an example, drag the block down (drag-and-drop), or give a short prompt, and Gemini automatically fills the rest of the column. Whether it's categorizing customer feedback, summarizing product descriptions, or retrieving data: data entry is up to 9 times faster! (Users with AI Expanded Access licenses have higher limits on the use of Fill with Gemini.)
3. No more formula panic: fix errors in one click
Anyone who works with formulas knows the feeling: suddenly there's a red #VALUE!, #REF! or #N/A in your cell. Where you used to spend minutes searching for that one missing bracket or incorrect cell reference, Gemini now comes to your aid. With one click, the Gemini Formula Fixer analyzes the error, explains in clear language what went wrong, and immediately gives you the corrected formula to apply directly.
Visualizations that pop off your screen
Presenting data becomes a lot more attractive with the latest chart updates.
-
3D bar charts: No more "flat" data when you import files! Sheets now fully supports importing 3D bar charts (e.g., from Microsoft Excel), preserving the depth effect and visualization nicely.
-
Combo charts: Do you want to compare revenue and margin at a glance? With combo charts, you can effortlessly mix bar charts and line graphs in one clear overview.
-
Scatter charts: Perfect for detecting correlations and patterns between different variables. Gemini now even helps you quickly set up scatter charts based on your source data.
Connected sheets for data pros
For people who regularly switch between different systems or work with large databases, a few very nice quality-of-life improvements have been implemented. Do you work with enormously large datasets in BigQuery via Connected Sheets? Then you'll love these two improved features!
- List parameters: You can now link a cell range in your sheet (like a dropdown list) to a query. Users can filter in huge datasets via a dropdown without having to know a single line of SQL themselves.
- Column aliasing: Database names are often cryptic (usr_stat_cd_2026_v2). With column aliasing, you give columns a clean, understandable name (like "User Status") in the Sheets interface, while the underlying database link remains intact.
Conclusion: time to experiment!
