In Today’s article I’ll walk you through how you can bring Allen-Bradley Programmable Controller Data into Microsoft Excel 2016 using RSLinx Classic.

NOTE: The below procedure works with any licensed copy of RSLinx Classic, including Single Node, OEM, and Gateway shown below. However, it will not work with the free “Lite” version.

Step 1) Locate the Programmable Controller you’d like to get data from in the RSLinx Classic RSWho window, then right click on it and choose, “Configure New DDE/OPC Topic” as shown below:

Step 2) Now give your Topic a name. In this example I name my new topic “L61”:

Step 3) Next, select the Data Collection tab and review the default settings:

Step 4) When done reviewing the default settings and making any changes, click on the Apply button. Note that in this example I changed the Polled Message rate from 1000ms to 50ms:

Step 5) When prompted, select Yes to update the topic with your changes:

Step 6) Now select Done to close the Topic Configuration window:

Step 7) Now from the Edit menu (only available in licensed versions of RSLinx Classic as noted previously,) select Copy DDE/OPC Link…

Step 8) Then browse for the address or tag whose value you’d like to display in Microsoft Excel:

Step 9) And click on OK when done:

Step 10) Now in Excel, right click on the cell where you’d like the data to appear and select Paste Special:

Step 11) Then choose Paste Link:

Step 12) And select OK:

Step 13) At first you may see “#N/A” as the data is being fetched from RSLinx:

Step 15) However, after a few seconds you should see you Programmable Controller’s live data appear:

Step 16) This procedure works for ControlLogix, CompactLogix, PLC-5, SLC-500, and MicroLogix as shown below:

Step 17) If you’d also like to learn how to create a button to upload or download many tag values, search RSLinx Classic’s Help on the word “Excel” for example macros:

To watch a video demonstration of the above, check out Episode 41 of The Automation Minute Season 4 below:


If you found this article helpful, please share it with your colleagues on LinkedIn, Facebook, Twitter or Goggle Plus!

And if you know anyone who would benefit from Allen-Bradley PLC, HMI, or SCADA training, please let them know about my affordable courses over at TheAutomation School.

You can also share your own thoughts and opinions on this subject by clicking on the “post a comment or question” link below.

Until next time, Peace ✌️ 

Shawn M Tierney
Technology Enthusiast & Content Creator

Have a question? Join my community of automation professionals and take part in the discussion! You'll also find my PLC, HMI, and SCADA courses at TheAutomationSchool.com.

If you found this content helpful, consider buying me a coffee here.

Shawn Tierney
Latest posts by Shawn Tierney (see all)

(5,613 views)

RELATED ARTICLESMORE FROM AUTHOR

6 COMMENTS

  1. Hello. i have a question, is this possible with Micro820 and ML1200? I dont identify el Processor Type for this PLC

  2. Good morning,

    Your question is in broken English, but I believe you’re asking if this procedure works with all A-B PLCs, and it does as long as you have the software described.

    Sincerely,

    Shawn

  3. Hello, I was wondering why in the menu to add a topic in the processor type bar I cannot identify which of the multiple options corresponds to a Micro820 and an ML1200 PLC, then I wasn’t sure if these PLCs are compatible for this process.

    • I have no idea where that spreadsheet from 2018 is, but in the video (3:32 to 3:47) you can see every topic since I just copy and paste the first one and then edit it for each plc.

      Shawn

LEAVE A REPLY

Please enter your comment!
Please enter your name here