# Dataset via OPC UA Exposed Tags **URL:** \ **Category:** Ignition\ **Created:** [August 23, 2022, 9:59pm UTC](https://forum.inductiveautomation.com/t/dataset-via-opc-ua-exposed-tags/63363 "2022-08-23T21:59:17Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![Tony\_DiBattista](https://avatars.discourse-cdn.com/v4/letter/t/c2a13f/32.png) [@Tony\_DiBattista](https://forum.inductiveautomation.com/u/Tony_DiBattista)\ **Post date:** [August 23, 2022, 9:59pm UTC](https://forum.inductiveautomation.com/t/dataset-via-opc-ua-exposed-tags/63363/1 "2022-08-23T21:59:17Z")
Hi Kevin, is there a trick to get my memory tags to show up in the opc client? It shows all the other tags except for the memory tag dataset. ---
**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\ **Post date:** [August 23, 2022, 10:03pm UTC](https://forum.inductiveautomation.com/t/dataset-via-opc-ua-exposed-tags/63363/2 "2022-08-23T22:03:26Z")
I assume you’re talking about an OPC UA connection to another Ignition that is exposing its tags over OPC UA. Datasets don’t have a corresponding OPC UA datatype and so they are not mapped/exposed to OPC UA clients. ---
**Author:** ![Tony\_DiBattista](https://avatars.discourse-cdn.com/v4/letter/t/c2a13f/32.png) [@Tony\_DiBattista](https://forum.inductiveautomation.com/u/Tony_DiBattista)\ **Post date:** [August 23, 2022, 10:05pm UTC](https://forum.inductiveautomation.com/t/dataset-via-opc-ua-exposed-tags/63363/3 "2022-08-23T22:05:53Z")
darn, I’m just trying to get the string tag values to show in excel so we can easily edit several thousand at once, any suggestions? ---
**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\ **Post date:** [August 23, 2022, 10:07pm UTC](https://forum.inductiveautomation.com/t/dataset-via-opc-ua-exposed-tags/63363/4 "2022-08-23T22:07:13Z")
I’m not really following what you’re trying to do… how does getting some tag values into Excel have anything to do with OPC UA? ---
**Author:** ![Tony\_DiBattista](https://avatars.discourse-cdn.com/v4/letter/t/c2a13f/32.png) [@Tony\_DiBattista](https://forum.inductiveautomation.com/u/Tony_DiBattista)\ **Post date:** [August 23, 2022, 10:18pm UTC](https://forum.inductiveautomation.com/t/dataset-via-opc-ua-exposed-tags/63363/5 "2022-08-23T22:18:58Z")
the opc ua expert program can easily link opc ua tags to excel so we can easily change the values. I’ve been doing this for 25 years with RSlinx and PLC string tags on the other HMI platforms, but for this project others decided to use ignition memory string tags instead of plc tags. My initial thought was to just export the ignition database to a csv file and edit the values that way, but ignition removed the export to csv function in ver 8 for some strange reason, and editing the xml and json files in a table format is beyond my experience? ---
**Author:** ![Tony\_DiBattista](https://avatars.discourse-cdn.com/v4/letter/t/c2a13f/32.png) [@Tony\_DiBattista](https://forum.inductiveautomation.com/u/Tony_DiBattista)\ **Post date:** [August 23, 2022, 10:30pm UTC](https://forum.inductiveautomation.com/t/dataset-via-opc-ua-exposed-tags/63363/6 "2022-08-23T22:30:19Z")
thx for answering my question. Can you do me a favor and just delete my screen caps from this post, I didn’t realize they showed the client name, I dont’ think they’ll care, but just in case. thx. ---
**Author:** ![Tony\_DiBattista](https://avatars.discourse-cdn.com/v4/letter/t/c2a13f/32.png) [@Tony\_DiBattista](https://forum.inductiveautomation.com/u/Tony_DiBattista)\ **Post date:** [August 23, 2022, 10:31pm UTC](https://forum.inductiveautomation.com/t/dataset-via-opc-ua-exposed-tags/63363/7 "2022-08-23T22:31:34Z")
nvm, got it, thx. ---
**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\ **Post date:** [August 23, 2022, 10:39pm UTC](https://forum.inductiveautomation.com/t/dataset-via-opc-ua-exposed-tags/63363/8 "2022-08-23T22:39:16Z")
If the data you want is already in a dataset it should be pretty easy to get into CSV using Ignition: [Exporting and Importing a CSV - Ignition User Manual 8.1 - Ignition Documentation](https://docs.inductiveautomation.com/display/DOC81/Exporting+and+Importing+a+CSV) ---
**Author:** ![jlandwerlen](https://avatars.discourse-cdn.com/v4/letter/j/bc8723/32.png) [@jlandwerlen](https://forum.inductiveautomation.com/u/jlandwerlen)\ **Post date:** [August 24, 2022, 12:30pm UTC](https://forum.inductiveautomation.com/t/dataset-via-opc-ua-exposed-tags/63363/9 "2022-08-24T12:30:56Z")
For dataset tags just copy to clipboard, then paste into Excel (or notepad, etc.). After you make your edits in Excel, copy from Excel and paste from clipboard. When you open the dataset you will see controls on the right, bottom two buttons. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/5/550783e9e6f18ab7e61816af9a5e2acb3a003b9e.png) Example dataset copied (you should only need to change the row count and then the rows themselves, assuming you had a valid dataset to copy from): ```auto "#NAMES" "ID","Name" "#TYPES" "I","str" "#ROWS","2" "1","Test" "2","Something" ``` ---
**Author:** ![jlandwerlen](https://avatars.discourse-cdn.com/v4/letter/j/bc8723/32.png) [@jlandwerlen](https://forum.inductiveautomation.com/u/jlandwerlen)\ **Post date:** [August 24, 2022, 12:32pm UTC](https://forum.inductiveautomation.com/t/dataset-via-opc-ua-exposed-tags/63363/10 "2022-08-24T12:32:35Z")
> [@Tony\_DiBattista](#): > > delete my screen caps from this post FYI, when you edit a post, users can still see the old content. If you truly want them deleted you will need to reach out to IA. ---
**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\ **Post date:** [August 24, 2022, 12:36pm UTC](https://forum.inductiveautomation.com/t/dataset-via-opc-ua-exposed-tags/63363/11 "2022-08-24T12:36:27Z")
> [@jlandwerlen](#): > > If you truly want them deleted you will need to reach out to IA. I just hid the revision, he should be good to go now.