Convert NPY to XLSX

Turn NPY files into XLSX. One sheet named after the file, 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 NPY files on the dialor turn it to pick what to do

A NumPy array as an Excel sheet.One sheet, a bold header row, and typed cells for numbers, booleans and dates.

  1. What you get

    An XLSX workbook with one sheet, named after the file. The first row is a bold header. Numbers, booleans and dates are written as typed cells.

    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.

  2. Records and larger arrays

    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. Each row is led by columns named axis0, axis1 and so on.

  3. What changes or stops

    NaN and NaT become empty cells.

    Arrays of Python objects are not loaded, because unpickling them could run code. The conversion stops with unsupported_elements for these files.

    If you have several workbooks to combine afterward, you can merge XLSX.

NPY and XLSX.What each format is.

The formats

From · NPY

NumPy Array

A single NumPy array saved with numpy.save, with its shape and data type.

Extensions
.npy
MIME type
application/x-npy
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 NPY to XLSX conversion through the API, for your app or your agent.

terminal
$ cv convert report.npy report.xlsx
$ cv convert report.npy report.xlsx

Questions.What people ask about NPY to XLSX.

01OF 04

Each row of the array becomes a row in the table. The columns are named 0, 1, 2 and so on, one for each index of the second axis.

NaN and NaT become empty cells.

No. These arrays are not loaded, since unpickling them could run code, and the conversion stops with unsupported_elements.

It becomes one row for each index of all but its last axis. The rows are led by columns named axis0 and axis1, and the last axis gives the remaining columns.

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