# Mass creation of Tags and Alarms in xml

**URL:** <https://forum.inductiveautomation.com/t/mass-creation-of-tags-and-alarms-in-xml/17310>\
**Category:** General Discussion\
**Tags:** ignition79, database\
**Created:** [March 10, 2018, 6:18am UTC](https://forum.inductiveautomation.com/t/mass-creation-of-tags-and-alarms-in-xml/17310 "2018-03-10T06:18:28Z")\
**Posts on this page:** 1\
**Showing post:** 21

<div class="post-metadata">

**Author:** ![R.Alamsha](https://avatars.discourse-cdn.com/v4/letter/r/e5b9ba/32.png) [@R.Alamsha](https://forum.inductiveautomation.com/u/R.Alamsha)\
**Post date:** [March 12, 2018, 12:19pm UTC](https://forum.inductiveautomation.com/t/mass-creation-of-tags-and-alarms-in-xml/17310/21 "2018-03-12T12:19:03Z")

</div>

> [@David.Reed.Schmidt](#):
>
> Once you dive into and succeed then this becomes an imporant part of your toolbag.

I found this technique very interesting for converting large amount of Tags and Alarms into Ignition compatible xml file. I found this idea in youtube just few hours back and still experimenting. I thought, i will post it here immediately so that you can also try and share your experience. Cheers 🙂

1. First, we have to create an XML schema xsd file. Schema is our template.
2. In Ignition, basically we can create UDTs and 5 different types of tags.
3. Create some sample tags (or UDTs) under each type, export as xml and save it as .xsd schema file . Let's say, we have 6 sample schemas.
4. Classify your csv list of tags and alarms which needs to be converted as xml, into 6 types as per your 6 schemas. Save it into 6 Excel sheets.
5. Now, you have to just map your Tags and Alarms in Excel sheets with the respective schema.
6. Watch these videos and dig deeper.

**Convert Excel Spreadsheet data to XML**

[![](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/4/141ddfbdad99867a3406a42c62aabd3f31523fa3.jpeg "Convert Excel Spreadsheet data to XML") ](https://www.youtube.com/watch?v=9bat12gH3Qs)

**Converting XLS to XML**

[![](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/4/448e46d10e1474b97ee3b0f86023223af8f1a62c.jpeg "Converting XLS to XML - Tutorial (Excel spreadsheet to XML)") ](https://www.youtube.com/watch?v=bw-ZetSBQCU)

**Converting data from Excel to XML Template**

[![](https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/7/8754bb88b71d2fd4b6307fc580452c9ab57d3999.jpeg "Converting data from Excel to XML Template") ](https://www.youtube.com/watch?v=37TH0QdrfE4)

**Import & export XML data, XML maps and schema in exce**

[![](https://us1.discourse-cdn.com/inductiveautomation/original/3X/e/d/edead84d2b5d3abbdc7ab2f4d93e2af49f0d189d.jpeg "Import & export XML data, XML maps and schema in excel") ](https://www.youtube.com/watch?v=f5O75Y0DYjk)

---

_[View the full topic](https://forum.inductiveautomation.com/t/mass-creation-of-tags-and-alarms-in-xml/17310)._