How to Import/export excel sheeets

hi

i want to knw import/export of SCADA tags in/frm Excel sheet

Using what SCADA software?
Else look through the documentation for "Export" then follow directions. You may need to use .csv file as an interim step.

You can do it with Citect but you have to use their dbf open and save software or the field lengths will change and then the dbf will not work properly.
Do not know about the others.

Here is an old thread from 2009 about importing and exporting tags from RSLogix5000 to or from a Microsoft Excel CSV-type spreadsheet:

http://www.plctalk.net/qanda/showthread.php?t=45230


Here is a thread about moving data from RSLogix500 to Excel, then to Citect:
http://www.plctalk.net/qanda/showthread.php?t=59879

Here is an article about creating RSLogix500 Symbols and Descriptions in an Excel CSV file, then importing them to the RSLogix software using ASCII Import:
http://www.mrplc.com/kb/index.php?article=22

Im pretty sure you can do it with most SCADA packages. If you tell us what SCADA you are using you might get a more direct answer.