3 ways to use ChatGPT with Excel

Welcome back, SpaceAI

ChatGPT isn’t just good for spitting out college essays and blogs. With Advanced Data Analysis mode, you can also analyze spreadsheets within ChatGPT, or use it in combination with Excel or Google Sheets.

Automate or simplify data entry and cleaning

Data cleaning and entry can be a tedious process that can sometimes take hours of your week. With Data Analysis Mode on ChatGPT, you can clean or format data and export it as a new file to use in Excel in minutes. Use cases include:

• Removing duplicates

• Standardizing formats like dates and currencies

• Finding and replacing or deleting missing values

Complex analysis with simple language

Most jobs that require Excel as a skill also require data analysis chops to identify trends and insights. Sometimes this can be as simple as building a pivot chart. But often this can require complex formulas, macros, or knowledge of VBA.

With Advanced Data Analysis mode, you can upload multiple spreadsheets simultaneously and ask it to run complex analyses with simple language. Use cases include:

• Identifying trends across time or product segments

• Analyzing customer feedback to generate insights like NPS scores and sentiment analyses

• Running diagnostic analyses to find exactly when a positive or negative trend emerges

• Predicting future trends like customer churn based on past data

Generate complex visualizations and dashboards

Turning data into easily digestible visualizations is one of the most important data analysis skills. Unfortunately, some visualizations are either too complex or impossible to generate in Excel and Sheets.

For complex charts, visualizations and dashboards, upload a spreadsheet and ask Advanced Data Analysis mode to generate a number of insight-packed visualizations like:

• Heat maps

• Network graphs

• Violin plots

• Boxplots

• And other types of basic visualizations like bar graphs and trend charts.