Use this site to build a view of your property portfolio from your spreadsheet data. It can display thousands of lines:

Just click the DataView button above and download and modify a sample file. Then upload it to create your own view
with your own data. When your view is displayed, click the window to see tenant details.
(The view below is from a spreadsheet listing dates when rent was last revised. Rents revised over 12m ago are highlighted red)