# Appending columns to existing excel file

**URL:** <https://forum.knime.com/t/appending-columns-to-existing-excel-file/21506>\
**Category:** KNIME Analytics Platform\
**Created:** [March 3, 2020, 8:31am UTC](https://forum.knime.com/t/appending-columns-to-existing-excel-file/21506 "2020-03-03T08:31:12Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![jinbaba](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/j/b38774/32.png) [@jinbaba](https://forum.knime.com/u/jinbaba)\
**Post date:** [March 3, 2020, 8:31am UTC](https://forum.knime.com/t/appending-columns-to-existing-excel-file/21506/1 "2020-03-03T08:31:12Z")

</div>

I have a master table [excel file saved on my computer- let’s call this file 1]:

Column A , Column B, Column C

To this i want to add information from another file - file 2… which has the same column headers

how do i go about it? any ideas.

---

<div class="post-metadata">

**Author:** ![ipazin](https://forum-cdn.knime.com/user_avatar/forum.knime.com/ipazin/32/806_2.png) [@ipazin](https://forum.knime.com/u/ipazin)\
**Post date:** [March 3, 2020, 8:42am UTC](https://forum.knime.com/t/appending-columns-to-existing-excel-file/21506/2 "2020-03-03T08:42:44Z")

</div>

Hi there @jinbaba,

so you would like to concatenate data from 2 Excel files? In that case you need to read both files in KNIME, use [Concatenate](https://kni.me/n/0rhLXWO6OS1xMi8T) node and write data back to Excel file.

Otherwise if you would only like to read one file and update another Python would probably be a way to go. See this topic: (there are also similar ones so it is worth searching forum)

> [@Append data from 3 DB query reader to 3 different tabs in XLSX](https://forum.knime.com/t/append-data-from-3-db-query-reader-to-3-different-tabs-in-xlsx/20686):
>
> Hello team, I am reading data using 3 queries in 3 different Query reader. I have one excel file with raw data as output. Everyday, this file has to be updated with new data from prior day. I have output from 3 DB Query Reader. I used “Excel Shee Appender” but it wipes out existing tab and creates new one (basically replaces a tab), instead of “Append” to the last row… I saw several posts that says, there is no “APPEND” feature with existing data. I have to write to 3 different tabs. New to…

Br,  
Ivan

---

<div class="post-metadata">

**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\
**Post date:** [September 1, 2020, 8:42pm UTC](https://forum.knime.com/t/appending-columns-to-existing-excel-file/21506/3 "2020-09-01T20:42:46Z")

</div>

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