Import data
Bring an Excel workbook into eode as a dataset, choosing exactly which tables on which sheets come in.
Where: Datasets→Import data
The Import data window reads an .xlsx workbook, finds the tables on each sheet, and lets you tick
the ones you want. A tinted preview of the sheet shows exactly which cells each table covers. What you
tick becomes a dataset.
Open the window
The same window opens from two places. What it makes depends on where you open it.
| From | Makes | After a successful import |
|---|---|---|
| Datasets→Import data | A new dataset | The new dataset opens. |
| Datasets→dataset→+→Import data | Tables added to this dataset | The window closes and the Resources list updates. |
A workbook you upload in a model's conversation also becomes a dataset, without this window: every table eode finds comes in. See Load your data.
Esc or ✕ closes the window, except while an import is running. Clicking outside it does nothing.
Upload a workbook
Pick Microsoft Excel
Click Microsoft Excel under POPULAR. It's the only source you can pick; every other card says COMING SOON (see Data connections). Search data sources… at the top finds a card by name.
If the cards don't load, the window reads Couldn't load data sources with Retry.
Drop the file
Drop an .xlsx on Drop a file here, or click to browse, or click it to pick one. The zone says
.XLSX · max 100 MB. The file is read straight away (Uploading and reading the file…), then the
zone shows its name and a line like 3 sheets detected · 2 tables · 7 KB.
Continue
Click Continue →. Back goes back a step.
If the upload is refused, the zone reads Upload failed:, the reason, and "Pick the file again to retry." See When an upload is refused.
Pick the tables
The next step has three parts: the sheets on the left, the tables found on the sheet you clicked, and a preview of that sheet.
Sheets. Click a sheet name to show its tables. A sheet's box ticks or clears all its tables. The
right edge shows how many of its tables are ticked (2/3), entire sheet when the sheet comes in as
one table, or - when no table was found. All sheets ticks or clears every listed sheet, and
Filter sheets… narrows the list by name.
Tables. Each card shows the table's name and colour, N rows × N cols, its range (like A1:F40), up
to eight column names (+N more for the rest), and a line saying how eode read it. A badge marks the
kind:
| Badge | What it is | Ticked to start? |
|---|---|---|
| (none) | A table eode found on the sheet: a header row and rows of data. | Yes |
| Excel table | A table defined in the workbook itself. | Yes |
| Report panel | Part of a report-style sheet, read out as one tidy table. See below. | Yes |
| Notes | Text with no header row. | No |
| Not a table | Cells that don't line up as a table. The reason says why, for example "cells scattered (12% of the grid is filled)". | No |
| empty | A table with a header and no data rows. | No |
When a sheet holds a single Excel table, it comes in under the sheet's name. Its card's line keeps the workbook's own name for it, like "an Excel table the workbook declares, named Table2 in the workbook".
Anything not ticked to start can still be ticked. A table with no header row of its own gets columns
named col_1, col_2, and so on.
Column names from. A table with more than one header row shows this select. Pick the row whose
labels should name the columns, like Row 3 · Product. The column chips update and the table is ticked.
Entire sheet. The dashed card at the bottom brings the whole sheet in as one table, exactly as it is. It replaces the sheet's tables: ticking it clears them, and ticking a table clears it.
It starts ticked when the sheet has no other card, or when nothing else on the sheet starts ticked and the sheet holds Notes or Not a table cards. So a sheet of notes, like the Notes sheet in the clip, comes in whole unless you untick it. A sheet of empty tables starts with nothing ticked.
Check the preview
Under PREVIEW the sheet appears as a grid with column letters and row numbers. Each ticked table is tinted in its card's colour, with its header row in bold. An unticked table is struck through. Click any cell of a table in the preview to tick or untick it.
The preview shows 200 rows and 40 columns at a time. The line above it says where you are
(rows 1–3 of 3 · cols 1–6 of 6), and the rows and cols arrows move the window. Cells show
their first 28 characters, and decimals show two places.
Report-style sheets
A sheet laid out as a report, with line items down one column and periods across a header row, comes in as Report panel tables: one per panel of the report. Each becomes a tidy table with one row per line item and one column per period, after five leading columns:
| Column | Holds |
|---|---|
line_item | The line item's label. |
section | The heading the line item sits under. |
level | How far the label is indented. |
is_total | Whether the row is a total. Totals are kept and marked. |
sourceCell | The cell the label came from, like Report!B83. |
When you bring such a sheet in as Entire sheet into a new dataset, the tidy tables are added alongside it. Adding tables to an existing dataset brings in only what you tick.
Review and import
- When the right tables are ticked, click Add source. The workbook is added to the list on the left and Review opens. "Only selected resources are pulled into the model."
- Check the summary, like
1 source · 3 resources selected. Importing creates one dataset from all of them.Every ticked table is listed as sheet · table, under a count like2 of 3 tables and 1 entire sheet selected. - To bring in another workbook as part of the same dataset, click Add data source and repeat. Each workbook is a card in the list on the left, with a button to remove it.
- Type a Dataset name, or leave it empty to use the name shown in the box: the workbook's file name
without
.xlsx, or<first workbook> and N morefor several. - Click Import data →.
Choose the machine size
A new dataset from a workbook asks one more question when you click Import data →: What size machine does this model need?, with "… opens on an engine of this size. If you are not sure, choose Medium."
| Size | Pick it for |
|---|---|
| Medium | "Most models. The standard engine; it grows if the model needs more." |
| Large | "A model that has needed a large machine before." |
| Extra Large | "A model that has needed the largest machine before, or ran for hours." |
Pick one and click Import. The size is kept with the dataset, and a model built on it starts on a machine that size; a larger size saves the slow climb from Medium when a big model runs out of memory. Cancel imports nothing and leaves you on Review. Adding tables to an existing dataset doesn't ask.
While it runs, the button reads Building model…. If it fails, the footer reads Build failed: and the reason.
Adding to an existing dataset skips the name. The summary ends "Importing adds them to this dataset.", and the tables are added to the dataset as it is now.
When an upload is refused
| The zone says Upload failed: and | What to do |
|---|---|
the file must be .xlsx | Save the workbook as Excel Workbook (.xlsx). .xls and .xlsm are refused. |
| the file is over 100 MB | Remove sheets or rows the decision doesn't need. |
| the upload timed out | Check your connection and pick the file again. An upload gives up after 120 seconds. |
| the file could not be read | The file isn't a workbook eode can open, or it has no visible sheet with data. Open it in Excel, save it again as .xlsx, and unhide the sheets you need. |
Limits
| What | Limit |
|---|---|
| File type | .xlsx only |
| File size | 100 MB |
| Upload time | 120 seconds |
| Rows read per sheet | 1,048,576, Excel's own limit for a sheet |
| Hidden sheets | Not read, and not listed. |
| Preview | 200 rows × 40 columns at a time |
Loading a workbook straight into a model has its own limits; see Start from a workbook.
A model reads one dataset. To use several workbooks in one model, import them together in one window so they become one dataset; see Load your data.
Related
- Datasets: find, share and organize what you've imported
- Edit a dataset: change the imported rows
- Data connections: which sources are available
- Load your data: attach a dataset to a model in its conversation