If you wish to import subtitles directly from Excel, XLS and XLSX, files you should know that the In and Out cues must be placed in the first two columns and the text have to be kept in the third one. Otherwise you will receive an error message.
The Excel Workbook import will keep the text alignment, italics and color information. If the selected XLS document contain more than one worksheet subtitles from the first worksheet will be displayed in the main subtitles track, while those from the second worksheet - in the secondary track.
By pressing the Config button you can specify the time code format used in the Excel file.
Excel Import Configuration