-
Download Python:
- Visit the official Python website: https://www.python.org/downloads/.
- Download the version compatible with your operating system (Windows, macOS, or Linux).
-
Install Python:
- Run the downloaded installer.
- Check the box that says "Add Python to PATH" during installation. This will make it easier to use Python from the terminal.
- Follow the installation steps until complete.
-
Open a Terminal:
- On Windows: Press
Win + R, typecmd, and pressEnter. - On macOS/Linux: Open the "Terminal" application.
- On Windows: Press
-
Install the openpyxl Library:
- Type the following command in the terminal and press
Enter:pip install openpyxl
- If you have multiple versions of Python installed, use
pip3instead ofpip:pip3 install openpyxl
- Type the following command in the terminal and press
-
Create the Excel File:
- Create an Excel file named
email.xlsx. - Make sure that the email addresses to be verified are placed in column A, starting from cell
A1.
- Create an Excel file named
-
Save the File:
- Save this file in the same directory where you will place the Python script for easy access.
-
Create the Python Script:
- Copy the provided Python code into a new text editor (such as Notepad++, Visual Studio Code, or even Notepad).
- Save the file with a
.pyextension, e.g.,emailchecker.py.
-
Check the Directory:
- Place
email.xlsxandemailchecker.pyin the same directory (e.g., on the Desktop or in a dedicated folder).
- Place
-
Open Terminal:
- Navigate to the directory where the script and the Excel file are located.
- For example, if the files are on the Desktop:
cd Desktop
-
Run the Script:
- Type the following command in the terminal:
python emailchecker.py
- If you have multiple versions of Python installed, use
python3instead ofpython:python3 emailchecker.py
- Type the following command in the terminal:
- Result File:
- After execution, a file named
result_verification.xlsx(orresult_verification_1.xlsx, etc. if there are multiple versions) will be created in the same directory. - Open this file to see the results, which will be in column B with "Valid" or "Invalid" for each email address.
- After execution, a file named
- If an error occurs while executing the script, a file named
error_log.txtwill be generated with a description of the error. - Make sure to check this file to understand what went wrong.
- Install Python: https://www.python.org/downloads/
- Install openpyxl:
pip install openpyxl