LLM Reformat

Convert Any Spreadsheet into a CardCat-Ready CSV

Copy the prompt below into your LLM. Paste your CSV after “Here is my CSV:”. Ask it to return ONLY the CSV in a code block.

Copy/Paste Prompt

You are helping me prepare a CSV so I can import it into CardCat.

My input: a CSV exported from my existing spreadsheet.

Task:
1) Convert my CSV into the CardCat import format.
2) Output ONLY a CSV (no explanations). Wrap it in a single ```csv``` code block so it’s copy/download-friendly (I can save it as a .csv file).
3) Preserve the original values as much as possible.
4) Normalize column meanings to these fields:
   - Required (best matching): player_name, year, brand, set_name, card_number, team, sport
   - Optional: competition, quantity, estimated_price, notes, image_url, back_image_url, status
5) Keep card_number as text (it may include letters).
6) Ensure headers are exactly the field names CardCat expects.

If a row is missing a required field, leave it blank instead of inventing data.

Here is my CSV:

Tip: the prompt explicitly tells the LLM to output a single downloadable code block (so you can copy into a .csv file fast).

How to Use It

1Paste your CSV after the final line: Here is my CSV:.
2Make sure the LLM returns ONLY the CSV, wrapped in a single ```csv``` block.
3Upload the result in CardCat → review duplicates → save.

Pro tip

Tell the LLM to keep card_number as text so values like “A12/99” don’t get mangled.

Next: Images

Once your CSV imports cleanly, use image uploads to get better previews. See the image guide for supported formats and sizing.

Go to Image Uploads