importing address lists

RouterOS Beginner Basics
1

Hi guys,

how can i import a list of ip addresses for .xls format into an address-list ?

I am trying to setup routing of certain addresses via a specific gateway.

Any help or reference would be greatly appreciated.

2

=“/ip firewall address-list add list=importlistname address=” & a1

put that in B1. then fill down, and copy and paste into terminal.

3

Thanks for the reply,

however im not quite following your instructions ?

can you break it down for me please.

Sorry for my ignorance.

4

add the “/ip firewall address-list add list=importlistname address=” command to the first column of your XLS file. Select all → copy → paste into router

5

Awesome, thank you.