Parse URL Column in YAML Files Online

Parse URL columns in YAML files and extract host, path, query string, and fragment into separate columns — directly in your browser, no upload required.

How to parse URL Column in YAML files

Drop your file onto the upload area. The tool picks the first text column whose name contains url, link, href or uri as the URL column.
Check the URL column. Only text columns are listed.
Choose which parts to extract: Host, Path, Query and Fragment. Host and Path are selected by default.
Optionally type an Output column prefix. By default new columns are named after the URL column, such as landing_url_host.
Click Parse URLs, check the preview, then download the file with the new columns added at the end.

Your file is processed locally in your browser and is never uploaded. The free limit is 50 MB per file; larger files work if your device has the memory for them.

Worked example

A marketing analyst has a sessions export with full landing page URLs and wants to report by site and page, and see which campaign tags were used.

Input (YAML)

- session_id: s-8841
  landing_url: https://www.example.com/pricing?utm_source=newsletter&utm_campaign=spring
  pageviews: 4
- session_id: s-8842
  landing_url: https://blog.example.com/2026/05/launch-notes?ref=twitter
  pageviews: 1
- session_id: s-8843
  landing_url: https://www.example.com/signup?ref=partner-17
  pageviews: 6
- session_id: s-8844
  landing_url: https://shop.example.co.uk/cart?step=2
  pageviews: 3

Settings

URL column: landing_url
Extract parts: Host, Path, Query
Output column prefix: (blank, uses landing_url_)

Result

session_id	landing_url	pageviews	landing_url_host	landing_url_path	landing_url_query
s-8841	https://www.example.com/pricing?utm_source=newsletter&utm_campaign=spring	4	www.example.com	/pricing	utm_source=newsletter&utm_campaign=spring
s-8842	https://blog.example.com/2026/05/launch-notes?ref=twitter	1	blog.example.com	/2026/05/launch-notes	ref=twitter
s-8843	https://www.example.com/signup?ref=partner-17	6	www.example.com	/signup	ref=partner-17
s-8844	https://shop.example.co.uk/cart?step=2	3	shop.example.co.uk	/cart	step=2

The original columns are kept and one column per selected part is appended, named with the prefix plus the part. The host keeps subdomains, so www.example.com and blog.example.com stay separate. The query is returned as one string. Individual parameters such as utm_campaign are not split into their own columns, so use Split Column on & and then on = if you need them.

Frequently Asked Questions

Which URL parts can the tool extract?

Host, path, query string and fragment. It does not split out the scheme, port or individual query parameters. Use Split Column or Regex Extract on the query column for single parameters such as utm_source.

How are the new columns named?

Prefix plus part name, for example landing_url_host. The default prefix is the URL column name followed by an underscore. Characters other than letters, digits and underscores in a custom prefix are replaced with underscores.

Is the original URL column changed?

No. The original column stays as it was, and the extracted parts are appended as new columns at the end.

Related Tools

Count Values in CSV Files Online

Group and count rows by any column in CSV files directly in your browser. Sort by frequency or value to find the most common entries — no upload required.

Split Column in CSV Files Online

Split a column into multiple columns by delimiter in CSV files directly in your browser. Turn "First Last" into separate first and last name columns — no upload required.

Aggregate CSV Files Online

Group and aggregate CSV files by any column directly in your browser. Calculate sum, average, min, max, and count for any numeric column — no upload required.

Parse URL Column in CSV Files Online

Parse URL columns in CSV files and extract host, path, query string, and fragment into separate columns — directly in your browser, no upload required.

Parse URL Column in Excel Files Online

Parse URL columns in Excel files and extract host, path, query string, and fragment into separate columns — directly in your browser, no upload required.

Parse URL Column in Parquet Files Online

Parse URL columns in Parquet files and extract host, path, query string, and fragment into separate columns — directly in your browser, no upload required.

Parse URL Column in JSON Files Online

Parse URL columns in JSON files and extract host, path, query string, and fragment into separate columns — directly in your browser, no upload required.

YAML Viewer Online

View and inspect YAML files directly in your browser. Browse rows, check column names and data types — no upload required, your data stays on your device.