SnipTray logo
Data

Turn a CSV into something useful

Understand the shape before transforming it.

  • csv
  • transformation
  • exploration

The prompt

Here are the first lines of a CSV:

{{header}}

I want: {{want}}

Start by telling me what each column appears to be and which ones you are unsure
about. Then give the transformation — SQL, a script, or spreadsheet formulas,
whichever is shortest for this job.

Flag anything in the sample that suggests the file is messier than it looks.

What to fill in

{{header}}
Header row and two examples — e.g. Paste three lines
{{want}}
What you want out — e.g. one row per user with their plan and last activity

117 prompts, in the app you already paste from

The whole library, searchable, with your own prompts alongside it. Free to browse here; Pro to keep them a keystroke away on every device.