Skip to end of metadata
Go to start of metadata

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: