Real Agent Cases

Merge provider price CSVs into one comparison table with Claude Code

Posted
by Solace Gao (@S0laceGao)
Last checked
Method:
How we verify

Evidence: Described by posterThe person describes what happened in words, without screenshots or video.

Outcome

Claude Code read several local CSVs of model prices from different providers and produced one organized comparison table grouped by provider.

Agent

Claude Code

Prompt Recreated prompt

The source didn't share its exact prompt, so we wrote this from what it describes.

Here's a task I'd like your help with. Read it all the way through before you start.

Goal: Combine several CSV files of model prices from different providers into one table I can compare.

Check with me first: How should the table be grouped, by provider or by model?

What I'll give you:
- The CSV files

Rules:
- Read the files and put related models into one new table, labeled by provider.
- If something is missing or unclear, ask me instead of guessing.
- Don't change the original files.

Output: One organized comparison table, grouped by provider.

You'll know it worked when: I can compare prices across providers in one place.

Try this in:

ChatGPT Gemini Grok

Sends the Recreated prompt shown above. ChatGPT and Grok open with it filled in, and ChatGPT may send it straight away. Gemini opens empty, so we copy the prompt for you to paste. Every button also copies it.

The source used Claude Code, which can take actions on your computer or in a browser. These are general chat tools, so results may differ, and a normal chat may only give you a plan.

Opens in a new tab. We don't see what you send.

These links are only a shortcut. We're not affiliated with OpenAI, Google or xAI, and your results may not match the source.

Optional stronger version

Our rewrite with extra checks. The poster didn't test it.

Here's a task I'd like your help with. Read it all the way through before you start.

Goal: Combine provider price CSVs into one comparison table.

Quick check first: tell me if anything below is missing or unclear.

Inputs (fill in or confirm):
- CSV files
- Grouping (provider or model)
- Units to normalize to
- Currency and whether to include free tiers

Rules:
- Normalize prices to the same unit.
- Match equivalent models across providers.
- Keep source file references.
- Mark missing data.
- Convert all prices to per-million-tokens (input and output separately) unless I choose another unit.
- Show context window and any batch or cache discounts in their own columns.
- Keep the CSV row each value came from so it can be traced.
- Sort models by provider, then price.
- Note the date of each price source.

If you get stuck: If columns differ, map them and note it. If a login, CAPTCHA or two-step code appears, stop and ask me to handle it; never guess or store passwords.

Verify before you finish: Spot-check five prices against sources.

Output: One table plus notes.

Done when: I can compare prices in one view.

Source

https://x.com/S0laceGao/status/2036850598855766030

Related cases

  • Compare prices for 60–70 garden plants across 5 sites with OpenAI OperatorRecreated promptEvidence: Screenshots or logs

    Overnight, Operator cross-referenced a list of 60–70 plants across 5 sites into a price comparison table; the poster called it buggy but fun.

    OpenAI Operator · Shopping · Source date:

  • Graph monthly traffic deaths for two states with GrokRecreated promptEvidence: Screenshots or logs

    The poster says he asked Grok to graph Iowa traffic deaths per month for the last five years, then California, to check whether a roadside death counter looked low; he shared the charts.

    Grok · Data · Source date:

  • Check a hotel price with ChatGPT agent (wrong town)Improved promptEvidence: Described by posterFailure

    Asked to check a hotel's price with its town clearly stated, ChatGPT agent looked up a same-named hotel in another town, and the poster notes this wouldn't have been obvious from the reply.

    ChatGPT agent · Travel · Source date: