Outputting data to csv format

RichardAlt

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!

atcodedog05

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

csv_output_formatted.csv

csv.yxmd