How to Import Excel Tags into a Unity Pro PLC Project

Claire Rousseau2 min read
Schneider ElectricTutorial / How-toUnity Pro
Licensed PE Working through this on a live machine? A Maine-licensed engineer can take it from here — included with IMD hardware, by the hour for everything else. Book an engineer

Use Unity Pro’s own text export as the import template. Export existing variables, open the resulting text file in Excel, reshape the Wonderware tag list to match that structure, and import it through Variables and FB Instances. The evidence identifies Unity Pro only as an assumption, so confirm the engineering software before proceeding.

Confirm the Target Engineering Software

The documented workflow applies when the PLC project uses Unity Pro. If the project uses different software, stop and obtain its native variable-import procedure; the required file structure and import command are not established by the available evidence.

Item Evidence status Engineering decision
PLC software Unity Pro is presumed, not confirmed Verify the actual project software
Reference format Text export from selected project variables Use the project’s export as the template
Source data Tags generated for Wonderware HMI Restructure them to match the Unity Pro export
Import location Variables and FB Instances Right-click this project node and select the import command

Create a Unity Pro Import Template

Select representative variables in the element browser and choose Export Selected. Select text format, then open the exported file in Excel. This reveals the column order and text structure expected by the current project without guessing field names, separators, or optional attributes.

Preserve the exported structure when transferring the Wonderware tags. The evidence does not specify delimiter rules, required columns, data-type syntax, or Unity Pro version behavior, so derive those details directly from the generated export file.

Import the Prepared Tag List

  1. Export selected existing variables from the element browser in text format.
  2. Open the exported text file in Excel and use its structure as the template.
  3. Place the Wonderware tag data into the corresponding template structure without inventing unsupported fields.
  4. Save the completed data in the text-file structure used by the export.
  5. Right-click Variables and FB Instances and run the import command.

Verify the Imported Variables

After import, inspect the resulting entries under Variables and FB Instances. Confirm that the imported names and available attributes match both the prepared file and the intended PLC program references. If the import rejects the file or produces shifted fields, compare it directly with an untouched Unity Pro export and correct the structural mismatch before retrying.

FAQ

How do I import Excel tags into Unity Pro?

Export selected variables from the element browser in text format, open that file in Excel, populate it with the required tags, then right-click Variables and FB Instances and import it.

Can Unity Pro import a Wonderware tag list directly?

Direct compatibility is not established by the evidence. First reshape the Wonderware data to match a text file exported by Unity Pro.

How do I find the correct Unity Pro tag import format?

Select existing variables, use Export Selected, choose text format, and open the result in Excel. Treat that exported structure as the authoritative template for the project.

Back to blog