Google Sheets gets a Gemini-powered upgrade to analyze data faster and create visuals – TechCrunch
Latest
AI
Amazon
Apps
Biotech & Health
Climate
Cloud Computing
Commerce
Crypto
Enterprise
EVs
Fintech
Fundraising
Gadgets
Gaming
Government & Policy
Hardware
Layoffs
Media & Entertainment
Meta
Microsoft
Privacy
Robotics
Security
Social
Space
Startups
TikTok
Transportation
Venture
Events
Startup Battlefield
StrictlyVC
Newsletters
Podcasts
Videos
Partner Content
TechCrunch Brand Studio
Crunchboard
Contact Us
Google is giving Sheets a Gemini-powered upgrade that is designed to help users analyze data faster and turn spreadsheets into charts using AI.With this update, users can access Gemini’s capabilities to generate insights from their data, such as correlations, trends, outliers, and more. Users now can also generate advanced visualizations, like heatmaps, that they can insert as static images over cells in spreadsheets.While the company announced the update last month, Google said on Friday that it’s now available to all Workspace business users.To get started, you need to click the Gemini icon on the top right-hand side of your spreadsheet. From there, you can ask things like “predict my net income for the next quarter based on historical data” or “create a simple heatmap of support cases by category and device.”Other examples include a marketing manager asking Gemini to “Provide some insights on my top 3 performing channels by conversion rate” or a financial analyst asking Gemini to “Identify any anomalies in inventory levels for Product X.”Gemini is able to do all this by creating and running Python code and then analyzing the results to perform multi-layered analysis, Google says. For simpler requests, Gemini might still provide answers using formulas instead of Python code.The company notes that data should be in a consistent format with clear headers and no missing values to allow for accurate results.Topics
Consumer News Reporter
Aisha is a consumer news reporter at TechCrunch. Prior to joining the publication in 2021, she was a telecom reporter at MobileSyrup. Aisha holds an honours bachelor’s degree from University of Toronto and a master’s degree in journalism from Western University. Mark Cuban offers to fund government tech unit that was cut in the middle of the night
Ben Horowitz donates Cybertruck fleet to the Las Vegas police
How to get rid of the new Apple Mail redesign
‘Uber for guns’ app Protector lets you hire armed body guards like you would an Uber — but does anyone need this?
Sergey Brin says RTO is key to Google winning the AGI race
Startup co-founded by longevity guru Peter Attia emerges from stealth
Bluesky-based Instagram alternative Flashes launches publicly
Subscribe for the industry’s biggest tech newsEvery weekday and Sunday, you can get the best of TechCrunch’s coverage.TechCrunch’s AI experts cover the latest news in the fast-moving field.Every Monday, gets you up to speed on the latest advances in aerospace.Startups are the core of TechCrunch, so get our best coverage delivered weekly.By submitting your email, you agree to our Terms and Privacy Notice.© 2024 Yahoo.
