Sanitize dynamic dataset fields for clean landing page URLs

Clean messy raw spreadsheet strings into uniform, URL-safe slugs that prevent routing collisions across scaled directories.

Prompt

Prompt
Act as a database engineer and technical SEO specialist. Clean and standardize the raw text records provided below to create pristine, collision-free URL slugs and page metadata.

Rules:
- Strip special characters, accents, trailing spaces, and punctuation.
- Convert all slug values to lowercase, using single hyphens as delimiters.
- Identify and explicitly flag duplicate slugs that would cause 404 or canonical conflicts.
- Generate a clean display title and meta description stub for each entry.

Output format:
A Markdown table with columns:
Original Raw Value | Clean URL Slug | Formatted Display Name | Collision Risk (None, Low, High)

Follow the table with a bulleted list of flagged collision risks and recommended deduplication rules.

My raw data is below:

Example output

Example for: raw business directory categories and city names

Original Raw ValueClean URL SlugFormatted Display NameCollision Risk (None, Low, High)
Austin, TX - Downtown!austin-tx-downtownAustin, TX - DowntownNone
Austin - Downtown (TX)austin-tx-downtownAustin, Downtown, TXHigh
St. Paul / Minneapolisst-paul-minneapolisSt. Paul / MinneapolisNone
Saint Paul & Minneapolissaint-paul-minneapolisSaint Paul & MinneapolisLow
Bogotá, D.C. // Colombiabogota-dc-colombiaBogotá, D.C., ColombiaNone
New York, NY [Midtown]new-york-ny-midtownNew York, NY (Midtown)None
Collision Risks and Deduplication Rules
  • austin-tx-downtown: Two entries produced the identical slug due to differing punctuation around state abbreviations. Recommendation: append the municipal zip code or standardize state formatting prior to slug generation.
  • saint-paul-minneapolis vs st-paul-minneapolis: These represent the same geographic entity with different spelling conventions. Recommendation: apply an abbreviation normalization dictionary before running the slug generator.
Written by AI from this prompt. Your results will vary.

Paste your list or spreadsheet columns directly under the prompt in ChatGPT, Claude, or Gemini. If you have thousands of rows, paste a sample batch of 20 to 50 entries to establish the formatting rules first.

Make it repeatable

Keep using this prompt without pasting it in every time.

Keep exploring

More in SEO