# Excel file to mySQL

**URL:** <https://discourse.nodered.org/t/excel-file-to-mysql/30283>\
**Category:** General\
**Created:** [18 July 2020 05:40 UTC](https://discourse.nodered.org/t/excel-file-to-mysql/30283 "2020-07-18T05:40:11Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![janvda](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/janvda/32/234_2.png) [@janvda](https://discourse.nodered.org/u/janvda)\
**Post date:** [18 July 2020 11:48 UTC](https://discourse.nodered.org/t/excel-file-to-mysql/30283/3 "2020-07-18T11:48:48Z")

</div>

> [@AK51](#):
>
> Is it feasible to insert 1000 rows into the mysql table?

I have not yet done so, but I would expect that it is feasible to insert 1000 rows in a single mysql statement.

To do so, I would direct the json output of the `node-red-contrib-spreadsheet-in` to a change node that has a jsonata query that is creating your [multiple record sql insert statement](https://www.mysqltutorial.org/mysql-insert-multiple-rows/)

Take care that `node-red-contrib-spreadsheet-in` might produce a "sparse array" in case the excel has blank cells and a "sparse array" is not proper json (so this might give unexpected results when using jsonata query). You can convert it to proper json by directing the output to 2 json nodes in series. For more details see also this topic: [Weird behaviour when processing an array of arrays having null values](https://discourse.nodered.org/t/weird-behaviour-when-processing-an-array-of-arrays-having-null-values/28615)

---

_[View the full topic](https://discourse.nodered.org/t/excel-file-to-mysql/30283)._