Can Moz generate 404 Broken links report in an excel format

[LilianB]

Hi all,

Hope you are doing good and that all is well at your end. I'm a marketing team member here at Zephyr and I take care of the content side things for the team. I'm reaching out to you this morning in regards to figuring whether any Moz feature can be used for fixing broken links on our website and whether or not it can generate the broken links report which can be exported and saved in a spreadsheet. We are in the middle of cleaning up all the broken links which are currently live on our drupal site and which is why we are in need of a tool that generates the report of all the broken links onto an excel spreadsheet.Once we have the list of broken links set in a spreadsheet, we will work towards fixing those links. Meanwhile, we have also created a 404 error image for our readers who can be directed towards our homepage. Please, let me know if you can help me take care of these below-mentioned requests:

1. Suggest a tool /Moz feature which can generate the site report and list of broken links onto excel/spreadsheet

2. Once I've the list in an excel format, is there an automated way in which we can fix all the broken links which are currently live on our website, instead of manually deleting/unlinking those pages.

Truly appreciate your help. Thank you!

Is there an automated way in which we can fix all the broken links which are currently live on our website, instead of manually deleting/unlinking those pages.

[LilianB]

Thanks a lot Dmitrii for all the help!

[DmitriiK]

Hi there.

Well, #1 is easy - go to your campaign->Site Crawl->4XX Client Error, Then click download CSV, this can be opened in Excel no problem.

#2 is quite more difficult. There is no way really to automatically remove 404s with magic. However, you can use 301 redirects (rewriteRule) for whole subfolders/directories, also, since you are using CMS, you might be able to find-replace paths in broken urls.

However, none of that would really fix 404s. If pages just moved, you should use 301 redirect, if it's gone, then you might use 410 Gone.

Hope this helps.