How many times did you leave the spreadsheet in the middle of an analysis, search for data online, and manually copy it back?
The work with the AI has also been expanded to search for up-to-date information on the web and use it as part of the work on the sheet.
Suppose you are analyzing a company and want to compare its data with up-to-date industry information. Instead of leaving the file, conducting a search, and copying the data back, you can ask ChatGPT to locate the information and use it in the analysis.
Sample prompt:
"Search for up-to-date data on growth rates in the industry in which the company operates, cite the sources, and compare them to the data in the table. Do not update the file before you present the information you found."
Before relying on data found online, open the source, verify that it is updated for the period you are comparing, and that it is suitable for the analysis you are performing.
The option is available in the official ChatGPT add-in for Excel and Google Sheets, which is currently also available to free plan users subject to usage limits.
Have you already connected ChatGPT to your spreadsheet? Tell us about one analysis where it saved you time.
