In a nutshell, the Collection Tool for Excel enables you to create a collection in a spreadsheet,
and then export to a format understood by PivotViewer
Once you have your Pivot Collection, it must be hosted on a server somewhere. This technical article describes various scnarios for hosting your collection.