Skills Guide

CSV URL Parser

VerifiedSafe

Parses URLs from CSV files, extracts query parameters, and adds them as new columns. Useful when analyzing URL data in spreadsheets, such as web analytics or tracking links.

Download and use
Sby Skills Guide Bot
Data & AIBeginner
6/2/2026
Claude Code
#csv#url-parsing#data-extraction#query-parameters

Recommended for

Claude CodeData scientistData & analysis

Automated summary

Parses query parameters from URLs in a CSV file and adds them as new columns.

Strengths

  • Automates extraction of URL parameters without manual coding.
  • Handles multiple values by joining them with '|'.
  • Preserves original data by appending new columns.

Limitations

  • Requires the URL column to be named 'url' or 'URL'.
  • Only works with CSV files that have headers.
  • Malformed URLs are silently ignored.
When to use it

Use this skill when you have a CSV file containing URLs and need to extract and analyze their query parameters.

When not to use it

Do not use it if the URLs are in a non-standard format or if you need more complex data transformations.

Security analysis

Safe
Quality score85/100

The skill uses a Ruby script to parse URLs in local CSV files, with no network activity or destructive actions. It only reads, writes, and processes CSV data. The use of Bash with file arguments could potentially be exploited if filenames are malicious, but the skill does not instruct unsafe execution.

No concerns found

How this analysis is made

Examples

Process all CSV files
Parse URLs in my CSV files
Process specific file
Extract URL parameters from data.csv
Analyze URL parameters
Show me what parameters are in the URLs from this CSV

name: csv-url-parser description: Parse URLs in CSV files and extract query parameters as new columns. Use when working with CSV files containing URLs that need parameter extraction and analysis. allowed-tools: Read, Write, Bash, Glob

CSV URL Parser

This skill extracts query parameters from URLs in CSV files and adds them as new columns.

Instructions

  1. Identify CSV files: Look for CSV files in the current directory or specified path
  2. Analyze URL column: Find the column containing URLs (looks for 'url' or 'URL' headers)
  3. Extract parameters: Parse all query parameters from URLs
  4. Create new columns: Add parameter names as new column headers
  5. Process data: Fill new columns with parameter values (multiple values joined with '|')
  6. Save results: Update the CSV file with new columns

Implementation

The skill uses Ruby to process CSV files. Run the processing script:

ruby scripts/process_csv.rb [file1.csv file2.csv ...]

If no files are specified, it processes all CSV files in the current directory.

The script will:

  • Read CSV files with headers
  • Extract query parameters from URLs using URI parsing
  • Handle multiple values for the same parameter (joined with '|')
  • Preserve original data while adding new parameter columns
  • Handle malformed URLs gracefully

For detailed examples, see EXAMPLES.md.

Usage Examples

Process all CSV files in current directory:

Parse URLs in my CSV files

Process specific CSV file:

Extract URL parameters from data.csv

Analyze URL parameters:

Show me what parameters are in the URLs from this CSV

Requirements

  • Ruby with standard libraries (CSV, URI, CGI)
  • CSV files must have headers
  • URL column should be named 'url' or 'URL'

Output

  • Original CSV file updated with new parameter columns
  • Multiple parameter values separated by '|'
  • Preserves all original data
  • Handles empty/missing parameters gracefully

From the file to a first result

The download contains exactly the content displayed on this page. This copy may differ from the latest version in the source repository.

View the source and supporting files

This download contains SKILL.md only. Any scripts, references, templates and dependencies are not included. Get the required files from the source, preserving their directory structure, before continuing.

1. Download the file

Download SKILL.md

From the root of a test project, save the file as .skill-downloads/csv-url-parser-mmlj2osc/SKILL.md, or use the command below. This folder is for inspecting the skill before installation.

Command for macOS/Linux or WSL: requires a POSIX shell and curl. On Windows without WSL, use the download button and create the folder manually.

mkdir -p '.skill-downloads/csv-url-parser-mmlj2osc' && curl --fail --show-error --location 'https://skills-guides.com/api/skills/csv-url-parser-mmlj2osc/download' --output '.skill-downloads/csv-url-parser-mmlj2osc/SKILL.md.part' && mv '.skill-downloads/csv-url-parser-mmlj2osc/SKILL.md.part' '.skill-downloads/csv-url-parser-mmlj2osc/SKILL.md'

2. Check prerequisites

Read SKILL.md before using it. If it references scripts or external services, inspect them and prepare the required access in your test environment.

Tools declared by the author (check availability in your agent): Read, Write, Bash, Glob

Original excerpt: Requirements
  • Ruby with standard libraries (CSV, URI, CGI)
  • CSV files must have headers
  • URL column should be named 'url' or 'URL'

The platforms on this page are catalog indications. The paths below follow tool documentation; they do not prove this skill has been run in those tools. No minimum tool version is confirmed for this listing.

3. Load the skill

After inspection, copy the complete folder into your project using one of the commands below, then open a new tool session. The command stops if a folder with the same name already exists: compare the files before replacing it.

Claude Code
test -f '.skill-downloads/csv-url-parser-mmlj2osc/SKILL.md' && test -s '.skill-downloads/csv-url-parser-mmlj2osc/SKILL.md' && mkdir -p '.claude/skills' && test ! -e '.claude/skills/csv-url-parser' && cp -R '.skill-downloads/csv-url-parser-mmlj2osc' '.claude/skills/csv-url-parser'

OpenSkills

OpenSkills must already be installed. The local install/read procedure is checked with OpenSkills 1.5.0, which requires Node.js ≥ 20.6.0. Catalog slugs are not resolved automatically.

Official OpenSkills installation
openskills install './.skill-downloads/csv-url-parser-mmlj2osc'

openskills read 'csv-url-parser-mmlj2osc'

Reading should display the installed file content and its base directory. It does not run the skill or install its dependencies.

For an agent that reads AGENTS.md, then sync the index. This command changes AGENTS.md: review the diff before using it.

openskills sync

Manual method or another tool: attach SKILL.md to a conversation, or open it in an agent that can read files. Include any required supporting resources. No universal folder is recognized by every tool.

4. Try a first task

Use a short, synthetic input: an API endpoint, a small document or an interface brief. In a new conversation, attach the file or give the agent its path, then adapt this request:

Read .skill-downloads/csv-url-parser-mmlj2osc/SKILL.md and apply its instructions to this example: [describe a test input]. Identify any missing files, dependencies or access. Produce the result requested by the skill without inventing data or running unreviewed scripts.

Expected result: output matching the skill instructions, or a precise list of missing prerequisites. A read confirmation alone does not validate a first use. If an external resource is unavailable, that path remains untested.

Related skills

Create Interactive Maps with kepler.gl

Data & AI

Create interactive map visualizations and export standalone HTML using the keplergl Python package. Use to plot geospatial data from DataFrames, GeoJSON, or CSV.

Claude CodeCursorCodexintermediateSafe 11,995
Skills Guide Bot

Agent-Driven Parameter Optimization

Data & AI

Guide for optimizing configurable systems with a measurable objective, using bounded trials and evidence-based recommendations.

Claude CodeCursorCodexintermediateSafe 45,609
Skills Guide Bot

ICP Visitor Outreach

Data & AI

Identify signed-up users matching the ideal customer profile but stalled, and draft personalized outreach to re-engage them.

Claude CodeintermediateSafe 6,843
Skills Guide Bot