Advanced IPv4 Subnet Calculator in Python3
Table of Contents
Getting Started
│ main.py
│ read_subnets.py
│ subnetting.py
│ export_subnets.py
│ parse_excel.py
│ svi_generator.py
│ svi.j2
│ subnets.csv
│ requirements.txt
│ README.md
│ .pre-commit-config.yaml
│ .gitignore
│ LICENSE
│
└───assets
preview.png
subnets-csv.png
subnetting-cli.png
svi-template.png
svi.png
Installation
$ git clone https://github.com/Tes3awy/subnetting.git
$ cd subnetting
$ pip install -r requirements.txt --user
OR
- Download the latest release from Releases.
- Extract
subnetting.zipfile. cdintosubnettingdirectory.- Run
path_to\subnetting> pip install -r requirements.txt --userin terminal.
How it works?
Windows
path_to\subnetting> python main.py
macOS or Unix
$ python3 main.py
You will be prompted to enter the name of the CSV file containing input subnets, the gateway, a name for the Excel file to be created. (All inputs have default values).
A
subnets.csvfile can be found in the repo. This file is an entry point to get started using this program. It's prepopulated with three different subnets. (Class A, B, and C).
- CSV file [subnets.csv]:
- The gateway, first or last IP Address [0/1] [0]:
- Excel file to create [New-Schema.xlsx]:
Voila
Please check New-Schema_<TODAYS_DATE>.xlsx in current working directory.
Default behaviors:
- CIDR notation with no prefix length will be handled as /32.
- For example, if you enter10.0.0.1without a prefix length in the CSV file, the script will handle it like10.0.0.1/32.
- The header line
Subnets in CIDR Notationwithin thesubnets.csvfile is automatically skipped. So, there is no need to manually remove it.
- The gateway input accepts 0 or 1 ONLY [Defaults to 0]. 0 picks the first IP address of the subnet, while 1 picks the last IP address.
SVI Configuration Template
Finally, if you have a L3 switch and you want to create SVI interfaces of the created subnets on that switch, you can run:
$ python parse_excel.py --file <EXCEL_FILE_NAME>.xlsx
This Python script will generate a configuration file that includes all VLANs and their SVI interfaces.
NOTE: Make sure you add the VLAN ID and VLAN Name in all the cells in the generated Excel file before running
parse_excel.pyscript. Otherwise, VLAN ID and VLAN Name will be NaN in the generated configuration file.
Previews
Terminal 
Elapsed time is about 9 seconds in here because a CIDR notation like 10.0.0.0/8 is a little bit extensive to process.
CSV File (Input File) 
Excel File (Output File) 
python parse_excel.py -f <EXCEL_FILE_NAME>.xlsx 
SVI Template 
1 Jun 3, 2022
1 Nov 26, 2021
3 Dec 9, 2021
0 Apr 22, 2022
1 Sep 8, 2022
2 Jan 27, 2022
8 Dec 28, 2021
3 Jan 20, 2022
1 Dec 27, 2021
40 Dec 22, 2022
8 Apr 04, 2022
183 Jan 06, 2023
2 Jan 02, 2022
7 Dec 13, 2022
3 Nov 30, 2021
5 Oct 17, 2022
2 Oct 27, 2021
4 Jul 03, 2021
2 Nov 14, 2022
2 Jul 11, 2022
18 Jul 20, 2022
7 Dec 25, 2022
3 Jul 14, 2022
1 Nov 16, 2021
25 Dec 30, 2022
96 Dec 15, 2022
0 Feb 20, 2022
3 Dec 18, 2021
1 Jul 22, 2022