ChatGPT review

ChatGPT is the easiest place to start if your data lives in a spreadsheet you can upload. OpenAI's help center says ChatGPT can summarize rows, columns, trends and outliers, create tables and charts, and run Python-based calculations, transformations and statistical analysis. For many tasks it writes and runs Python in a stateful Jupyter notebook environment and can display pandas DataFrames as interactive tables, and you can review the generated code before relying on a result. Supported inputs include .xls, .xlsx and .csv files, PDFs and common text formats, plus files from Google Drive, OneDrive and SharePoint when plugins are available. The main limits are that the analysis environment cannot make external web requests or API calls and that it works on files rather than governed warehouse metrics. The pricing page showed local currency from our location, so the USD price is marked as pending.

Who it is for

individuals who analyze one-off spreadsheets and already use ChatGPT

Price

Free plan; See vendor pricing (USD check pending).

US price check pending. See the vendor pricing page.

Key features

• Analyzes .xls, .xlsx and .csv spreadsheets, PDFs and JSON, XML, YAML, TXT and MD files
• Writes and runs Python in a stateful Jupyter notebook environment for calculations and statistics
• Shows pandas DataFrames as interactive tables
• Interactive bar, line, pie and scatter charts
• Attaches files from Google Drive, OneDrive and SharePoint when plugins are available

Strengths and weaknesses

• Strength: Free plan includes limited messages with uploads
• Strength: Shows the generated Python so you can check the method
• Strength: Most people already know the chat interface
• Weakness: The Python environment cannot make external web requests or API calls
• Weakness: Works on uploaded or connected files rather than live warehouse tables
• Weakness: Price could not be confirmed in USD from our location

Key facts

• Free plan: Yes, with limited messages with uploads
• Spreadsheet formats: .xls, .xlsx and .csv
• Interactive charts: Bar, line, pie and scatter
• Analysis engine: Python in a stateful Jupyter environment

Where it ranks

ChatGPT is No. 2 in our Best AI Data Analysis Tools verdict.