To pick a random name from an Excel table using a method that works across every version of Excel, this classic combination ...
A robust Python script that converts Excel (.xlsx, .xls) and CSV files to T-SQL INSERT statements, ready for execution in SQL Server or Azure SQL Database.
You can use this repo to download various sample excel files.