Here is a utility to read & write strings between the Excel and Ethernet-Logix based PLC. (CompactLogix and ControlLogix)

Reading data from Excel can be done with separately defined columns for the Tag and the String Text.  Read Mode will choose which column is read, "Strings Only" mode will request for an array tag to be entered.  Starting row and qty will determine the number of strings to be read.  Any row with a blank column will not be imported into the utility.

PLC Data will be updated with the press of the button upload or download based on the items inside the Tag Column list box

After uploading, it is possible to back-up and save to excel.