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.

  1. 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.

  2. 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.

  3. Arrays that are not loaded

    Arrays of Python objects are not loaded, since unpickling them could run code. The conversion stops with unsupported_elements when 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

From · NPZ

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
To · XLSX

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.

terminal
$ cv convert report.npz report.xlsx
$ cv convert report.npz report.xlsx

Questions.What people ask about NPZ to XLSX.

01OF 04

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.

More conversions.Other ways in and out of NPZ and XLSX.