# Problems with creating CSV or excel

**URL:** <https://discourse.nodered.org/t/problems-with-creating-csv-or-excel/57041>\
**Category:** General\
**Created:** [22 January 2022 08:56 UTC](https://discourse.nodered.org/t/problems-with-creating-csv-or-excel/57041 "2022-01-22T08:56:34Z")\
**Posts on this page:** 1\
**Showing post:** 9

<div class="post-metadata">

**Author:** ![smanjunath211](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/smanjunath211/32/95742_2.png) [@smanjunath211](https://discourse.nodered.org/u/smanjunath211)\
**Post date:** [23 January 2022 03:59 UTC](https://discourse.nodered.org/t/problems-with-creating-csv-or-excel/57041/9 "2022-01-23T03:59:52Z")

</div>

I did a little research and found this answer by @TotallyInformation who is also seeing this thread. may be he has some more inputs. sorry I could not help.

> [@Saving a JSON array in an excel file](https://discourse.nodered.org/t/saving-a-json-array-in-an-excel-file/1531/13):
>
> You will need to rearrange the JSON somewhat. Firstly, if you are using CSV, note that CSV files can only ever represent a single sheet. They have no concept of multiple sheets, you need multiple CSV files. You can use Excel to combine those files, especially if using newer versions of Excel. If your version of Excel has PowerQuery included then automatically combining a folder of CSV files into a single workbook is pretty easy. Even if not, it is relatively easy, especially with a bit of VBA f…

---

_[View the full topic](https://discourse.nodered.org/t/problems-with-creating-csv-or-excel/57041)._