AI Tool Atlas
Writing Editorial example

WeTransform prompt for mapping a customer’s messy spreadsheet to your schema

An editorial example for mapping a customer's messy spreadsheet to your schema in WeTransform, written for our guide and not tested against the vendor

Source
AI Tool Atlas guide: WeTransform
Checked
Oct 1, 2026

The prompt

Editorial example from our guide
Treat 'N/A' and blank cells in the price column as null and convert dates to ISO format.
How to use this prompt: fill the variables, run it in any chat assistant, check the resultYOU FILL INReady to runPaste the prompt as isNo variables to replaceTHE PROMPTany chat assistant18 words · 1 linesource: editorial exampleYOU GETThe resultAn editorial example for mapping…check the result against the tipsfill → run → check · prompts are copied word for word from their source
How to use this prompt: what to fill in, where to run it, what comes back

How to check the result

  • Compare row counts before and after
  • Spot-check mapped values against the source file

This prompt was written as an example for our guide and has not been run against the tool. Expect to adapt it to your case. How we document tools.

More writing prompts