I'd like to output this information to a CSV or HTML file as opposed to displaying it on the PS window.

I appreciate this is likely already a very long winded way of running this query - could I perhaps have overlooked a much simpler method?

Bonus points if there's a way I can do this without having to import a CSV file at all - that would cut out the need to add additional entries into that list when new "companies" get added on or taken away!