# Problem reading csv file with quotes

**URL:** <https://discourse.nodered.org/t/problem-reading-csv-file-with-quotes/28709>\
**Category:** General\
**Created:** [22 June 2020 04:52 UTC](https://discourse.nodered.org/t/problem-reading-csv-file-with-quotes/28709 "2020-06-22T04:52:23Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![mikeh](https://avatars.discourse-cdn.com/v4/letter/m/258eb7/32.png) [@mikeh](https://discourse.nodered.org/u/mikeh)\
**Post date:** [22 June 2020 04:52 UTC](https://discourse.nodered.org/t/problem-reading-csv-file-with-quotes/28709/1 "2020-06-22T04:52:23Z")

</div>

My CSV file contains these kind of information in one column "FS Peru, IL"  
Somehow the csv node is not reading it properly.  
How can I fix this please so the csv node will also read quotes as one column and not 2?

---

<div class="post-metadata">

**Author:** ![dceejay](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dceejay/32/38_2.png) [@dceejay](https://discourse.nodered.org/u/dceejay)\
**Post date:** [22 June 2020 06:12 UTC](https://discourse.nodered.org/t/problem-reading-csv-file-with-quotes/28709/2 "2020-06-22T06:12:54Z")

</div>

Can you share at least a few lines of the file so we can test. Thanks

---

<div class="post-metadata">

**Author:** ![mikeh](https://avatars.discourse-cdn.com/v4/letter/m/258eb7/32.png) [@mikeh](https://discourse.nodered.org/u/mikeh)\
**Post date:** [22 June 2020 06:36 UTC](https://discourse.nodered.org/t/problem-reading-csv-file-with-quotes/28709/3 "2020-06-22T06:36:23Z")

</div>

@dceejay I found the problem. When the csv is exported from excel it creates problem with the csv node reading the quotes, though when I use the fastcsv it reads it properly.

---

<div class="post-metadata">

**Author:** ![mikeh](https://avatars.discourse-cdn.com/v4/letter/m/258eb7/32.png) [@mikeh](https://discourse.nodered.org/u/mikeh)\
**Post date:** [22 June 2020 06:37 UTC](https://discourse.nodered.org/t/problem-reading-csv-file-with-quotes/28709/4 "2020-06-22T06:37:19Z")

</div>

When the CSV is created from scratch and not from excel the csv node works without problem. weird.

---

<div class="post-metadata">

**Author:** ![dceejay](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dceejay/32/38_2.png) [@dceejay](https://discourse.nodered.org/u/dceejay)\
**Post date:** [22 June 2020 06:39 UTC](https://discourse.nodered.org/t/problem-reading-csv-file-with-quotes/28709/5 "2020-06-22T06:39:20Z")

</div>

Well we still can't investigate/fix it without an example.

---

<div class="post-metadata">

**Author:** ![dceejay](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dceejay/32/38_2.png) [@dceejay](https://discourse.nodered.org/u/dceejay)\
**Post date:** [22 June 2020 08:09 UTC](https://discourse.nodered.org/t/problem-reading-csv-file-with-quotes/28709/6 "2020-06-22T08:09:26Z")

</div>

A simple test with a csv exported from Excel works just fine

[test.txt](https://discourse.nodered.org/uploads/short-url/kNXTpgqyKNSJA4TTSWCt5vBOdyU.txt) (92 Bytes)

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [21 August 2020 08:09 UTC](https://discourse.nodered.org/t/problem-reading-csv-file-with-quotes/28709/7 "2020-08-21T08:09:32Z")

</div>

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