Logging Data from a Siemens PLC into Excel

[JBird1229]

Hey guys,

 

I know this is a topic that has been discussed before, but I am having trouble finding exactly what I am looking for..

I want to know the most efficient way to record data from my PLC to an Excel file on my PC. I want this to be done without the use of the PLC's webserver. 

Specifically I am trying to record vfd speed every 10seconds with a time and date stamp.

How can I do this?

 

Thanks,

James

 

[TravisPedley]

Kepware and an excel logger.  

we have used XLReporter from Sytech, should work fine for what you want.  

Could also use a Redlion DataStation Plus to do it as well, probably easier to set up and the software is free (the hardware isn't but it is cheaper than Kepware and XLReporter).

 

[Mark-]

Hi,

PeakHMI might be a good fit and cost a bit less.

 

[pop29684]

Any OPC server would probably work. I've been told that it adds no extra burden to the processing time of the CPU but I have not verified this.

[progpro]

You could probably use 'S7 Excel Connect' for live and logging data in Excel without the use of the webserver or other third pary software.

Edited March 25, 2022 by progpro