# Import Data from Excel Spreadsheet to XML table

**URL:** <https://forum.inductiveautomation.com/t/import-data-from-excel-spreadsheet-to-xml-table/8234>\
**Category:** Ignition\
**Created:** [March 29, 2014, 6:25pm UTC](https://forum.inductiveautomation.com/t/import-data-from-excel-spreadsheet-to-xml-table/8234 "2014-03-29T18:25:49Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![wwegner](https://avatars.discourse-cdn.com/v4/letter/w/f07891/32.png) [@wwegner](https://forum.inductiveautomation.com/u/wwegner)\
**Post date:** [March 29, 2014, 6:25pm UTC](https://forum.inductiveautomation.com/t/import-data-from-excel-spreadsheet-to-xml-table/8234/1 "2014-03-29T18:25:49Z")

</div>

I exported my SQLTag file to XML so that I could edit multiple alarm tags at one time.

However, I have hundreds of alarm tags that I need to update the ‘notes’ section of. Is there a way I can take the data from my excel spreadsheet that already has the new ‘notes’ dialog into my XML file?

I could go through and do this manually (copy and paste into each one) but I have hundreds, if not thousands, that I would need to change.

Thanks!

---

<div class="post-metadata">

**Author:** ![greg.simpson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/greg.simpson/32/3135_2.png) [@greg.simpson](https://forum.inductiveautomation.com/u/greg.simpson)\
**Post date:** [July 9, 2014, 8:27pm UTC](https://forum.inductiveautomation.com/t/import-data-from-excel-spreadsheet-to-xml-table/8234/2 "2014-07-09T20:27:24Z")

</div>

You could go the copy paste route. You could possibly use something like Sublime Text 2 and do a “Find All” “Replace All” to make this easier.

---

<div class="post-metadata">

**Author:** ![diat150](https://avatars.discourse-cdn.com/v4/letter/d/a587f6/32.png) [@diat150](https://forum.inductiveautomation.com/u/diat150)\
**Post date:** [July 9, 2014, 10:26pm UTC](https://forum.inductiveautomation.com/t/import-data-from-excel-spreadsheet-to-xml-table/8234/3 "2014-07-09T22:26:05Z")

</div>

I would make a csv file that has a column for tagpaths and a column with the notes data, if you already have that in your excel spreadsheet. you could then import that into a table in your database and use a script to write to the notes section of each tag that you have in your list.

here is an example of writing to the notes part of a tag.

```auto

note = "test"
system.tag.write('03301/CommStatus.AlertNotes',note)

```

If you need more help let me know.