Introduction

In Module 3, we act as Data Analysts. AI is incredibly smart, but it struggles with "messy" Excel files that have merged cells and colors. We need to feed it clean, raw text. The standard format for this is .CSV (Comma Separated Values).

_____________________________________________________________________

Option A: Using Google Sheets (Free & Recommended)

  1. Go to sheets.google.com and log in.

  2. Open a Blank sheet.

  3. Type some dummy data to test (Row 1: Name, Role. Row 2: Thabo, Manager).

  4. To Export for AI:

    • Click File (Top left).

    • Hover over Download.

    • Select Comma Separated Values (.csv).

    • The file will download to your computer. This is the file you will upload to ChatGPT.

____________________________________________________________________

Option B: Using Microsoft Excel

  1. Open Excel on your desktop.

  2. Ensure your data is "Flat" (No merged cells, no fancy formatting, just rows and columns).

  3. To Export:

    • Click File > Save As.

    • In the file format dropdown menu, scroll down and select CSV (Comma delimited) (*.csv).

    • Warning: Do not choose "CSV Macintosh" or "CSV MS-DOS" unless you are on those specific systems. Standard CSV is best.

    • Click Save.