Inst ToolsInst ToolsInst Tools
  • Courses
  • Automation
    • PLC
    • Control System
    • Safety System
    • Communication
    • Fire & Gas System
  • Instrumentation
    • Design
    • Pressure
    • Temperature
    • Flow
    • Level
    • Vibration
    • Analyzer
    • Control Valve
    • Switch
    • Calibration
    • Erection & Commissioning
  • Interview
    • Instrumentation
    • Electrical
    • Electronics
    • Practical
  • Q&A
    • Instrumentation
    • Control System
    • Electrical
    • Electronics
    • Analog Electronics
    • Digital Electronics
    • Power Electronics
    • Microprocessor
  • Request
Search
  • Books
  • Software
  • Projects
  • Process
  • Tools
  • Basics
  • Formula
  • Power Plant
  • Root Cause Analysis
  • Electrical Basics
  • Animation
  • Standards
  • 4-20 mA Course
  • Siemens PLC Course
Reading: PLC Simulator using Excel
Share
Font ResizerAa
Inst ToolsInst Tools
Font ResizerAa
  • Courses
  • Design
  • PLC
  • Interview
  • Control System
Search
  • Courses
  • Automation
    • PLC
    • Control System
    • Safety System
    • Communication
    • Fire & Gas System
  • Instrumentation
    • Design
    • Pressure
    • Temperature
    • Flow
    • Level
    • Vibration
    • Analyzer
    • Control Valve
    • Switch
    • Calibration
    • Erection & Commissioning
  • Interview
    • Instrumentation
    • Electrical
    • Electronics
    • Practical
  • Q&A
    • Instrumentation
    • Control System
    • Electrical
    • Electronics
    • Analog Electronics
    • Digital Electronics
    • Power Electronics
    • Microprocessor
  • Request
Follow US
All rights reserved. Reproduction in whole or in part without written permission is prohibited.
Inst Tools > Blog > Excel Tools > PLC Simulator using Excel

PLC Simulator using Excel

Now you can do the programmable logic controller ladder logic simulations using excel. Free download the PLC simulator now.

Last updated: September 8, 2022 1:12 pm
Editorial Staff
Excel Tools PLC Tutorials Software
No Comments
Share
3 Min Read
SHARE

Now you can do the programmable logic controller ladder logic simulations using excel. Free download the PLC simulator now.

Contents
PLC SimulatorHow to do the PLC Simulation using Excel?

Simulate your basic PLC programs using an excel file on your computer. This tool is very useful for beginners to learn and practice the programmable logic controllers ladder logic functions.

PLC Simulator

PLC Simulator using Excel

The above animation shows the simple latching circuit simulation using the ladder logic programming using an excel file.

How to do the PLC Simulation using Excel?

You have to download the PLC excel simulator file.

Open the excel file. A sample program in excel shown below

Free Download PLC Simulator using Excel

Now enable the macros in the excel file. Follow the below animation.

How to Use PLC Simulator using Excel App

Now your excel file is ready to write your own PLC program.

On the left side, you can find the empty rails and rungs.

Click on each cell where you want to add your PLC instruction.

A drop-down menu will appear, select the required PLC instruction from the menu. See the below sample PLC program.

Ladder Logic in Excel

You have to select a blank line if you don’t use the specific cell in the excel file.

Write your PLC program. Note this excel file supports only limited functions.

In the middle, you can see the IO table where you can see the details of tags, type of input, description, and the status of the inputs & outputs.

See the left-side table in the below image.

PLC Programming in Excel File

Now a small operation panel available for the users to operate some of the inputs during the running of the PLC program. See the Tag & Operate table on the top right side in the above image.

You can change the timer instruction settings from the timer table, available on the right side of the above image.

Once you are done with your PLC program editing then you have to run the PLC.

Here this PLC has two modes. One is idle and the second is running.

Click on the “Download to PLC & Run” button to start your PLC simulation.

Please note, this PLC simulator is useful for beginners who want to do some practice with the PLC ladder logic programming without the need for large software applications.

We always recommend practicing your PLC programs using any of the popular PLC software like Tia portal, Simatic manager, RS Logix 500, etc.

Source:

This simple PLC simulation software was designed by “Nitin Mehta”. Visit the engineers-excel website for more details.

If you liked this article, then please subscribe to our YouTube Channel for PLC and SCADA video tutorials.

You can also follow us on Facebook and Twitter to receive daily updates.

Read Next

  • Siemens PLC Course
  • Allen Bradley PLC Course
  • InTouch SCADA Course
  • Wincc SCADA Course
  • PLC Introduction Course
Don't Miss Our Updates
Be the first to get exclusive content straight to your email.
We promise not to spam you. You can unsubscribe at any time.
Invalid email address
You've successfully subscribed !

Continue Reading

Heating and Mixing of Products using PLC Example Tutorial
Advanced Skills Required for a PLC Programmer to Get a Job
PLC Ladder Logic for Sensor Scaling with Offset
3 to 8 Line Decoder PLC Ladder Diagram
Types of Digital Outputs in PLC
Types of Failures in Industrial Automation Systems
Share This Article
Facebook Whatsapp Whatsapp LinkedIn Copy Link
Share
Leave a Comment

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Stay Connected

128.3kFollowersLike
69.1kFollowersFollow
210kSubscribersSubscribe
38kFollowersFollow

Categories

Explore More

Instrumentation Earthing
Micro PLC Hardware Configuration
#7 PLC Best Practices – Validate and Alert for Paired Inputs/Outputs
Advanced PLC Programming for Defective Parts Sorting
Functional Block Diagram in PLC for Oil and Water Process
CX-Programmer Tutorial: 1 Button To Activate 4 Different Machines
Face Mask Making Machine using PLC and HMI
How Could FB and FC Make Me Professional PLC Programmer?

Keep Learning

PLC engineering software

How to Download GX Works? Mitsubishi PLC Software

ON DELAY TIMER AS OFF DELAY TIMER

How to Interchange ON Delay Timer and OFF Delay Timer in a PLC

How to export in Vijeo Designer

Vijeo Designer software – Import and Export

Difference between Signal Cables and Control Cables

Difference between Signal Cables and Control Cables

Analog Instruments

Explaining Various Types of Analog Instruments

PLC Programming for Tank Farm Management

Tank Farm Management System: CX-Programmer [OMRON]

HMI

Learn about SCADA and HMI Systems

HMI Simulation for PID Controller

PID Controller Output Types – PID_PWM and PID_Output

Learn More

Thermodynamic cycle

Thermodynamic Cycles in Power Plant

Industrial Automation Systems

Remote Functions in Industrial Control Systems (ICS)

What is Partial Stroke Test

What is Partial Stroke Test?

Introduction to SCADA

Elevator PLC Ladder Logic

Elevator PLC Ladder Logic

gate-valve-principle-animation

Basics of Gate Valves

Elevated Span and Suppressed Span

DP Level Transmitter Elevation and Suppression Corrections

Electrostatics Objective Questions and Answers

225+ Electrostatics Objective Questions and Answers

Menu

  • About
  • Privacy Policy
  • Copyright

Quick Links

  • Learn PLC
  • Helping Hand
  • Part Time Job

YouTube Subscribe

Follow US
All rights reserved. Reproduction in whole or in part without written permission is prohibited.
Welcome Back!

Sign in to your account

Username or Email Address
Password

Lost your password?