• Home
  • About
  • Insights Hub
    • New Posts
    • Technical SEO
    • General Discussion
    • View All Forums
  • Blog
  • Contact
    • Hub
      New posts Search forums
    • What's new
      New posts New profile posts Latest activity
    • Members
      Current visitors New profile posts Search profile posts
    Log in Register
    What's new Search

    Search

    By:
    Advanced search…
    • New posts
    • Search forums
    Menu
    Log in

    Register

    Install the app
    • Home
      • Hub
      • Technical SEO
      You are using an out of date browser. It may not display this or other websites correctly.
      You should upgrade or use an alternative browser.

      Excel Formulas to build URL paths for bulk creation of webpages

      • Thread starter Chris
      • Start date Sep 12, 2021
      • Sep 12, 2021
      This guide will show you a very easy method to create URL paths in bulk using Excel or Google Sheets. I created over 3500 URL paths in less than 10 minutes using mobile device names scraped from Google Analytics.

      As an SEO practitioner, you may be asked to create URL paths for dozens if not hundreds or even thousands of new URLs paths.

      The SUBSTITUTE Formula
      One trick I tend to use is to replace the whitespace between words (H1 heading or page title) with hyphens (aka dashes).
      The SUBSTITUTE formula locates every space between words (or numbers) and replaces them with a hyphen.

      Code:
      =SUBSTITUTE(B1," ","-")

      Drag the formula down to copy across multiple rows. This tip works for both Microsoft Excel and Google Sheets.


      Formula to replace whitespace with hyphen.PNG



      UPPERCASE to Lowercase
      The next step is to convert UPPERCASE to Lowercase using

      Code:
      =LOWER(B2)

      And lastly, if you're using a file extension such as PHP or HTML. Create a new column for the file extension populated with the chosen file extension name.

      Concatenation Formula
      Then use the concatenation formula
      Code:
      =CONCATENATE(E2,F2)

      The results should look something like this image below

      filepath2.PNG



      If you would like a full copy of the sheet with formulas comment below and I will happily share it with the readers of this guide.
       
      Click to expand...
      C
      Written by

      Chris

      Administrator
      Staff member
      • Messages
        51
      • Reaction score
        0
      • Points
        6
      You must log in or register to reply here.
      Share:
      Facebook Twitter Reddit Pinterest Tumblr WhatsApp Email Share Link

      New Posts

      • vogeldm
        SEO and Digital Marketing services
        • Started by vogeldm
        • Apr 22, 2022
        • Replies: 0
        Technical SEO
      • C
        Dropped .UK Domains 11th April 2022
        • Started by Chris
        • Apr 11, 2022
        • Replies: 0
        General Discussion
      • C
        Google Sheets Regex for excluding subfolders
        • Started by Chris
        • Oct 12, 2021
        • Replies: 0
        Technical SEO
      • C
        Modify or Deploy Meta Viewport - Google Tag Manager
        • Started by Chris
        • Sep 24, 2021
        • Replies: 0
        Technical SEO
      • C
        Open-source tools & projects that use Lighthouse
        • Started by Chris
        • Sep 24, 2021
        • Replies: 0
        Technical SEO
      • C
        How to Force HTTPS using .htaccess (cPanel)
        • Started by Chris
        • Sep 24, 2021
        • Replies: 0
        Technical SEO
      • C
        Canonical Tag Override using Google Tag Manager
        • Started by Chris
        • Sep 24, 2021
        • Replies: 0
        Technical SEO
      • C
        Websites to use DNS Prefetching & Prefetching
        • Started by Chris
        • Sep 24, 2021
        • Replies: 0
        Technical SEO
      • Hub
      • Technical SEO

    Join the Community

    Chris Lever is a freelance SEO Consultant availible for Hire. Join the growing SEO Community Forum to learn new skills.

    Join Us

    Need Help?

    • BB Code
    • Cookie Policy
    • Terms of Use
    • Privacy Policy
    • HTML Sitemap

    Learn More

    • About
    • Availability
    • Popular Posts
    • Projects & Scripts
    • Contact

    Get in Touch

    Chris Lever, Manchester, United Kingdom
    info@chrisleverseo.com
    +44 0161 883 2249

    © 2021 Chris Lever SEO. All rights reserved. Powered by Xenforo

    • This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
      By continuing to use this site, you are consenting to our use of cookies.
      Accept Learn more…