Split URL to Columns in Google Sheets — tldr
Splitting text into columns is amazing if you want to avoid spending money to get coordinates. https://dev3lop.com/split-url-to-columns/
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!
Okay,
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.
