Column Separator Character for Excel
1) What is Column Separator Character for Excel file (.xls, .xlsx). For CSV it is comma(,) but for excel files is 'Tab' or 'Pipe'?
2) I am doing EDM indexing of an Excel file and it is giving me an error. When i try to upload the file it gives me this error. “The data dump file is invalid, it contains invalid characters in the first row”. First Column Names in the files are