Hi guys,
I'm trying to output my data to CSV format.
This is my data before I output it to CSV.
and this is the CSV output.
It converts the notation and the other rows 0 is gone.
But when I output this on .xlsx format it working.
Any ideas why?
Thanks!
Solved! Go to Solution.
Hi @RichardAlt
The issue is not caused by .csv its actually caused excel.
.csv is a text file and all the column is saved as text. But when you open in excel it runs auto detect datatype to format according to the best suited datatype.
If you open .csv in notepad you can see that the data is still in proper format.
when opened in excel
PS: this just a display issue. The data is not lost in .csv
Hi @RichardAlt
The workaround for this would be to add a quote at the beginning or end like below
Data in excel:
This is a hack to make data look proper.
Hope this helps 🙂 Feel to ask if you have any questions
It is working now. What I did is something like this.
Thanks!
Happy to help 🙂 @RichardAlt
Cheers and Happy Analyzing 😀
Feel free to reach out if you face any issues 🙂
Hi,
Could you please help us on how to save output into csv format?