# CSV import to MySQL

**URL:** <https://forum.inductiveautomation.com/t/csv-import-to-mysql/14160>\
**Category:** General Discussion\
**Created:** [April 28, 2017, 4:14am UTC](https://forum.inductiveautomation.com/t/csv-import-to-mysql/14160 "2017-04-28T04:14:28Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Curlyandshemp](https://avatars.discourse-cdn.com/v4/letter/c/bcef8e/32.png) [@Curlyandshemp](https://forum.inductiveautomation.com/u/Curlyandshemp)\
**Post date:** [April 28, 2017, 4:14am UTC](https://forum.inductiveautomation.com/t/csv-import-to-mysql/14160/1 "2017-04-28T04:14:28Z")

</div>

Been struggling getting a foreign database data exported to a CSV imported into Ignition to store into MySQL tables. Issue I am having is there are 1000s of records to import, and going through each record to insert " " is not practical to format the data so the system.dataset.fromCSV(data\_string) script function works properly.

 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/a/a7ddbbd28cdbc590cab9a21a0825b30d65075656.png)

Doing a little digging I came across the Add In for MySQL

![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/b/b7d1d084675582446076d2cecf75d360bdf0ce10.png)

This will allow for any Excel file to be imported directly into a MySQL table.

 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/2/2d6f2090de23f1a6d806c288dfa4c3f81ebb454d.png)

I had the customer’s IT guy save the exported data as an \*.XLS file , and using this utility imported 1000s of records into MySQL in minutes without using any script.