Each mapping in an Excel connection represents a worksheet in an Excel workbook. When using an Excel connection for export, naming the mappings (or mapping tables) is bound to a few limitations coming from Microsoft Excel with respect to naming worksheets. Please keep these in mind when naming your mappings in an Excel connection for export.
Excel worksheet names cannot:
- Be blank.
- Contain more than 31 characters.
- Contain any of the following characters: / \ ? * : [ ]
Begin or end with an apostrophe ('), but they can be used in between text or numbers in a name.
- Be named "History". This is a reserved word Excel uses internally.
(Applies To: Excel 2016 Excel 2013 Excel 2010 Excel 2007, source: support.office.com)