# Json to Excel

**URL:** <https://community.integray.com/t/json-to-excel/180>\
**Category:** Platform discussions\
**Tags:** connector\
**Created:** [October 17, 2023, 10:17am UTC](https://community.integray.com/t/json-to-excel/180 "2023-10-17T10:17:21Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Filip](https://avatars.discourse-cdn.com/v4/letter/f/919ad9/32.png) [@Filip](https://community.integray.com/u/Filip)\
**Post date:** [October 17, 2023, 10:17am UTC](https://community.integray.com/t/json-to-excel/180/1 "2023-10-17T10:17:21Z")

</div>

Hi, i have problem with Excel Serializer v3.2.0, I define name of sheet in first step, and when task gets to 3rd step error message occures : Input does not contain column ‘SHEET1’ with sheet names.

 ![image](https://europe1.discourse-cdn.com/flex017/uploads/integray/original/1X/4b8054c346b469c4dceb53a0a31fd3996c3408e1.png)  
But in first step, is this JSON where is the column name defined.  
 ![image](https://europe1.discourse-cdn.com/flex017/uploads/integray/original/1X/a9f3bc1a4860ada2f9f8a859ea4caca1bedca55d.jpeg)  
Between this two steps is Json To Excel Converter (v 3.0.4)

---

<div class="post-metadata">

**Author:** ![tomas](https://avatars.discourse-cdn.com/v4/letter/t/439d5e/32.png) [@tomas](https://community.integray.com/u/tomas)\
**Post date:** [October 17, 2023, 4:31pm UTC](https://community.integray.com/t/json-to-excel/180/2 "2023-10-17T16:31:05Z")

</div>

Hi Filip,

you are mixing two connectors. There are two ways how to get data into Excel:

**Excel serialiser**

Here you have to provide flat data schema with data and configure it based on manual here: [Excel serializer - Help center](https://learn.integray.app/connectoracademy/connectors/ExcelSerializer/3.2/)

Second option is to use

**JSON to Excel**

Here you have to specify special JSON with structure you have on your picture and then send it to JSON to Excel connector: [JSON to Excel converter - Help center](https://learn.integray.app/connectoracademy/connectors/JsonToExcelConverter/3.0/)

Regards, Tomas.

---

<div class="post-metadata">

**Author:** ![Filip](https://avatars.discourse-cdn.com/v4/letter/f/919ad9/32.png) [@Filip](https://community.integray.com/u/Filip)\
**Post date:** [October 18, 2023, 12:10pm UTC](https://community.integray.com/t/json-to-excel/180/3 "2023-10-18T12:10:19Z")

</div>

Thanks, I have another problem, what does mean "file"scheme in this configuration?

 ![image](https://europe1.discourse-cdn.com/flex017/uploads/integray/original/1X/0975e27e78160fa058dca662e5478621501e6de1.jpeg)  
 ![image](https://europe1.discourse-cdn.com/flex017/uploads/integray/original/1X/76bd39849c4e57c300337795b9236388c8644553.jpeg)

---

<div class="post-metadata">

**Author:** ![tomas](https://avatars.discourse-cdn.com/v4/letter/t/439d5e/32.png) [@tomas](https://community.integray.com/u/tomas)\
**Post date:** [October 18, 2023, 4:46pm UTC](https://community.integray.com/t/json-to-excel/180/4 "2023-10-18T16:46:49Z")

</div>

Hi,

without seeing configuration schema I can’t help. @Filip

Tomas.

---

<div class="post-metadata">

**Author:** ![Filip](https://avatars.discourse-cdn.com/v4/letter/f/919ad9/32.png) [@Filip](https://community.integray.com/u/Filip)\
**Post date:** [October 19, 2023, 8:56am UTC](https://community.integray.com/t/json-to-excel/180/5 "2023-10-19T08:56:40Z")

</div>

HI, here it is

 ![image](https://europe1.discourse-cdn.com/flex017/uploads/integray/original/1X/66090553fc605e4ed2e9e30a047ad84d86750cf7.jpeg)

STEP 1:  
`const obj = {  
“Sheets”: [  
{  
“Name”: “First sheet”,  
“DisplayHeader”: true,  
“Columns”: [  
{  
“Name”: “ID”,  
“DataType”: “int”  
},  
{  
“Name”: “Name”,  
“DataType”: “string”  
},  
{  
“Name”: “Created”,  
“DataType”: “datetime”,  
“Format”: “MM/dd/yyyy”  
},  
{  
“Name”: “IsActive”,  
“DataType”: “bool”  
},  
{  
“Name”: “Score”,  
“DataType”: “double”  
},  
{  
“Name”: “Formula”,  
“DataType”: “formula”,  
“Format”: “General”  
}  
],  
“Rows”: [  
[  
1,  
“Jan”,  
“2020-12-08T15:37:00Z”,  
true,  
3.7,  
“A2+E2”  
],  
[  
2,  
“Petr”,  
“2021-12-08T15:37:00Z”,  
false,  
1.23,  
“A3+E3”  
]  
]  
}  
]  
}

return [{“JSON”: JSON.stringify(obj)}];`

 ![image](https://europe1.discourse-cdn.com/flex017/uploads/integray/original/1X/45f119d9b5ede51a456e22409c039648eb5f97ff.png)  
 ![image](https://europe1.discourse-cdn.com/flex017/uploads/integray/original/1X/41f5964b6605555e47564991061cf78fed2643a0.jpeg)  
 ![Screenshot 2023-10-19 at 10.53.08](https://europe1.discourse-cdn.com/flex017/uploads/integray/original/1X/6551bc0e00a394f5c3518b79b275a5b7247c7a4f.png)

---

<div class="post-metadata">

**Author:** ![tomas](https://avatars.discourse-cdn.com/v4/letter/t/439d5e/32.png) [@tomas](https://community.integray.com/u/tomas)\
**Post date:** [October 19, 2023, 11:21am UTC](https://community.integray.com/t/json-to-excel/180/6 "2023-10-19T11:21:44Z")

</div>

Hi,

This looks like a problem with Microsoft email connector. Please follow with @hana.foltynova and register defect for this issue.

Tomas.

---

<div class="post-metadata">

**Author:** ![system](https://avatars.discourse-cdn.com/v4/letter/s/bcef8e/32.png) [@system](https://community.integray.com/u/system)\
**Post date:** [October 26, 2023, 11:21am UTC](https://community.integray.com/t/json-to-excel/180/7 "2023-10-26T11:21:56Z")

</div>

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