There’s no built-in duplicate rule for Excel’s Data Validation feature, ... If you’re working with your own data, be sure to update the name of the Table and column. Click OK.

That being the case, you’ll need a couple additional columns of datetime2 data type, the VALIDFROM and VALIDTO columns, which tells SQL Server which snapshot of the temporal table to use when querying ...