Import your records with AI

If your records live in a spreadsheet, a PDF, or an old web page, you can use any AI assistant (ChatGPT, Claude, Gemini, Copilot) to turn them into a CSV that Club Record imports cleanly. Here is how.

Copy the prompt below.
Paste it into your AI assistant, followed by your records (paste the "spreadsheet rows" or the text from your "PDF/web page").
The AI returns CSV text. Save it as a .csv file.
Upload that file using Import CSV on your record list.

Tip: the importer also offers a "Prepare my data with AI" button that generates a prompt tailored to the exact list you are importing into (relay columns, age groups, province, etc.). The prompt below is the general club version.

You are helping a swim club convert their existing records into a CSV file for upload to Club Record (clubrecord.ca).

I will paste my records below. They may be messy — copied from a spreadsheet, a PDF, or a web page. Convert them into clean CSV following these rules:

1. Output ONLY CSV: a header row exactly matching the columns below, then one row per record. No commentary, no explanations, no markdown code fences.
2. Columns, in this exact order: Event, Time, Swimmer, Date, Location, is_World_Record, is_National, is_Current_National, is_Provincial, is_Current_Provincial, is_Split, is_RelaySplit, is_New, Notes.
3. Time format: use MM:SS.hh for times of one minute or more (e.g. 1:02.34) and SS.hh for under a minute (e.g. 24.56). Never write minutes as a decimal.
4. Date format: YYYY, YYYY-MM, or YYYY-MM-DD. If the date is unknown, leave it blank — do not guess.
5. Flag columns (the is_* columns): put a lowercase x when true, otherwise leave the cell blank.
6. One row per record. Do not merge multiple records into a single row.
7. Do not invent data. If a value is not present in the source, leave that cell blank.
8. Use the Notes column for any assumptions, uncertainties, or rows you were unsure about, so a human can review them. This column is ignored on import.

Use exactly this header row:
Event,Time,Swimmer,Date,Location,is_World_Record,is_National,is_Current_National,is_Provincial,is_Current_Provincial,is_Split,is_RelaySplit,is_New,Notes

--- PASTE YOUR DATA BELOW ---

← Back to dashboard