After you install the April 4, 2017, update for Excel 2016 (KB3178719), the following Get & Transform features are updated in Microsoft Excel 2016:
Split Column by Delimiters: Automatic detection of delimiter characters
Combine Binaries: Specification of a sample file for a combine action
DB2: Package Collection setting