Need to add around 2500 subnets' IP addresses through excel sheet

Question

Need to add arround 2500 subnets' IP addresses through excel sheet.

here I am facing problem with lot of manual work, Can anyone help me on this.

Daniel.Chambers · Answer

By the look of it, you have individual IP Addresses listed, for this you can import them using the spreadsheet. Have you try the Spreadsheet import?

faizalis01 · Answer

I have the excel sheet in below format for each locations.

ax.y.z.1VLAN 1ax.y.z.4ax.y.z.5ax.y.z.7ax.y.z.8ax.y.z.9ax.y.z.10ax.y.z.11ax.y.z.12ax.y.z.14ax.y.z.15ax.y.z.16ax.y.z.22ax.y.z.23ax.y.z.25ax.y.z.26ax.y.z.27ax.y.z.30ax.y.z.39ax.y.z.203ax.y.z.204ax.y.z.206ax.y.z.224ax.y.z.225ax.y.z.244ax.y.z.252ax.y.z.253ax.y.z.254ax.b.z.1VLAN 2ax.b.z.11ax.b.z.53ax.b.z.62ax.b.z.65ax.b.z.117ax.b.z.126ax.b.z.129ax.b.z.139ax.b.z.181ax.b.z.190ax.b.z.193ax.b.z.72ax.b.z.204ax.b.z.245ax.b.z.254

faizalis01 · Answer

I have the excel sheet in below format for each locations.

ax.y.z.1VLAN 1ax.y.z.4ax.y.z.5ax.y.z.7ax.y.z.8ax.y.z.9ax.y.z.10ax.y.z.11ax.y.z.12ax.y.z.14ax.y.z.15ax.y.z.16ax.y.z.22ax.y.z.23ax.y.z.25ax.y.z.26ax.y.z.27ax.y.z.30ax.y.z.39ax.y.z.203ax.y.z.204ax.y.z.206ax.y.z.224ax.y.z.225ax.y.z.244ax.y.z.252ax.y.z.253ax.y.z.254ax.b.z.1VLAN 2ax.b.z.11ax.b.z.53ax.b.z.62ax.b.z.65ax.b.z.117ax.b.z.126ax.b.z.129ax.b.z.139ax.b.z.181ax.b.z.190ax.b.z.193ax.b.z.72ax.b.z.204ax.b.z.245ax.b.z.254