Getting Exponential value in one of the CSV columns when downloaded from Browser

Hello Team,

My concern is given below:

I am using cypher to get the output but while doing "export to CSV" from Neo4j UI , Getting Exponential value in one of the CSV columns .

PFA snapshot from excel and UI.

Please suggest how to handle this.

Regards
Akshat

This isn't cypher or Neo4j, it's excel.

Check the data type on the column in Excel and switch it to text. Note that Neo4j is exporting it as text, and so you should view it as text. Because the number is very large, Excel is switching to scientific notation to make the display of the value more compact. The value itself isn't lost, it's just that the way Excel is displaying the data is a little bit strange.

Instead of switching to text, there's also other options for manipulating how Excel displays numeric values.

Hello Allen,

Thanks a lot for making it clear.

I will check from excel end.

Regards
AK

1 Like