Convert NPZ to XLSX
Turn NPZ files into XLSX. One workbook with a sheet for each array in the archive, named after it, each with a bold header row and numbers, booleans and dates as typed cells.
Converted in an isolated sandbox on our serversDeleted after 24 hours
Drop NPZ files on the dialor turn it to pick what to do
One workbook with a sheet for each array.Each array in the archive becomes a sheet named after it, with a bold header row.
What you get
One XLSX workbook. Every array in the NPZ archive gets its own sheet, named after the array. Each sheet starts with a bold header row.
Numbers, booleans and dates are written as typed cells, so Excel treats them as values and not as text. NaN and NaT become empty cells.
How arrays are laid out
A 1-D array becomes one column. A 2-D array becomes a table with a column for each index of its second axis, named 0, 1, 2 and so on.
A record array gets a column for each field. A field that holds an array or nested records is written as JSON text.
An array of three or more dimensions becomes one row for each index of all but its last axis. Those rows are led by columns named axis0, axis1 and so on.
Arrays that are not loaded
Arrays of Python objects are not loaded, since unpickling them could run code. The conversion stops with
unsupported_elementswhen the archive holds one.To combine the result with other workbooks, you can merge XLSX. For more on the target format, see every XLSX conversion.
NPZ and XLSX.What each format is.
The formats
NumPy Archive
Several NumPy arrays zipped together by numpy.savez, each under its own name.
- Extensions
- .npz
- MIME type
- application
/x -npz - Kind
- Text and data
Excel Workbook
Excel's workbook format since 2007. Sheets, formulas, formats and charts in zipped XML.
- Extensions
- .xlsx
- MIME type
- application
/vnd .openxmlformats -officedocument .spreadsheetml .sheet - Kind
- Documents
In your code.The same NPZ to XLSX conversion through the API, for your app or your agent.
$ cv convert report.npz report.xlsx$ cv convert report.npz report.xlsxQuestions.What people ask about NPZ to XLSX.
Each sheet takes the name of the array it holds in the archive.
It becomes a table with a bold header row. There is a column for each index of the second axis, named 0, 1, 2 and so on.
NaN and NaT become empty cells.
The archive holds an array of Python objects. These are not loaded, because unpickling them could run code.