To Import RSLogix Files to a PLC Spreadsheet

Creates a spreadsheet file from a RSLogix file to use with the Spreadsheet to PLC I/O Utility.

  1. In RSLogix, export your RSLogix 500 file into .EAS format.
  2. Click Import/Export Data tab Import panelRSLogix 500. Find
  3. Select an .EAS or .CSV file and click Open.
  4. In the RSLogix 500 Import dialog box, select whether the I/O points should be displayed in 8, 16, or 32-point groupings.
  5. Pick an I/O module for each set of I/O points. Enter it in the edit box, select from the PLC dialog box using Browse, or select from the already used list once you have some modules selected.
  6. Click OK to assign the module and move on to the next set of points.
  7. (Optional) To change a module assignment, select the module assignment and click Change. In the RSLogix 500 Import Change Module dialog box, change the selected module part number by entering the new module name in the edit box, selecting it from the PLC dialog box using Browse, or selecting it from the already used list once you have some modules selected. Click OK to assign the module and return to the Input Module dialog box.
  8. (Optional) Click Omit to skip a set of points, or click Future to skip the points and add information so AutoCAD Electrical toolset adds a blank column when generating the drawing from the spreadsheet.
  9. Enter a name for the spreadsheet once a module was assigned for each set of points. Click Save.

    Use Microsoft Excel to modify your spreadsheet as needed.

  10. To create the PLC drawing, click Import/Export Data tabImport panelPLC I/O Utility. Find