Screaming Frog - Redirects

Original document - Shared with everyon / Shared tutorials / Screaming frog / Crawl site to do bulk redirects tutorial

Choose –

Delimited / Next

Comma / Next

General / Finish

Keep Column A with the URLs in it, delete the rest

Delete any rows that aren't URLS

In column B add a line - | (the top figure next to the left hand shift key on the keyboard) all the way to the bottom of the URLs

Then save your document with a new name e.g. internal_all-updated

Open Notepad, Show all files

Then click ‘File’ / ‘Open’ / and select your excel document from the list.

‘Edit’ / ‘Replace’

In the ‘Find what’ box type a comma and leave the ‘Replace with’ box blank. Then click ‘Replace all’ and exit the text box

Save

Go to the back of Joomla Manage / Redirects

copy and paste the whole thing into the Bulk import option then click Bulk Import