Hi Ben,
The BIOM format was created primarily to reduce the size of the tables for computation and in the ease of it being interpreted by the computer. The only way to easily visualize the information stored in the file is by using the convert_biom.py script in QIIME and changing it into a classically formatted .txt file, which can be opened in Excel. However, QIIME does contain numerous scripts that allow you to visualize the BIOM table's contents, like:
per_library_stats.py
summarize_taxa_through_plots.py
Hope this helps,