Does BOFC allows to create duplicate fields or displays any error if fields with same API name are created?

Yes, Bulk Create Field feature is smart enough to identify the fields with the same api name.

This tool is available on Appexchange and Click on below button to install the
latest version of BOFC

or learn more