I have tried importing the given file into the demo.odoo.com database, and I can import it without any issues, here is a screenshot for your reference.

You can make sure the fields are mapped correctly, additionally, if multiple products exist with the same name, you can use the "Product.template External ID" for the BOM Product and  "Product variant External ID" for the Components.

Here is a video you can refer to - https://drive.google.com/file/d/1l_vcHG14vWvWR6XtoaQJL1GhZ578SFfp/view