This is a simple script in Python that will check a series of urls from the first column of an .xlsx file, get the history from the response (redirects etc...) and will tell you, in a new .xlsx file, if the redirect is present (or not), if the page goes in 404 and if the redirected url is correct (based on the second column of the excel file that contains the list of the "final" urls).
Open the script with an editor like Notepad++ and edit the following variables as you prefer:
- Start from row # specify the first row of your .xlsx/.xls file that starts with a URL
- Sheet number # the index of the excel sheet you want to process, if "Selected sheet only" is unchecked it will do them all starting from this index
- Selected sheet only # if for any reason you need to do one file sheet at a time, flag this checkbox
To make this script work you need to install Python, xlrd and xlwt libraries.
You can download the latest version of Python from those links for Windows, Linux/UNIX, MacOS.
Move into project folder with git bash or cmd and launch this command to easy install all the required libraries:
pip install -r requirements.txt --user
Just in case you are using .xls (and not .xlsx) files, then, you'll need to install the latest version manually:
pip install --upgrade xlrd
Once done, make sure you're in the correct folder with cmd/terminal and launch (N.B. use your python version into the next command):
python gui.py
Now, setup all needed inside the brand new GUI and start the script.
After that, you will find your new results.xslx file into your folder destination (specified inside the GUI).
NB: an .exe of the script is available but your OS will probably block it. The best way to run the script is buy command line as described above but if you want, you can try to whitelist the .exe and run it in the easiest way possible.
03-06-2023 - Version 0.1.3
Features:
- Added the requirements.txt file in order to easily install all the required packages
- Added the .exe of the script to the release
02-06-2023 - Version 0.1
Features:
- Added a first version of a GUI
![](https://private-user-images.githubusercontent.com/24905857/242999507-8a52ed6e-8f2a-4c61-aa5f-9faba92ae019.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjQ5ODM4MzksIm5iZiI6MTcyNDk4MzUzOSwicGF0aCI6Ii8yNDkwNTg1Ny8yNDI5OTk1MDctOGE1MmVkNmUtOGYyYS00YzYxLWFhNWYtOWZhYmE5MmFlMDE5LnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNDA4MzAlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjQwODMwVDAyMDUzOVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTFhMDU2ZWY5YWFkZmY1NWM2ZWNhMWYwM2RlM2JhMzdkNjcxZTYyNTM4MTk2ZmJiNDJlMDAyY2I1OThmOTE1MzEmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JmFjdG9yX2lkPTAma2V5X2lkPTAmcmVwb19pZD0wIn0.GD7DA8RqRZM4puhXiFW5R6mj-vDX5X4bIdRlFx9QBTk)