Don’t open the CSV in Excel, instead create a new workbook, click on the data tab on the ribbon and select ‘Get External Data’, ‘From Text’.
Select ‘delimited’ if your data is seperated with a specific character. You’ll have to specify the delimiting character on the next step. If you have a header row, enter a value for ‘Start Import at row…’
Click ‘Next’ and select your delimiting character. In this case, it’s a semi-colon ‘;’
If you wish to shape your data, you can enter field types here. For example, I want the ‘Barcode’ field to be rendered as Text as it may contain leading zeros or be summarised by Excel if it’s treated as a number.
Next, select your existing worksheet and press OK to import your data.