Import '£' symbol to SQL Server using Azure Data Studio

I am trying to import a table to SQL Server. I'm using the Import Wizard in Azure Data Studio.

The table is a conversion table and the units might be in £ or £000s for example.

The field needs to be a text field, but when I import the data whether I set the data type to Text or Nvarchar or Varchar the import wont import £ it will show as ?, so £ will become ? and £000s will become ?000s.

Is there a data type that will import a special symbol like £ correctly or is there a different way to import these fields?

I tried in my environment by saving the .csv file in UTF-8 format and import the data into Azure SQL DB and it works well by saving the data in the same format into my Azure SQL Database successfully as shown in the below output.

I tried to save the below .csv data with UTF-8 format into Azure SQL DB.

Id,Description
1,"Price is £100"

Output: