Load HDF5 in Excel?

9.8k views Asked by At

Is there a way to load/import an HDF5 file (sometimes called H5, HD5, or Hierarchical Data Format) in to Excel?

I do not want to export an intermediary CSV file, as ideally I would like to modify the data and in Excel and resave back to HDF5 (but an acceptable answer is one that solves the problem of loading the file first).

Note that HDF5 is the format used by Python's PyTables, pandas, and h5py (experts in these packages may be able to answer this question). However I would prefer not to use Python to solve this problem (I would prefer an existing software tool). Maybe there is a way with ODBC...but I don't know how.

1

There are 1 answers

0
Ariel On

You can use PyHexad Excel add-in for HDF5

https://www.hdfgroup.org/2015/06/america-runs-on-excel-and-hdf5/