# How to insert data in csv in predetermined position

**URL:** <https://discourse.nodered.org/t/how-to-insert-data-in-csv-in-predetermined-position/64589>\
**Category:** General\
**Created:** [1 July 2022 14:15 UTC](https://discourse.nodered.org/t/how-to-insert-data-in-csv-in-predetermined-position/64589 "2022-07-01T14:15:37Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![nenny](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/nenny/32/64086_2.png) [@nenny](https://discourse.nodered.org/u/nenny)\
**Post date:** [1 July 2022 14:15 UTC](https://discourse.nodered.org/t/how-to-insert-data-in-csv-in-predetermined-position/64589/1 "2022-07-01T14:15:37Z")

</div>

Hello,  
I am trying to figure out how i can insert data in a specific position of a csv file (example in column C row 5). Unfortunately i am not really getting anywhere with this if anyone can help me or point me into the correct direction it would be really appreciated

---

<div class="post-metadata">

**Author:** ![E1cid](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/e1cid/32/77971_2.png) [@E1cid](https://discourse.nodered.org/u/E1cid)\
**Post date:** [1 July 2022 14:31 UTC](https://discourse.nodered.org/t/how-to-insert-data-in-csv-in-predetermined-position/64589/2 "2022-07-01T14:31:08Z")

</div>

You would read the csv file, then pass it through a csv node. Then insert the data at `msg.payload[4].col3`, depending on column names you may use. Then pass back through a csv node to create new csv file. Finally you would resave the file.

---

<div class="post-metadata">

**Author:** ![nenny](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/nenny/32/64086_2.png) [@nenny](https://discourse.nodered.org/u/nenny)\
**Post date:** [1 July 2022 14:47 UTC](https://discourse.nodered.org/t/how-to-insert-data-in-csv-in-predetermined-position/64589/3 "2022-07-01T14:47:16Z")

</div>

Thank you so much for help

---

<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:** [30 August 2022 14:47 UTC](https://discourse.nodered.org/t/how-to-insert-data-in-csv-in-predetermined-position/64589/4 "2022-08-30T14:47:49Z")

</div>

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