When you import a spreadsheet, Numio places it in a specific part of the sheet and follows a few rules about replacing earlier imports, file types, and empty tabs. This article explains what to expect so a surprising result makes sense — and what to do if it isn't what you wanted.
Imported data starts at column D
Numio reserves columns A, B, and C for your own work — the input and output cells you assign to blocks, plus their labels. Every import is shifted to start at column D instead.
So a file whose first value sat in A1 lands in D1 after import. This is intentional: it keeps your assigned cells clear of the imported grid. If you expected your data to start at column A and it's sitting at column D, that's the offset at work, not an error.
Formulas are shifted to match
Because the whole imported sheet moves three columns to the right, Numio rewrites every cell reference inside imported formulas by the same amount. A formula that read =A1*B1 in your original file becomes =D1*E1 after import. This keeps formulas pointing at the right cells, including cross-sheet references between imported tabs.
If an imported formula looks like it references the wrong cells, check that the source formula was correct before import — the shift is uniform, so an off-by-one in the result usually traces back to the original file.
Re-importing replaces the previous import
If you import into a project that already has imported data, the new import overwrites the previous import region. Numio clears the old region (including cells that the smaller new file no longer covers) and writes the new data in its place.
- This is a single undo step for the values, so Cmd+Z (or Ctrl+Z) reverts the value changes.
- Column widths and row heights are applied as separate steps, so undoing an import with custom sizing may take a few presses of undo.
If a re-import wiped data you wanted to keep, undo immediately, or re-import a combined file that includes everything.
Legacy .xls files aren't supported
Numio imports .xlsx, .csv, and .tsv. Older .xls files are not supported — if you try one, you'll see a message asking you to re-save as .xlsx and try again. Open the file in your spreadsheet app and use Save As → .xlsx, then import the new file.
Empty tabs are skipped
When you import a multi-sheet workbook, each worksheet becomes a tab in your Numio spreadsheet — but worksheets with no cells are skipped. If a tab you expected didn't appear, check whether it was actually empty in the source file. Add at least one value to the tab and re-import if you need it.