Warp Matrix demo — a row × column input field for Filament: stock by size and color, prices, permissions. Change anything; the data is reset every hour. warpui.com About Warp Matrix Docs Ask a question Support
Skip to content

Paste from Excel

The table works like a spreadsheet: paste a block of cells from Excel or Google Sheets, move with the keyboard, fill a whole row or column, and copy the table back out. All of this is on without any setting.

Paste a block of cells

Copy cells from Excel or Google Sheets (or the sample below), click a cell and paste: the block is filled in from that cell, to the right and down. A value that is not a number is left out, and a message tells you how many.

Note: Try it

Click “Copy the numbers” under the sample. Then click the XS × Black cell of the empty table and press Ctrl+V (⌘V on a Mac): all 20 cells are filled at once.

Size Black White Navy Olive
XS 2 3 1 2
S 6 8 4 5
M 10 12 7 8
L 8 9 6 6
XL 3 4 2 2
Copied. Now click the XS × Black cell of the table below and paste.
Delivery of linen shirts
Size
Black
White
Navy
Olive
XS
S
M
L
XL

Move with the keyboard

The arrow keys move between cells. Enter goes down to the next size, Shift+Enter goes up. Tab moves to the next cell as usual.

Note: Try it

Click S × Black, type 9 and press Enter: you are in M × Black, ready to type the next count. Press the right arrow to go to M × White.

Stock count
Size
Black
White
Navy
Olive
XS
S
M
L
XL

Set a whole row or column to one value

A small pencil button sits next to each size and color. It is shown faintly at all times and gets darker when you point at the name. It fills every cell of that row or column with the same value. The pencil next to “Size” in the corner does the whole table.

Note: Try it

Click the pencil next to M on the left, type 6 and press Enter: every color of M becomes 6. Click the pencil again and press Enter with the box left empty: the row is cleared.

Reorder points
Size
Black
White
Navy
Olive
XS
S
M
L
XL

Copy the table

The “Copy table” button above the table copies it with the names of the sizes and colors, ready to paste into Excel or Google Sheets.

Note: Try it

Click “Copy table”, then paste into a spreadsheet: the sizes are in the first column and the colors in the first row.

Stock on hand
Size
Black
White
Navy
Olive
XS
S
M
L
XL