Split a URL into columns – A little Google Sheets Trick! Get

The fast way to Split URL to Columns using Google Sheets.

Need to split URL into columns in Google Sheets? Let my business intelligence consulting experience speak through this – I know this can take a long time if you don’t read this!

Below we show how to split text into columns, how to automate getting coordinates and help you avoid this very boring task.

“Pick up a bean, put it in a bag, and then empty that bag in a pile over there. Now, start over.”

Here take this ax. You’re going to need it!

Split url to columns with this axe
Split URL to columns with this figurative ax. Watch your Fingers! We use Google Sheets because it’s a million times better than Excel.

This blog is the documentation built on our internal WIKI and cleaned up for consumption.

If you’re a technical expert, here’s all you need to know to split text to columns in google sheets.Split url to columns - Google Sheets shortcut key professor

  • Shortcut keys = ctrl+alt+d, E, arrow keys up and down select between the options, enter.

If you’re not as technical and prefer a broken out explanation with screenshots, read below.

If you want to be guided more and things explained, keep reading.

We explain how we get the URLs automated, and share the exact logic used to do it below. In our 11 step tutorial.

The use case is we have 100+ URLs with coordinates from a previous lesson.

Split URL to Columns in 11 easy steps.

Let’s use Google Sheets Split Url to Columns function now!

  1. Left-click the column header with URLs

    screenshot of URLs in column C on google sheet for demonstration to split to column
    Left click above –Headquarters, to select ‘C’ the column header that contains URLs to split.
  2. Left click Data, Ctrl+Alt+D or Ctrl+Option+D,
  3. Left click Split text to columns… or E

    split text to columns for with URL tutorial screenshot
    Split text to columns on Google Sheets is extremely powerful for manual manipulation of a table of data.
  4. On the bottom of your browser – you’ll see a subtle menu. If you have a big screen, you could miss this at first! Google Sheets natively uses comma separator.

    separator split to text drop down
    We bring our browser window into a smaller vertical box, otherwise this Separator: Comma drop-down may be hard to see at first. Left click Comma to activate the drop Split text to column Dropdown.
  5. Left click Custom to open the wild card Split text to column finder.
  6. Type @ to separate by a character or many.
  7. Copy – Latitude – and paste it in column D header.
  8. Left click column D to select the entire column of Latitude, Longitude, etc….

    screen shot of column header latitude for split url to columns tutorial
    Left-click the column header to select the entire column.
  9. Left click Data, Left click Split Text to columns… (Refer to Step 4 screenshot above)
  10. Use Custom for the separator, and leave it set to default comma.
  11. Copy – Longitude – paste that to Column E.

    Latitude and Longitude have been split from a Google Maps Url copy paste.

Split URL to Columns in Google Sheets

Splitting text into columns is amazing if you want to avoid spending money to get coordinates.

Google Sheets offers a two-click win, 1 type win.

Have you tried using the Split function in Excel or Google Sheets?

You’re missing out! Watch how I handle my personal portfolio.

This data project was going to take a long time to manually process grab every coordinate.

Crap, that’s a lot of beans, and now that I’ve done it two times. I realize this is going to take all friggin day.

Macroing to save hours of time and using Software functions to help generate data!

Yes, we use the idea of the software service coming from Google sheets to Split to text!

Solution Architect 101, you can’t offer solutions if you’ve never tried the product!

Split text to columns is a function in Google Sheets, Excel, and also done in code!

Oh crud, I thought this was going to be business friendly!


I prefer Tableau because I can hammer through this with simple calcs, but this is very easy too.

Macroing to get URLs with Coordinates and Split URL to Columns for Consumption!

Have you worked with a lot of clients? Need a way to bubble it up? Here’s a unique way that helps me tell the story of my past experiences.

If you need any help with it, please comment below.

Keyboard Maestro solves this problem; then we split URLs to columns.

If you’re doing something manually, over and over, consider recording it, and making it a button.

I have 100+ client names I want to show on a map! I needed to gain their mapping information without having to go the usual route of paying or manually doing it.

If you’ve done any coordinate gathering, you’ll learn if you’re not a developer you’re going to have to pay for someone’s system to do it for you!

Bah, luckily getting a URL is only a couple of buttons with Keyboard Maestro.

Bulk Automate Grabbing Coordinates Screenshot!

If the screen shot doesn’t suffice, we break it down step by step – Bulk Automate URL Coordinates.

split url to column google sheets screen shot of keyboard maestro scraping from googlesheets column and pasting
Screen shot of a script that handles the keyboard shortcuts to gaining all of my previous client engagement URLs. Google applies the coordinates to the URL! KM grabs the URL, comes back to google sheets and pastes the URL, grabs another and loops back. Easy right!

Macroing could be cleaner here

The macroing in Keyboard Maestro or other methods of capturing URLs from a spreadsheet or CSV available, this is simply one that offers a good explanation of both products in a simple method.

We can quickly take on massive data projects, grinding reporting engagements, or meetings that consultancies pitch ten people for.

We can do it while we work on something else! Now so can you.

By using this method, and methods like this, many things can now be accomplished!

This is primarily the T in ETL, which stands for extract, transform, and load. It’s a job I’ve had for 8+ years.

If you’re new to solutions, consider macroing a tool. It’s not the best hammer in the toolbox. But without it, you’re not spending your time, or your clients time wisely.

Saving time by macroing and using google sheets split text to columns function.

Stacking solutions are critical. Not having any experience with more than a single software does not allow much flexibility in your solution range.

With this easy functionality in Google Sheets, Dev3lop takes data projects that others pitch squads of consultants and hours of client time.

Selecting coordinates from an URL may seem like a small task, but for this request – it’s 100+ URLs with coordinates in the URL.

100 URLs is technically a small demand in the grand scheme of things.

We help some companies computer trillions of URLs.

So, with a little bit of free time comes ideas and now we all have access to this great method.

Read more!

Did you know I’m ranking #1 on Tableau logo?

Have you used WordPress yet or want to learn how to make an image a link in wordpress? We write about all kinds of getting ahead strategies.







2 Comments Add yours

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s