You can use the downloader that comes with metastock to do this.
Open the Downloder, go to tools->convert
Specify the Source File type (as excel), Folder, and File name information for the source and destination files in the Convert Securities dialog.
Click on the Options button to specify any special instructions regarding the source and destination files.
After you have completed the dialog, click the OK button to begin the conversion process.
Locate the converted file in the specified Destination Folder.