Well, If you go in the products listing in the backend, you can change the dropdowns on the top right to display all the products (not only main products) and display "all the sub elements". That way, on the main category, you'll have a listing of all the products and variants of the website including their prices. And you can change the pagination to see more of them on the same page.
You could also use the "export" button there to get a CSV of the products and variants data, including their price.
Still, I don't know if that's what you need ?