Search:     Advanced search

Advertisement

Discuss your PLC and automation problems for Allen Bradley, GE, Omron, Mitsubishi, Modicon, Panel Views, RS View, ABB, Adept Robots, Cognex etc. You can also submit and download sample PLC code.

If our forums and knowledge base still hasn't got your PLC operational, we recommend contacting PDF Supply and Electric for PLC repair and replacement parts.

How to use EXCEL for your Symbols and Descriptions in RS Logix 500

Article ID: 22
Last updated: 08 Jan, 2015

Many times enough the worst part about starting a new RS Logix 500 PLC project is typing in all the descriptions and symbols for all your bits and I/O. Luckily there is an easy way to go about doing this monotonous task. I use EXCEL to wiz through this busy work.

I've created an EXCEL template file that you can download here. Once you've downloaded the EXCEL file you can kind of see how the template layout works.

 

 

The rows are formatted to the maximum width of characters that RS Logix will allow. Simply type in the address, bits, timer files or whatever memory files you want to include for a description. Make sure you include a symbol for your description. Use under scores for spaces with your symbol names you create. Learning to use symbols to program will save you a ton of time in programming because it's easier to remember the symbol name "RUNNING" rather than B3:1/3 means "running". More about symbol programming in another article.

 

One EXCEL trick that I use quite often is the AUTO FILL feature. That's where I just type the first address and drag down to auto fill the rest of the address in the card rack.

 

Once you've created your excel sheet. It's now time to save the excel sheet as a CSV format. The database import tool in RS Logix is designed to accept a CSV file that you create.

 

In Excel, click on File Save As.

 

 

Choose CSV (Comma Delimited). Type a file name for your CSV file.

 

 

 

Now start RS Logix, and click on Tools, Database, ASCII Import.

 

 

 

 

Change the option to CSV.

 

 

 

 

Find your file name you saved earlier, make sure you have CLOSED Excel by now, otherwise you will get a can't open file error, because Excel still has the file open in the background.

 

 

 

 

Once your file is imported, click on the database, address/symbol in the tree viewer. We need to delete just a little bit of trash the template file imported into your database.

 

 

 

 

What you are looking for is the header columns from the excel template. These get imported also so it's just best if we delete these.

 

Delete these extra database entries by clicking and highlighting the row and simply hitting delete. Once you have cleaned up your database, you should be ready to start programming!

 

Download the EXCEL Template File. Winzip Required.

Article ID: 22
Last updated: 08 Jan, 2015
Revision: 3
Views: 20297
Comments: 7
This article was:   Helpful | Not helpful
Prev   Next
How to Symbol Program with Allen Bradley RS Logix 500     Entering a Sequential List of IP Addresses in RSLinx

Comments
Jim | 26 Nov, 2003 12:00 AM
A fixed width font would work better for keeping the field widths within the limits.
Posted: 14 years ago   | Permalink
Chris Elston | 01 Dec, 2003 12:00 AM
You mean setting a limit within a cell with the Excel template?
Posted: 14 years ago   | Permalink
Hester | 17 Apr, 2004 12:00 AM
Courier should be a fixed width font.
Posted: 13 years 7 months ago   | Permalink
Robert Sivell | 18 Nov, 2004 12:00 AM
Don't you need RSLogix 500 Professional to edit the database?
Posted: 13 years ago   | Permalink
Russell Williams | 25 Feb, 2007 12:00 AM
If you don't export the column headers then RSLogix won't try to import them (as garbage). RSLogix is importing a CSV file "plain ASCII" so the font is irrelevant. In fact, Excel is also irrelevant (except to open the posted file).
Posted: 10 years 9 months ago   | Permalink
Murphy W | 08 Jan, 2015 09:53 AM
Has the excel file been moved or deleted? The link is dead.
Posted: 2 years 11 months ago   | Permalink
kbadmin | 08 Jan, 2015 10:01 AM
The Linked Excel file has been fixed. here is the link:
http://forums.mrplc.com/index.php?app=downloads&showfile=131
Posted: 2 years 11 months ago   | Permalink

Prev   Next
How to Symbol Program with Allen Bradley RS Logix 500     Entering a Sequential List of IP Addresses in RSLinx