I'm trying to import PLC Tags from excel file, but got Iport failed

Hello,

I'm trying to import PLC Tags from an excel file, but keep getting the same fault:

and opening the logs shows two items:

1 warning for missing version ID

1 fault that says worksheet "PLC Tags" does not have the required format

my question is, what is the required format? 

Attached there is the excel file I'm trying to use

Thank you in advance for any advice

Hi,

Perhaps this might help:

https://support.industry.siemens.com/cs/mdm/109815056?c=142721181707&lc=en-US

Best regards,

Wizard

Hello,

Kindly try using the below excel format with little changes to format.

:)

Hi Guys,

I've got the same issue.

Tried your template, but still not working.

There is a NOTE in HELP:

"When you see the message "Missing version ID in thepropertiesof the XLSX file" during import, the internal export format of the file is invalid. In this case open the "Customize" tab in the extended document properties of the XLSX file. Set the value "TIA_Version" to "1.0"."

Could you please help finding "Customize" tab in the extended document properties of the XLSX file?

Thanks!