Hi Anupam 

Look at using the DataPort utility to import the lookup set, using the online help. 

This by default only uses a Tab delimited format unless a custom importer is written.

The easiest way to check how to format the import file is to export a lookup set and select all the relevant fields
From the exported metadata file, you can then review the format and then provide alternate data, e.g. via a csv saved in Tab delimited format ( and also a UTF encoding) 
Then run a DataPort import project supplying the new metadata file and in the configuration map the fields(columns) in the metadata sheet to the lookup set fields.

Thanks for the help. I believe that Dataport utility comes as a separate package and we have to add it to utility package or something. But I will definitely look into it. Thanks for the headstart.

It is not a separate package, but it is a separate exe typically launched form the client. but can also be launched separately , look under the list of CM applications listed under WIndows  Start. 

. In the client , select the Administrator tab, and then Other > Import/Export. ( on the far right) 
This will only be available for users with the relevant permissions , eg Administrator and I believe Records Manager.






This then launches the DataPort 



From the Start list

Note that you can only open DataPort via the Administration Tab through the full CM Client, it is not available on the CM Desktop Client. 

Note that you can only open DataPort via the Administration Tab through the full CM Client, it is not available on the CM Desktop Client.