Sheets
Importing and exporting
Bring an Excel file, an OpenDocument sheet or a CSV in, and get your data back out in nine formats.
On this page
Press Import in the editor toolbar, or drag a file straight onto the grid. Nemi Sheets reads .nemi and .nsheet, Excel .xlsx and .xlsm, OpenDocument .ods, CSV, TSV and plain text, JSON, and tables inside HTML and Markdown files. An Excel import keeps its cell values, its column widths and row heights, its hyperlinks and its pictures with their anchors.
Two files are refused on purpose rather than half-read. A legacy .xls is not supported, so open it in Excel and save it as .xlsx first. A text document, .docx, .odt or .rtf, belongs in Docs and Sheets will say so instead of turning your letter into a grid.
Getting data out#
| Format | What it carries |
|---|---|
| Nemi (.nemi) | Everything: formulas, formatting, every tab, pictures and the authorship record. The only export you can bring back in whole. |
| Excel (.xlsx) | Every tab, as values, with column widths, row heights and pictures written back with their anchors. |
| OpenDocument (.ods) | Every tab, as values. |
| The tab you are looking at, drawn as it looks on screen: widths, colours, alignment, pictures and the row and column headers. | |
| CSV, TSV | The tab you are looking at, as plain values. |
| JSON | The tab you are looking at, as data for a script. |
| Markdown table, HTML | The tab you are looking at, as a table you can paste elsewhere. |
Single-table formats carry one tab. Excel and OpenDocument carry the whole workbook.
A locked copy#
Open Settings in the editor toolbar for a password-locked .nemi. Type a passphrase of at least four characters twice and the file you download is encrypted with AES-256-GCM: without the passphrase nobody can read it, us included. There is no way to recover a forgotten passphrase.
Form responses arrive as rows#
A form built in Forms writes each submission as a new row in an ordinary Nemi spreadsheet that you own, in your workspace. There is no export step, no sync and no second copy of the answers living somewhere else. The Sheets home badges that spreadsheet as Form responses so you can tell it apart from a sheet you made yourself.
It is a normal spreadsheet in every other way: you can add columns of your own beside the answers, write formulas over them, format them, and export the lot. Deleting it is not something to do casually, because it is where the responses live.
Somebody answers your form
On the public respond page.
A row is appended
Into the response sheet in your workspace, as it comes in.
You work on it in Sheets
Formulas, formatting and exports, like any other sheet.
When an import does not look right#
- The columns all landed in one. A CSV with an unusual separator. Save it from the source as a comma or tab separated file and try again.
- Numbers came in as text. Values that carry a currency symbol or a thousands separator arrive as text. Strip the symbol at the source, or use
TEXTand the maths functions on a cleaned column. - A picture is missing from an Excel export. Nemi tells you how many pictures it could not fetch rather than hiding it. Reload the sheet and export again.
- Only the first tab came in. Single-table formats hold one table. Use
.xlsx,.odsor.nemifor a whole workbook.
If a file will not open at all, it may be a format for the file converter rather than for Sheets. And if you want a sheet readable by a script rather than a person, a read-only JSON endpoint for a sheet is being rolled out under Share; if you do not see it, it has not been switched on for your account yet.
Related
Still stuck? Email support@nemilab.com and tell us what you were trying to do.