So of course I would prefer free options, like excel spreadsheets, before I drop $30-$40 on a program to get everything I need.
The base product is free and comes with examples for all the features.
Also, I'm hesitant because I can't find any examples of the character sheet print out? What do character's look like? Are the outputs modifiable without needing to understand XML? Does it print to PDF?
The character sheet is an HTML file that can be printed to PDF using your browser. The styling of it can be furthed modified but that's in the realm of advances customization, you need to know CSS.
Click
HERE for an example of how it looks like.
Also, when you say you can 'use the combat tables from Combat Companion' does that mean ERA can be used to run combats?
Absolutely. ERA manages character creation, leveling up, inventory, resolving skills, combat, round upkeep, and has some features to help with keeping players up-to-date with their characters' status, some foraging, traveling and treasure generation features.