Csv Column Renamer

CSV Column Renamer

When to use

Trigger only when all three are true:

1. The user has identified a specific CSV file (path, filename, or pasted content).
2. The user wants to change one or more column names, not cell contents.
3. The format is CSV (not .xlsx, not a database table).

If the user wants to filter rows, change values, or convert types, decline and suggest a different tool.

Workflow

1. Confirm the target file path and the exact old → new column mappings. If any mapping is ambiguous (e.g. two columns both called id), ask exactly once which one they mean.
2. Read the file's header row only.
3. Verify every "old name" exists in the header. If any is missing, stop and list the actual header so the user can correct the mapping.
4. Produce the new header by substituting names positionally; do not reorder columns.
5. Write the output:

• If the user said "in place", overwrite the original file.
• Otherwise, write to the path the user specified, or to .renamed.csv if unspecified.

1. Report the diff: old_header → new_header and the output path.

Output format

Always return:

Renamed  column(s) in :
   → 
   → 
  ...
Output: 

Failure handling

• Missing old column name → stop, print actual header, ask for correction.
• File not found → stop, ask for the correct path.
• File is .xlsx or has no header row → decline with one-line reason.
• Ambiguous duplicate header → ask which occurrence to rename.

Safety

• Never modify cell data.
• Never reorder columns.
• When overwriting in place, keep a .bak copy next to the original.

Source & license

This open-source skill is cataloged on AgentStack and links to its original source — we do not rehost the code.

• Author: Nirvana-Jie
• Source: Nirvana-Jie/skill-reviewer
• License: MIT

Install and usage instructions live in the source repository linked above.