I am not sure since I keep seeing weird things with your csv file.
When I open in excel I get this with ;
FA0069920;FURNITURE AND FITTINGS;AIR CONDITIONER;AIR CONDITIONER - MIDEA;GOLDAIR;RM000501;M MKHABELA;MAIN BUILDING;FIRST FLOOR;RM000501;;EXCELLANT
FA0069290;FURNITURE AND FITTINGS;AIR CONDITIONER;HIGHBACK 1;Highback;RM000501;M MKHABELA;MAIN BUILDING;FIRST FLOOR;RM000501;;EXCELLANT
In Notepad same thing
BARCODE;SERIAL_NUMBER_PLATE;ASSET_DESCRIPTION;ROOMNUM;ROOM_DESCRIPTION;BUILDING;FLOOR;SITE_DESCRIPTION;RESPONSIBLE_PERSON;ASSET_CATEGORY_ID;CATEGORY;SUB_CATEGORY;SUB_CATEGORY_DESCRIPTION_FOR_DEPRECIATION;CONDITION 5727;N/A;4 DRAWERS - CABINET - STEEL
If I import from txt in Excel I get this IF i use ; as the delimiter
ASSETCODE ASSETCATEGORY ASSETTYPE PRODUCTNAME ASSETNAME ROOMDESCRIPTION RESPONSIBLEPERSON BUILDINGNAME FLOOR ROOMNO SERIALNO CONDITION
FA0069920 FURNITURE AND FITTINGS AIR CONDITIONER AIR CONDITIONER - MIDEA GOLDAIR RM000501 M MKHABELA MAIN BUILDING FIRST FLOOR RM000501 EXCELLANT
FA0069290 FURNITURE AND FITTINGS AIR CONDITIONER HIGHBACK 1 Highback RM000501 M MKHABELA MAIN BUILDING FIRST FLOOR RM000501 EXCELLANT
FA0069281 FURNITURE AND FITTINGS CABINETS AND CUPBOARDS PEDESTAL PEDESTAL RM000501 M MKHABELA MAIN BUILDING FIRST FLOOR RM000501 EXCELLANT
FA0069289 FURNITURE AND FITTINGS CABINETS AND CUPBOARDS PEDESTAL PEDESTAL RM000501 M MKHABELA MAIN BUILDING FIRST FLOOR RM000501 EXCELLANT
FA0069291 FURNITURE AND FITTINGS CABINETS AND CUPBOARDS PEDESTAL PEDESTAL RM000501 M MKHABELA MAIN BUILDING FIRST FLOOR RM000501 EXCELLANT
I am now not seeing a , but I way have used the wrong sheet.
In the end I think you somehow set it to use ; instead if , - then called it a csv - which is really is not.
I have attached a fixed version. You could also use external_choices tab by a copy/paste instead.