Read a CSV File

nittanygeek · October 9, 2019, 1:23pm

Any way to read a basic CSV file?

jan · October 9, 2019, 1:41pm

That should be possible with the Spreadsheet node:
https://n8n.io/nodes/n8n-nodes-base.spreadsheetFile

Here an example:

nittanygeek · October 9, 2019, 5:15pm

I’m lost on where you put that JSON. If I create a Spreadsheet File node, how do I tell the node the file path of the CSV?

jan · October 9, 2019, 5:27pm

You would simply copy the above, then click once in the n8n window and do CTRL + v (paste). It will then create the nodes and connections.

You would do the file loading with a different node. The “Read Binary File”
https://n8n.io/nodes/n8n-nodes-base.readBinaryFile

nittanygeek · October 9, 2019, 8:20pm

Awesome, that’s just what I was looking for! Thanks!

jan · October 9, 2019, 8:30pm

Great to hear that it works. Have a good night!

Veer_Manhas · February 12, 2021, 1:09pm

Tried using this and in the binary file path I added the CSV url

Am I missing something? I get this error
ERROR: The file “https://…Ce.csv” could not be found.

Any idea what I might be doing wrong here?

jan · February 12, 2021, 1:25pm

Welcome to the community @Veer_Manhas!

Yes, the “Read Binary File” node is for reading a binary file from the hard drive. If you want to download a file from the internet you would have to use the HTTP Request-Node

Veer_Manhas · February 12, 2021, 1:41pm

Got it, so I got it use HTTP node to download and then use Spreadsheet node correct?

jan · February 12, 2021, 1:50pm

Yes exactly. But make sure that you use the same “Property Name”. Best have it set to data on both.

Veer_Manhas · February 12, 2021, 2:03pm

Thanks a ton!! This is helpful. I am just jumping into n8n and it looks promising. I remember when you guys released on PH, I released a similar product but specific to AWS. Just got a chance to start using n8n. Power to you!