# Prepare a big spreadsheet with AI

Most spreadsheets import as they are. A sheet kept for years often has its own system. The AI chat you already use can rewrite it for tracklog. Copy the prompt below and attach your sheet. Then check how the AI read it.

## Do you need this?

Try the import first. It reads most sheets on its own. See [Import a spreadsheet](../import-a-spreadsheet/).

Use the prompt when your sheet has its own system, like one of these:

- **The status is only a colour.** A green cell means live, a red one means rejected. A CSV file has no colours.
- **One sheet for each platform.** A Pond5 sheet, an AudioJungle sheet. The same track is on several of them.
- **One row for each upload.** Date, track, platform, status. A track takes many rows.
- **One row for each version.** Main, 60s, 30s, Loop, each on its own row.
- **Notes inside titles.** `Sunrise (REJECT pond5)`, `Lofi 3 (old name: Chill Beat)`.
- **Headings and totals between the tracks.** `— 2019 —`, `LOGOS`, a total at the bottom.

## What you need

- **The AI chat you work in:** ChatGPT, Claude, Gemini or another. It needs to read a file you attach.
- **Your spreadsheet as an Excel file (.xlsx).** In Google Sheets: **File → Download → Microsoft Excel**. An Excel file keeps the colours and every sheet. A CSV file keeps only one sheet and no colours.
- **Only your catalog in the file.** Delete sheets with private things first: bank details, contacts, passwords.

## The prompt

{{prompt}}

## Step by step

1. Press **Copy the prompt** above.
2. Open a new chat. Paste the prompt. Attach your .xlsx file. Send.
3. Write in your own language. It asks and answers in the language you write in.
4. It tells you how it read your sheet, point by point. Under each point it gives another way to read it. If everything is right, reply `ok`. If not, write what is different in your own words, like "yellow means rejected".
5. It gives you a file named `tracklog-import.csv` and a short report. The report says which rows it left out and why. Read it.
6. In tracklog, open **Settings → Import & export** and click **Import tracks…**. Choose `tracklog-import.csv`.
7. Look at the import window. It shows what each column becomes. Click **Import**.

> **Nothing is saved until you press Import.** Your catalog is backed up before the import. Undoing an import removes only what that import added. See [Undo](../undo/).


## Your data

Your spreadsheet goes to the company that runs your AI chat. tracklog does not see it. If you don't want your sheet used to train their models, turn that off in the chat's settings first. In ChatGPT: **Settings → Data controls → Improve the model for everyone**.

#### It says it can't open my file.
Try another AI chat. Or paste the table as text when it asks, in parts of about 100 rows.

#### Some tracks are missing after the import.
Read the report first. It names every row it left out: headings, totals, empty rows. If a real track is missing, tell it in the same chat: "Track X is missing, put it back". Then download the new file.

#### My colours came out wrong.
Check that you attached the .xlsx file, not a CSV. Then tell it in the same chat what each colour means, for example "green is live, yellow is pending". It makes the file again.

#### I don't understand one of its points.
Ask it in the same chat, in your own words. Or reply `ok`. After the import you can fix any track with the paint brush, or undo the whole import and try again.

#### Can I import again after fixing the sheet?
Yes. Undo the first import, then import the new file. Or import it over the first one and choose **Fill in the blanks**: it adds only what is missing.
