Forum Discussion

Copper Contributor

Feb 06, 2024

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 ...

Silver Contributor

Feb 09, 2024

Hi Sonali123456

So it's not an Excel to CSV issue, it's your API that "tranforms" the values

Do you know if the API would accept, as input, values between simple/double quotes, i.e. '23.20' or "23.20"?

Copper Contributor

Feb 21, 2024

Hi Lorenzo
it's an issue with Excel to CSV conversion. API reads the value as it is mentioned in the csv file.

Lorenzo
Silver Contributor
Feb 21, 2024
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
Sonali_UTF-8.csv0 KB
Sonali.xlsx10 KB
Sonali.csv0 KB
- Sonali123456
  Copper Contributor
  Mar 18, 2024
  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.
  - Lorenzo
    Silver Contributor
    Mar 21, 2024
    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