How to Trim Full URLs to Subfolders and Slugs in Google Sheets | Scribe

    How to Trim Full URLs to Subfolders and Slugs in Google Sheets

    • Ryan VanValin |
    • 18 steps |
    • 31 seconds
    1
    Open a Google Sheet
    2
    Paste the list of URLs into a column
    3
    Paste the same list of URLs into another column
    alert ordinal icon
    It is important to ensure that you have the list of URLs in 2 columns so that you can keep one of the lists clean while you transform the other. This will be important later
    4
    Press [[cmd]] + [[f]] to open the "find" tool
    5
    Click here.
    6
    Type the first part of the URL (ex:<https://www.examplesite.com/>) before the path into the "Find" box
    7
    Leave the "Replace with" box empty
    8
    Click "Replace all"
    9
    Click "Close"
    10
    Click on the newly replaced column.
    11
    Click "Data"
    12
    Click "Split text to columns"
    13
    Click "Detect automatically"
    14
    Click "Custom".
    15
    Type "/" then hit [[enter]]
    16
    Double-click here.
    17
    Add a new row above
    18
    Name your new columns
    information ordinal icon
    You're done! Now you can pivot based on the path or slug to analyze your data