Forum Discussion

Sonali123456's avatar
Sonali123456
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 ...
Excel
Lorenzo's avatar
Lorenzo
Silver Contributor
Feb 06, 2024

Hi Sonali123456 

 

I don't think there's an issue but suspect you open the CSV with Excel. If instead you open it with a Text editor like Notepad you should see something like:

 

In Excel A2:A5 cells are formatted as Text

  • Sonali123456's avatar
    Sonali123456
    Copper Contributor
    Feb 09, 2024

    Hi Lorenzo 

    Yaah I already tried that, when I open it as notepad or any text editor, I am able to read my actual values.

    but my REST API accepts a CSV file (Read the csv file and upload the data in DB) when I try to provide this csv file as input to my API the value getting saved in DB is '23.2' instead of '23.20'

    • Lorenzo's avatar
      Lorenzo
      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"?

      • Sonali123456's avatar
        Sonali123456
        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.

         

Resources