I have a spreadsheet of several thousands URLs.... Many of the links return 404 errors. Each row contains a few columns (URL, link title, link description).
I would like a script created that will enable me to upload a Microsoft Excel spreadsheet (or CSV spreadsheet). I can then specify the column that contains the URLs (Column A or Column B, etc.). The system will then visit each URL to check for 404 errors. If a 404 error is found, the entire row for that link will be removed.
Once the script completes its task, the script will provide me with 2 spreadsheets: one that is clean (no link leads to a 404 error), and another spreadsheet that contains all the bad links and related data (URL, link title, link description).