.CSV File not properly previewed

Question

Hello,

I am uploading a .CSV file that has a header with different columns separated by ",".

Also, the lines under it are also structured according to the colums by ",". However, one of the columns have a text field and in some cases, the text contains ","... so I am using quotation marks around the text to encase the whole thing. But when I upload it to my Azure Storage and preview it, it is shown very weird. It's like the preview doesn't care about the " " marks and simply creates new columns with the words inside the quotation marks if there are , inside the text column.

How do I solve this in Azure Storage? Thank you!

Example

Answer 1

@AI Project Sweden

Thanks for bringing this to our attention! I was able to reproduce your issue using the preview feature in Azure portal. You can also choose Edit and this will display the CSV file with commas.

I am reporting this issue to our internal Storage team for review and fix. As a workaround you can use Azure Storage Explorer. I confirmed the preview feature works as expected.

Hope this helps. Apologies for the issue, I will provide an update if I confirm this issue is resolved.

---

If you still have questions, please let us know in the "comments" and we would be happy to help you. Comment is the fastest way of notifying the experts.

If the answer has been helpful, we appreciate hearing from you and would love to help others who may have the same question. Accepting answers helps increase visibility of this question for other members of the Microsoft Q&A community.

Thank you for helping to improve Microsoft Q&A!