
Re: Need to add around 2500 subnets' IP addresses through excel sheet
mavturner Jul 29, 2011 1:45 PM (in response to faizalis01)Are you trying to add invidual addresses or subnets? If you are trying to add invidual addresses, you can do this with the subnet import wizard. If you are trying to create the subnets, do you have the netmask in /XX CIDR format or subnet mask 255.255.255.0 format? If the former, you can do this directly in the import wizard of IPAM.

Re: Need to add around 2500 subnets' IP addresses through excel sheet
faizalis01 Jul 29, 2011 2:18 PM (in response to mavturner)I have the excel sheet in below format for each locations.
a
x.y.z.1
VLAN 1
a
x.y.z.4
a
x.y.z.5
a
x.y.z.7
a
x.y.z.8
a
x.y.z.9
a
x.y.z.10
a
x.y.z.11
a
x.y.z.12
a
x.y.z.14
a
x.y.z.15
a
x.y.z.16
a
x.y.z.22
a
x.y.z.23
a
x.y.z.25
a
x.y.z.26
a
x.y.z.27
a
x.y.z.30
a
x.y.z.39
a
x.y.z.203
a
x.y.z.204
a
x.y.z.206
a
x.y.z.224
a
x.y.z.225
a
x.y.z.244
a
x.y.z.252
a
x.y.z.253
a
x.y.z.254
a
x.b.z.1
VLAN 2
a
x.b.z.11
a
x.b.z.53
a
x.b.z.62
a
x.b.z.65
a
x.b.z.117
a
x.b.z.126
a
x.b.z.129
a
x.b.z.139
a
x.b.z.181
a
x.b.z.190
a
x.b.z.193
a
x.b.z.72
a
x.b.z.204
a
x.b.z.245
a
x.b.z.254

Re: Need to add around 2500 subnets' IP addresses through excel sheet
faizalis01 Jul 29, 2011 2:18 PM (in response to mavturner)I have the excel sheet in below format for each locations.
a
x.y.z.1
VLAN 1
a
x.y.z.4
a
x.y.z.5
a
x.y.z.7
a
x.y.z.8
a
x.y.z.9
a
x.y.z.10
a
x.y.z.11
a
x.y.z.12
a
x.y.z.14
a
x.y.z.15
a
x.y.z.16
a
x.y.z.22
a
x.y.z.23
a
x.y.z.25
a
x.y.z.26
a
x.y.z.27
a
x.y.z.30
a
x.y.z.39
a
x.y.z.203
a
x.y.z.204
a
x.y.z.206
a
x.y.z.224
a
x.y.z.225
a
x.y.z.244
a
x.y.z.252
a
x.y.z.253
a
x.y.z.254
a
x.b.z.1
VLAN 2
a
x.b.z.11
a
x.b.z.53
a
x.b.z.62
a
x.b.z.65
a
x.b.z.117
a
x.b.z.126
a
x.b.z.129
a
x.b.z.139
a
x.b.z.181
a
x.b.z.190
a
x.b.z.193
a
x.b.z.72
a
x.b.z.204
a
x.b.z.245
a
x.b.z.254

Re: Need to add around 2500 subnets' IP addresses through excel sheet
Daniel.Chambers Aug 16, 2011 2:51 AM (in response to faizalis01)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?

