# Read a CSV File

**URL:** <https://community.n8n.io/t/read-a-csv-file/106>\
**Category:** Questions\
**Created:** [October 9, 2019, 1:23pm UTC](https://community.n8n.io/t/read-a-csv-file/106 "2019-10-09T13:23:03Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![nittanygeek](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/nittanygeek/32/79_2.png) [@nittanygeek](https://community.n8n.io/u/nittanygeek)\
**Post date:** [October 9, 2019, 1:23pm UTC](https://community.n8n.io/t/read-a-csv-file/106/1 "2019-10-09T13:23:03Z")

</div>

Any way to read a basic CSV file?

---

<div class="post-metadata">

**Author:** ![jan](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/jan/32/9_2.png) [@jan](https://community.n8n.io/u/jan)\
**Post date:** [October 9, 2019, 1:41pm UTC](https://community.n8n.io/t/read-a-csv-file/106/2 "2019-10-09T13:41:23Z")

</div>

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

Here an example:

---

<div class="post-metadata">

**Author:** ![nittanygeek](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/nittanygeek/32/79_2.png) [@nittanygeek](https://community.n8n.io/u/nittanygeek)\
**Post date:** [October 9, 2019, 5:15pm UTC](https://community.n8n.io/t/read-a-csv-file/106/3 "2019-10-09T17:15:16Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![jan](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/jan/32/9_2.png) [@jan](https://community.n8n.io/u/jan)\
**Post date:** [October 9, 2019, 5:27pm UTC](https://community.n8n.io/t/read-a-csv-file/106/4 "2019-10-09T17:27:07Z")

</div>

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](https://n8n.io/nodes/n8n-nodes-base.readBinaryFile)

---

<div class="post-metadata">

**Author:** ![nittanygeek](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/nittanygeek/32/79_2.png) [@nittanygeek](https://community.n8n.io/u/nittanygeek)\
**Post date:** [October 9, 2019, 8:20pm UTC](https://community.n8n.io/t/read-a-csv-file/106/5 "2019-10-09T20:20:52Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![jan](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/jan/32/9_2.png) [@jan](https://community.n8n.io/u/jan)\
**Post date:** [October 9, 2019, 8:30pm UTC](https://community.n8n.io/t/read-a-csv-file/106/6 "2019-10-09T20:30:27Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Veer\_Manhas](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/veer_manhas/32/3427_2.png) [@Veer\_Manhas](https://community.n8n.io/u/Veer_Manhas)\
**Post date:** [February 12, 2021, 1:09pm UTC](https://community.n8n.io/t/read-a-csv-file/106/7 "2021-02-12T13:09:27Z")

</div>

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

 ![image](https://europe1.discourse-cdn.com/n8n/original/2X/f/fb3e25f4689eaf5634e0bc12d801781d8ba3f39c.png)

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?

---

<div class="post-metadata">

**Author:** ![jan](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/jan/32/9_2.png) [@jan](https://community.n8n.io/u/jan)\
**Post date:** [February 12, 2021, 1:25pm UTC](https://community.n8n.io/t/read-a-csv-file/106/8 "2021-02-12T13:25:48Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Veer\_Manhas](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/veer_manhas/32/3427_2.png) [@Veer\_Manhas](https://community.n8n.io/u/Veer_Manhas)\
**Post date:** [February 12, 2021, 1:41pm UTC](https://community.n8n.io/t/read-a-csv-file/106/9 "2021-02-12T13:41:34Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![jan](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/jan/32/9_2.png) [@jan](https://community.n8n.io/u/jan)\
**Post date:** [February 12, 2021, 1:50pm UTC](https://community.n8n.io/t/read-a-csv-file/106/10 "2021-02-12T13:50:50Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Veer\_Manhas](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/veer_manhas/32/3427_2.png) [@Veer\_Manhas](https://community.n8n.io/u/Veer_Manhas)\
**Post date:** [February 12, 2021, 2:03pm UTC](https://community.n8n.io/t/read-a-csv-file/106/11 "2021-02-12T14:03:18Z")

</div>

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!
