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.
About this tool
Break URL columns in a Excel file into their component parts — protocol, host, path, query parameters, and fragment — each in its own column. Useful for analysing web server logs, marketing URL reports, and CRM exports that contain raw URLs. Individual query parameters like utm_source and utm_campaign are extracted as separate columns. Everything runs locally in your browser.
Frequently Asked Questions
What parts of a URL does the Excel URL parser extract?
Protocol (scheme), host (domain), port, path, query string, individual query parameters as separate columns, and fragment. Each component is extracted into its own column in the output file.
Why would I need to parse URLs in a Excel file?
Common uses include extracting UTM parameters from marketing URLs, isolating hostnames for domain analysis, splitting path segments for web analytics, and cleaning URL columns before loading into a database. Web server logs, analytics exports, and CRM data often contain raw URL columns that need decomposing.
What happens to malformed URLs in a Excel file during parsing?
Rows with values that cannot be parsed as a valid URL will have NULL in all extracted component columns. The original URL column is preserved so you can identify and fix malformed entries separately.
Is my data private?
Yes — completely. Your file is never uploaded to any server. Everything runs locally in your browser using WebAssembly — processing happens entirely inside your tab. Once you close the tab, nothing is retained.
What is the maximum file size?
The free limit is 50 MB. For larger files, performance depends on your device's available memory — most modern machines handle 500 MB to 1 GB comfortably.
Related Tools
Group Concatenate Excel Files Online
Concatenate text values within each group in Excel files directly in your browser. Group rows by a column and join the values of another column into a single delimited string — no upload required.
Truncate Dates in Excel Files Online
Truncate date and timestamp columns in Excel files to a chosen precision — year, quarter, month, week, day, hour, or minute — directly in your browser. Rounds timestamps down to the start of each period. No upload required.
Coalesce Columns in Excel Files Online
Fill null values in Excel files from other columns — return the first non-null value across up to 8 columns in priority order. Add the result as a new column. Runs entirely in your browser.
Add UUID Column to Excel Files Online
Add a UUID column to Excel files directly in your browser. Generate random UUIDv4 or time-ordered UUIDv7 identifiers for every row. Choose the column name and position — no upload required.
Pad Column in Excel Files Online
Left-pad or right-pad a column in Excel files to a fixed width directly in your browser. Zero-pad numeric codes, pad product IDs to a fixed length, or right-pad text fields — no upload required.