> ## Documentation Index
> Fetch the complete documentation index at: https://academy.pathfindr.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Additional: ChatGPT in Spreadsheet

> A guide to using ChatGPT in spreadsheet.

## Spreadsheets in ChatGPT

ChatGPT can read, analyse, and visualise data directly from uploaded spreadsheets. When you upload a file, it creates an interactive table view where you can scroll through data, click on specific values, and ask ChatGPT to explain patterns or run calculations.

<Frame>
  <img src="https://mintcdn.com/pathfindr/vxED2dxssEHZg3yn/images/spreadsheetsInChatgpt.webp?fit=max&auto=format&n=vxED2dxssEHZg3yn&q=85&s=b87b23792b4b6b569d5bfa051a2ce9ae" alt="Spreadsheets In Chatgpt Pn" width="1280" height="682" data-path="images/spreadsheetsInChatgpt.webp" />
</Frame>

### Data analysis and visualisation

ChatGPT handles data exploration, cleaning, and analysis. It reads your columns and rows, interprets what each field represents, and can perform statistical tests and generate forecasts. It also creates interactive charts like histograms and scatter plots.

<Frame>
  <img src="https://mintcdn.com/pathfindr/0Og7YOK8gX91P7mj/images/dataAnalysisCharts.webp?fit=max&auto=format&n=0Og7YOK8gX91P7mj&q=85&s=b3c25865174efa72c5fe1f886eb08f61" alt="Data Analysis Charts Pn" width="1920" height="536" data-path="images/dataAnalysisCharts.webp" />
</Frame>

### Best practices for spreadsheets

<AccordionGroup>
  <Accordion title="Descriptive labels">
    Use clear headings, not acronyms or jargon. ChatGPT interprets your column names to understand your data.
  </Accordion>

  <Accordion title="Simple data">
    One table per sheet. Remove empty rows and columns. If using heavy formulas, providing a CSV or raw data file can help.
  </Accordion>

  <Accordion title="Model choice">
    Use GPT-5 Thinking or GPT-5 Pro for complex analysis that involves Python or coding.
  </Accordion>

  <Accordion title="File uploads">
    Upload the spreadsheet directly. This tends to be more reliable than using Company Knowledge for data retrieval.
  </Accordion>

  <Accordion title="Split prompts">
    For complex work, prompt one step at a time following the same order you would use manually.
  </Accordion>
</AccordionGroup>

<Note>
  Keep in mind that the Pro model does not support the interactive data view. Use the Thinking mode if you need to explore data visually.
</Note>