How to add sensors in bulk from an excel spreadsheet

Hodwy guys!

I’m starting an automation that checks on sensors by IP addres but i have an excel spreadsheet with all the sensor IP addres and mac address. I would like to know how to add them to Home assistant in bulk bessides of adding each one at a time


I’m not aware of any utility available to help you with this. Going to just be a lot of Ctrl+C, Ctrl+V.