IPAM for Production Network

Good Afternoon,

I’m relatively new to Manufacturing networks, and I’m running into a lot of issues with duplicate addressing. What does everyone use as an IPAM?

Clients: 800-1000
Network: roughly 20 subnets
Each subnet only talks to dmz

We are using excel right now, to attempt to keep documentation; last night I found out it can not be trusted. I’m in the process of setting up tables and a front end for sql. Is there an off the shelf solution that will actively scan and populate a table or even excel doc?

These devices are primarily plcs rtas and such.