What are Data Chats?
Data Chats utilize OpenAI's code interpreter to enable in-depth interactions across one or multiple spreadsheets
Data Chats can talk to the data in .xlsx and CSV files, similar to building formulas in Excel to get results
Can I use Data Chats to "talk" to multiple spreadsheet files simultaneously?
Yes, when you create a new Data Chat, you can select multiple spreadsheets from your files
Can I generate charts with Data Chats?
Yes, to generate a chart, start by creating a Data Chat with the spreadsheet(s) you'd like to use as a source. Then, use the prompt "Create a [chart name] based on the data I uploaded."
After producing the chart, you can also clean and format data by prompting it to remove duplicates and missing values
What charts can I create with Data Chats?
Stacked Bar Chart, Area Chart, Correlation Chart, Heat Map, Line Chart, Bar Chart, Dendrogram, Histogram, Venn Diagram, Box Plot, Radar Chart, Parallel Coordinates Plot, Violin Plot, and Steamgraph.
How do you export table response data from Data Chats?
Any time a table is formulated as part of a response in data chats, you will see a black download button in the top right corner of the table
The export will appear in your browser's Downloaded Files list when you click the download button
How do I export a Data Chat?
Navigate to Data Chats in the Deal menu and select the box with the three dots to the right of the Data Chat name.
Select the Export format. Each format will export the Data Chat Q&A (the Excel format will also include additional meta-data, Deal Name, Chat, etc.)
You can also export Data Chats from the Exports page located in the Deal menu.
The document will appear in the Download Files list for your browser.
What is the purple/pink </> button in the top right corner of the Data Chat response?
Use the </> button to View the Source Code. In a Data Chat, OpenAI's code interpreter uses the spreadsheet files as the source and dynamically writes Python code based on the question asked.
The </> button will allow you to view and analyze the dynamic Python code created by the system.
Data Chats are somewhat of a "black box," so sometimes the dynamic Python code is not shown.
What is the maximum number of cells I can have in my Data Chat Excel or CSV file?
In Data Chats, we can support files with up to 2 million cells populated with values.
These cells include any cells with numbers or text
For example, a spreadsheet with 2 columns can have a maximum of 1 million rows, and a spreadsheet with 2,000 columns can have a maximum of 1,000 rows.
Is there a limit of documents you can upload to Data Chat?
Yes, we can load a maximum of 20 files to Data Chats.