Forum Discussion
Issue with CSV Export in Microsoft Excel
Hi Team, I am currently facing an issue with Microsoft Excel. I have a spreadsheet with column named "Sprint" and values are formatted as text, such as "23.20". When I attempt to save the sheet as ...
Hi Sonali123456
Same as my post from Feb 06 2024 01:12 PM - I get what you expect - saved as UTF-8 or "classic" CSV (files attached):
But we might not be on the same page. In Welcome to your Excel discussion space! you're asked to provide Excel version + OS. Except if I missed it, you haven't provided this info. yet
Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit / Windows 11 23H2 here
Hi Lorenzo
Excel version + OS version:
Microsoft® Excel® for Microsoft 365 MSO (Version 2401 Build 16.0.17231.20236) 64-bit / Windows 10 21H2
The issue occurs when the CSV file is opened with Excel instead of a text editor like Notepad.
Excel version + OS version:
Microsoft® Excel® for Microsoft 365 MSO (Version 2401 Build 16.0.17231.20236) 64-bit / Windows 10 21H2
The issue occurs when the CSV file is opened with Excel instead of a text editor like Notepad.
Hi Sonali123456
The issue occurs when the CSV file is opened with Excel instead of a text editor like Notepad
This is how Excel behaves when opening CSV. In your scenario where the CSV has to be read by an API I don't see where the issue is, sorry