Note: this only has to be done once
Follow the below instructions in the order given
Install Node:
https://nodejs.org/en/download/
Install/Update NPM:
# all code given in these blocks
# are to be run in the terminal
npm install -g npm
Clone url-checker repository to local machine
git clone https://github.com/justenbphelps/url-validator.git
cd url-validator
Install dependencies
npm i
The actual usage of the script is very simple. The setup and install is the most involved part of the process.
To run the script, just make sure you are in the url-validator
directory/folder, and place the file to be checked in the same folder
Run Command:
node validate.js <FILE_NAME.xlsx>
After the validation is complete, there will be a file named result.csv
that you can import into Excel or Google Sheets to see the validation results for each given url.
This is currently running on a Proxy server I am paying for and hosting. If this solution is useful to you and you think you will continue usage, I would prefer if you hosted it. I can walk you through how to do this at anytime :)
Proxy host: https://brightdata.com/