Return a list of rowcounts for multiple SQL tables

Return a list of rowcounts for multiple SQL tables

hopefully this will be quick to answer. I'm new to SQL so struggling with
this, I may be missing something obvious. I have the below query which
returns row counts in separate results however I would like to get the
results into an XLS. What is the best method to go about achieving this?
select count(*) as "table_1" FROM table_1
select count(*) as "table_2" FROM table_2
select count(*) as "table_3" FROM table_3
select count(*) as "table_4" FROM table_4
select count(*) as "table_5" FROM table_5
select count(*) as "table_6" FROM table_6
select count(*) as "table_7" FROM table_7
select count(*) as "table_8" FROM table_8
select count(*) as "table_9" FROM table_9
select count(*) as "table_10" FROM table_10
Many Thanks!