Using SQL Studio, run a New Querery against sys.tables
USE YourDBName
GO
SELECT *
FROM sys.Tables
GO
This will return all the tables in the database which user have created.
You can now right click on the results and save to csv for import into Excel.
