Is there no way to import FQDN's or IP addresses to an XG?

Question

I'm finding more and more situations where I need to allow a large range of IP addresses and FQDN's to our customer's Firewalls... 
 Is there no way to import JSON, CSV or TXT IP or FQDN lists to either a v17 or v18 FW? 
 This is an extremely frustrating issue that frankly ALL other vendors support. It is seriously costing us and our clients who we support time and money.

Vishal_R · Answer

Hi Adam Ricket Import via CSV or TXT for IP or FQDN is as of now feature request. https://ideas.sophos.com/forums/330219-xg-firewall/suggestions/33035827-import-fqdn-s-cidr-lists-from-csv-or-txt Alternatively you may try with API to make it automate. https://community.sophos.com/kb/en-us/132560

Antonio Cienfuegos S · Answer

I did a home-made Powershell script that takes a CSV file with the following "columns": 
 
 Name,IP,Netmask 
 If you don have the data in that format, its very easy to format it with Notepad++ (as lucar toni mentioned). You can save those steps to a macro, for later usage.

With that data, it creates the objects through API. If that works for you, ping me and I can show you how to use it. When migrating firewalls, I used to put the objects in the .csv file, run the powershell and then, have a coffee. In a few moments, all the objects will be created in the XG