How to quickly create an Excel file for a Cost Estimate on AWS

As you have already noted the AWS Calculator does provide CSV, but the layout is different than your expected format. And each company could be having their own Excel template, so there is really not one standardized format.

One possibility is to create Macro(s) in Excel that will do the mapping and reformatting from source CSV to your target Excel format. You could record the Macro when you perform the task and then replay it subsequently. Also having Visual Basic skills to fully program out the reformatting logic could be helpful.

Steven - please elaborate on the "company Excel template." Is this template the same format for every customer, or is the template different for each customer company? If it is the same template for every customer, perhaps Excel PowerQuery could be used to query the .csv file export, do data transformations on the column contents, then output the data in the format you need. You would then just need to create one template for the output format, and for each customer point power query to a different source .csv file to automatically ingest new data and transform it.