How to fix the issues while importing a .csv file to a DB in MSSQL using Azure Data Studio in MAC

Question

How to fix the issues while importing a .csv file to a DB in MSSQL using Azure Data Studio in MAC

Lalitha Maruthachalam 20

I tried to import the following .csv file using the import flat file wizard in Azure data studio. I have pasted a snapshot of it below. If I try to import it using Azure data studio the column 3 in row 2,3, 5, 13 and column 1 in rows 7, 8 are having '?' in the table after import.

Screenshot 2025-08-14 at 10.06.49 PM

Screenshot 2025-08-14 at 10.16.23 PM

User's image

Can you please let me know how to fix this?

Mahesh Kurva 9,800 Reputation points Microsoft External Staff Moderator

2025-08-15T17:23:08.1333333+00:00

Hi Lalitha Maruthachalam

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Mahesh Kurva 9,800 Reputation points Microsoft External Staff Moderator

2025-08-18T05:35:45.0933333+00:00

Hi Lalitha Maruthachalam

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Lalitha Maruthachalam 20 Reputation points

2025-08-18T07:41:31.94+00:00

Hi @Mahesh Kurva

Sorry I was out of town and could not try it out.

I tried today and It is working properly.

Thank you very much
Mahesh Kurva 9,800 Reputation points Microsoft External Staff Moderator

2025-08-18T07:44:33.66+00:00

Hi Lalitha Maruthachalam

Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Answer accepted by question author

0 additional answers

Your answer

Mahesh Kurva 9,800 Reputation points Microsoft External Staff Moderator

2025-08-15T17:23:08.1333333+00:00

Hi Lalitha Maruthachalam

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Mahesh Kurva 9,800 Reputation points Microsoft External Staff Moderator

2025-08-18T05:35:45.0933333+00:00

Hi Lalitha Maruthachalam

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Lalitha Maruthachalam 20 Reputation points

2025-08-18T07:41:31.94+00:00

Hi @Mahesh Kurva

Sorry I was out of town and could not try it out.

I tried today and It is working properly.

Thank you very much
Mahesh Kurva 9,800 Reputation points Microsoft External Staff Moderator

2025-08-18T07:44:33.66+00:00

Hi Lalitha Maruthachalam

Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Answer 1

Hi Lalitha Maruthachalam

Greetings!!

Steps to Fix Special Character Issues When Importing CSV into Azure Data Studio on macOS:

1.Check and Convert the Encoding of Your CSV File

Open your .csv file in a text editor like VS Code.
Look at the bottom-right corner to check the current encoding (e.g., Windows 1252, MacRoman, etc.).
If it's not UTF-8, convert it:
Go to File → Save with Encoding → UTF-8.

2.Save the File as UTF-8 Without BOM

When saving, choose UTF-8 without BOM.
This ensures that special characters (e.g., é, ü, ñ) are preserved correctly and prevents any hidden byte order marks that might interfere with import.

3.Re-import the File Using Azure Data Studio

Open Azure Data Studio.
Use the Import Flat File Wizard to load the newly saved UTF-8 file.
Special characters should now be imported correctly without showing as ?.

Hope this helps. Do let us know if you any further queries.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Share via

How to fix the issues while importing a .csv file to a DB in MSSQL using Azure Data Studio in MAC

0 additional answers

Your answer