Save attached file to e.g. CubesToLights.py

Import OBJ with suitably named groups, select the guide object and run script (if freshly imported should be selected by default).

Default naming convention is :-
Group name = "SpotLight" + 2 digits => Spotlight.
Group name = "PointLight" + 2 digits => Point light.
Group name = "Target" + 2 digits => Target for spotlight with same 2 digits.

Naming convention, number of digits, whether to delete existing lights, and whether to hide the original prop are configurable by editing the variables at the beginning of the script.