Read From File Returns incorrect data

Describe the problem/error/question

CSV is not properly parsed. When I download the csv from the n8n UI, it has the information required. But somehow when the node parses it, it returns something like this “7.2775972587867755e+31” instead of this “72775972587867756776576378617657”

I tried to make the node parse it again when that happens, thinking it would work the second time. But it doesn’t seem like it and I get the same results even if it tries 500 times.

What is the error message (if any)?

Please share your workflow

Share the output returned by the last node

You can find it in the screenshots above.

Information on your n8n setup

  • **n8n version: 1.1.1

I’m not sure about the rest because I didn’t set up the instance.

Hi @automationk2a2 :wave: Welcome to the community :tada:

Can you take a peek at this post re: scientific notation and see if that helps clear this up?

In short, JavaScript simply can’t exactly represent large numbers (this is the boundary), so converting this to a string might help the display.


Thanks for your reply! Very good to know. I switched to xlsx but I’ll use a string then instead if I get the same problem.

Thank you again!


This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.