DECLARE @searchstring NVARCHAR(max)
SET @searchstring = '%SearchedString%'
DECLARE @sql NVARCHAR(max)
SELECT @sql = STUFF((
SELECT ' UNION ALL SELECT ''' + TABLE_NAME + ''' AS ''table'', ''' + COLUMN_NAME + ''' AS ''column'', ' + COLUMN_NAME + ' AS value' +
' FROM ' + TABLE_SCHEMA + '.' + TABLE_NAME +
' WHERE ' + COLUMN_NAME + ' LIKE ''' + @searchstring + ''''
FROM INFORMATION_SCHEMA.COLUMNS
WHERE DATA_TYPE in ('nvarchar', 'varchar')
FOR XML PATH('')
) ,1, 11, '')
EXEC (@sql)
Then you can use Excel BI tool to display data in Excel