Elbuz reads every sheet of the supplier’s Excel workbook and lets you choose which to import. Sheets with different layouts can get their own column addresses.
When you need this:
- The workbook has “Contacts” or “Calculations”: clear the “Sheet active” checkbox, and that tab won’t end up in your products.
- The price is in different columns on different sheets: per-sheet mode reads each sheet by its own addresses.
- The supplier hides tabs: new hidden sheets are added already disabled.
- A tab disappeared from the file: its settings wait 15 days for it to come back.
Where to start: source card → “Columns” section → the “Import from sheets” link.
What the sheets window does
Where to start depends on how your workbook is built.
- The workbook has service sheets: “Contacts”, “Calculations”, a price list for another regionClear the “Sheet active” checkbox: the sheet stays in the list but is skipped during import
- Columns sit in different places on different sheetsTurn on “Configure per sheet” and give each sheet its own set of addresses
- The list has a sheet you don’t see in the workbook tabsIt’s a hidden sheet: a new one is added disabled, and a tab hidden later you disable yourself
- A sheet used to be there, and now its “Sheet found in the price list” checkbox is clearedThe supplier renamed or removed the tab; its settings wait 15 days
Where the sheet list comes from and what happens when a sheet disappears
Elbuz doesn’t ask you for the sheet list: it rereads it from the file on every parse. So before the first import the list is empty, and the window says so: “The list of sheets is empty, you may need to load data from the price list to update the information.”
After that, with each new file, the list is updated by four rules:
- New sheets are added as active. The exception is sheets hidden in the workbook itself: they’re added already disabled.
- Sheets missing from the new file stay in the list with the “Sheet found in the price list” checkbox cleared. Their settings are kept for 15 days, then the row is deleted.
- A sheet that comes back to the file returns as it was, with all its addresses and rules.
- Sheets are identified by name, not by position. If the supplier reorders the tabs, nothing changes for Elbuz. If they rename one, it’s a different sheet. Names that differ only in letter case or leading and trailing spaces count as one: “Laptops” and “laptops ” merge into a single sheet.
- Start
- State
- End
1
List of sheets2
Columns of the selected sheet3
Column letter in the preview4
Row number5
Sheet tabs- The grid with all sheets of the workbook; selecting a sheet loads its own column setup and preview.
- The columns of the selected sheet with the address of each field.
- Above each column is its letter and below it its number; the hovered column is highlighted as a whole.
- This is the row number you enter in the field for the row to start loading products from.
- The strip of tabs switches the preview between sheets.
On the left of the window is the narrower “List of sheets” grid with the sheets and their settings. On the right, taking most of the width, are the columns of the sheet you’ve selected. At the bottom is a tab strip with a preview of each sheet. When the window opens, the first sheet is selected automatically.
In the preview, each column shows its letter and number, and the row number on the left is the one you enter in “Load products from row”. Hover over a column to see its address, e.g. I33.
A sheet disappeared or was renamed
If a sheet isn’t in the new file, its “Sheet found in the price list” checkbox is cleared in the grid, and it also disappears from the preview strip. The row itself stays for 15 days. If a file with the old tab comes back, everything returns as it was.
After 15 days, the grid row itself is deleted, along with its active state, row and price ranges, separators, note and category detection settings.
Column addresses, field formulas and ignore rules, however, stay tied to the sheet name: if a sheet with the same name comes back even a year later, they work again. The 15 days aren’t counted by the calendar: rows are removed by the next file parse, so for a source that’s no longer imported they stay.
Renaming looks the same, only doubled: for Elbuz these are two different sheets. The old name gets the “Sheet found in the price list” checkbox cleared, and the new one is added as a new sheet, with no addresses, formulas or ignore rules. The practical result: after a rename, you have to map the sheet again.
If the supplier changes tab names from file to file, like “Prices 12.08” and “Prices 19.08”, ask them to give the tab a permanent name. Otherwise every new file brings an empty sheet, and the old one quietly lives out its 15 days.
How to turn off service sheets
The “Sheet active” checkbox in the grid is how you answer “which sheets are mine”. A cleared checkbox means the sheet is in the workbook and stays in the list, but it’s skipped during import. No products come from it.
The window with this grid opens only in per-sheet mode. If columns are the same on all sheets, turn the switch on, clear the checkboxes and turn it off again: the sheets’ active state is kept and works with the shared set of addresses.
Clear it for everything that isn’t a price list: “Contacts”, “Calculations” and “Delivery terms” tabs, reference sheets, price lists for other regions. Elbuz can’t tell them apart from a price list: to it they’re just tables, and without your checkbox they go into products with the rest.
1
Unchecked activity box2
Hidden sheet column3
Deactivate all sheets- The unchecked activity box on the Contacts sheet: it is a reference sheet and is not imported.
- The Hidden sheet column shows which sheets are hidden in the workbook.
- Deactivate all sheets switches off every sheet in one click.
For a workbook with a couple dozen tabs, it’s faster to work backwards. The “Deactivate all sheets” button clears the checkbox on every row, and then you tick only the ones you need. Its counterpart, “Activate all sheets”, does the opposite.
Both buttons go through all grid rows, not just the sheets visible in the file. “Activate all sheets” also turns on hidden sheets and sheets that disappeared from the workbook, and a missing sheet starts importing as soon as it comes back. After a bulk activation, look through the list.
This only looks like a one-time job: suppliers add service tabs to their workbooks all the time.
Deleting a sheet
Each grid row has a trash icon. It asks for confirmation and then deletes not just the settings row but the whole sheet with everything tied to it: column addresses, field formulas, ignore rules, category distribution rules, category detection settings, currency settings and all products imported from this sheet with their categories. On success, you see the “Entry deleted” toast.
There’s no way to undo the deletion. The sheet comes back to the list on the next file parse, but empty: you’ll have to set addresses, formulas and rules again. If you just don’t want to import the sheet, clear “Sheet active” instead of clicking the trash icon. The import result is the same, and the settings stay.
How to avoid importing a hidden sheet
Excel can hide sheets: the tab disappears from the bottom strip, but the sheet stays in the file. Suppliers do this all the time to hide calculations, old versions of the price list or leftover stock from last season.
Such a sheet doesn’t disappear from the source’s sheet list. It’s there, and on every file parse Elbuz ticks the “Hidden sheet” column for it. Whether its products get imported depends on the active checkbox, and there are two different situations.
First: the sheet was hidden from the start. Then Elbuz adds it already disabled, and it won’t go into products until you turn it on yourself. This applies to both ways of hiding a tab in Excel: the regular one and “very hidden”, which can’t be unhidden from the workbook itself.
Second: the sheet was regular, and the supplier hid it later. Here the “Hidden sheet” checkbox gets ticked, but the sheet stays active. It was on, and it stays on. So products can come from a sheet you don’t see in your Excel.
A hidden sheet isn’t dangerous in itself; the danger is that nobody looks for it. Products arrived, the row count looks plausible, prices are in place, so no questions. The mismatch surfaces later and looks odd: in the price list’s product list, items are labeled with one sheet but are actually the range of a different one.
How to spot it. The easiest way is the “Hidden sheet” column in the “Sheet list” grid: look for rows where both it and “Sheet active” are ticked. The mark is refreshed with every new file, so after an import it shows the state of the workbook the supplier sent last.
The second way is to open the supplier’s file in Excel and compare the bottom tab strip with the list in the “Import from sheets” window: every sheet that’s in the list but not among the tabs is hidden. And a third, when you’re not sure what’s on a sheet: the preview strip at the bottom of the window shows each sheet’s content without running an import.
1
Hidden sheet checkbox2
Sheet active checkbox cleared- The Hidden sheet checkbox is set for the second sheet: the sheet is hidden in the workbook itself.
- Activity is cleared in the same row, so this sheet is not loaded.
What to do. Once you find it, clear “Sheet active” on that sheet. That’s enough: the sheet stays in the list but no longer goes into products.
How to set addresses for each sheet separately
Now about addresses. A source physically has two sets: one shared set that applies to all sheets in the workbook, and one set per sheet. Both are stored at the same time, and neither overwrites the other. Which one the import uses is decided by the “Configure per sheet” switch in the header of the “Columns” section, and nothing else.
With the switch off, the shared set is used, and the column grid sits right in the source card. With the switch on, there’s no grid in the card. Instead you see “Per-sheet setup mode enabled.” and a link to the sheets window. Switching fully reloads the settings tab, and that’s normal.
A classic time sink: you edit a column address in the source card, rerun the import, and nothing changes. The reason is that the sets are different. You edited the shared one, but the import uses the per-sheet one: the field has the shared address A, the sheet settings have I, and the ninth column goes into products.
The sign is always the same: the fix doesn’t work, and there’s no error. The first thing to do is look at the switch and figure out which set you just edited.
Only this switch decides which set of addresses the import uses.
One more thing worth knowing in advance: the mode can turn on by itself, but not from every edit. It always turns on when a sheet’s address is set with the column mapping wizard. If you edit an address directly in the sheets window grid, the switch turns on only when at least two active sheets have filled-in addresses.
The consequence isn’t obvious and costs time: if you map one sheet in the grid and leave, the source stays on the shared set, and the import uses it. Either map a second sheet, turn on the switch manually, or set addresses with the wizard, which turns the mode on right away.
There’s also a safeguard for the opposite case. If the mode is on but no active sheets with filled-in addresses are left (the supplier sent a workbook with different tabs, sheets disappeared), the import doesn’t run empty: it automatically falls back to the shared set of addresses. The price list keeps its mapping.
Columns of the selected sheet
The right half is the same field grid as in the source card: “Name”, “Column address”, “Currency code”, “Exchange rate”, “+%”, the last column “Resulting value” and the rest. But here the addresses belong to the sheet: select another sheet on the left, and the right side shows its addresses, with “Resulting value” recalculated.
What this column shows and why it’s sometimes empty is covered in the article on price list fields.
1
Field list2
Column mapping wizard3
Column address- The list of fields to add to the sheet; a field is added by double click.
- The column mapping wizard opens for the selected sheet.
- The column address of each field on this sheet; other sheets can have different addresses.
You add fields by double-clicking in the list to the left of the grid, as the hint says: “Double click to add a field”. The wizard icon above the grid opens the “Column mapping wizard”, which also works with the selected sheet, not with the source as a whole.
When you open a sheet that has no fields yet, Elbuz creates a default set of eleven fields: “Manufacturer SKU”, “Manufacturer”, “Name”, “Price”, “Supplier SKU”, “RRP”, “Stock status (from price list)”, “EAN barcode”, “Category from the price list”, “Product link (URL)”, “Product image link”. It then tries once to match addresses for them.
The “Consider uniqueness” checkbox is set on “Name” and “Manufacturer SKU”.
This is the only automatic matching in per-sheet mode. A new file from the supplier doesn’t remap sheet addresses: if columns shift in the next file, you’ll have to fix them manually.
The “Import” button in the toolbar runs a full import of the source right from here, which is handy when you’ve just fixed addresses and want to see the result. It’s the same import as from the card, not a check of a single sheet.
What else you set per sheet
Column addresses aren’t the only thing in this window that belongs to the sheet rather than the source. You edit the “List of sheets” grid right in the cells: click, change, leave the cell, and the value is saved. There’s no separate “Save” button.
| Column | What it does | Default |
|---|---|---|
| “Sheet name” | Sheet name from the workbook; pinned on the left, read-only | from the file |
| “Sheet active” | Cleared: the sheet is skipped during import | on |
| “Sheet found in the price list” | Shows whether the sheet is in the latest file; read-only | — |
| “Hidden sheet” | The sheet is hidden by Excel; refreshed with every file, read-only | — |
| “Load products from row”, “starting from” / “to” | The sheet row where products start and the row where they end | from 1 to the end |
| “Load products with price”, “starting from” / “to” | Drops rows whose price falls outside the range | from 0.01, no upper limit |
| “Decimal separator” | What separates the decimal part on this sheet | period |
| “Thousands separator” | What separates thousands on this sheet | comma |
| “Delivery cost” | The amount added by the matching markup type | 0 |
| “Price multiplicity” | Rounds the price up to a multiple of this number | 0 |
| “Note” | Free text for yourself | empty |
The last two price columns work only together with pricing rules. “Delivery cost” is added to the price if the source’s chain of markup types includes the matching type. “Price multiplicity” rounds the price up to the nearest multiple and takes effect only when it’s greater than one.
In per-sheet mode, the price range, both separators, delivery cost and multiplicity are set only in this grid. The “Prices” section of the source card then doesn’t have these fields; instead, it shows an explanation and the “Import from sheets” button, because the import doesn’t read the card values. Turn the mode off and it’s the other way round: the card values apply, and these grid columns have no effect.
These columns apply only to sheets with at least one column address set: a sheet without addresses is read as empty, so its price range or multiplicity has no effect.
Besides the grid, three more things are tied to the sheet: ignore rules, field formulas and the category structure type. All three open from the “Sheet operations” menu.
What stays shared for the whole workbook regardless of mode: file format, archive password, the auto-fetch schedule, stop rules, pricing rules (except delivery cost), product matching with the catalog and everything else that happens after the file is parsed. A sheet affects only how data is read, not what’s done with it next.
Sheet operations
The “Sheet operations” button above the grid opens a menu with three items. Each one leads to its own window, and each window opens for the sheet you’ve selected.
Two of the three show this in the title: “Settings for sheet: ‹name›”. The “Field formulas” title has no sheet name, although it also opens for the selected sheet. If no sheet is selected, the menu does nothing.
1
Category detection2
Ignore rules3
Field formulas- Opens category detection for the selected sheet, not for the whole source.
- Opens the ignore rules of the selected sheet only.
- Opens the field formulas of the selected sheet only.
- “Category detection”: how to recognize categories on this sheet. This is also where you pick the “Categories have cell formatting” and “Categories have row grouping” types, when categories on the sheet show only through formatting. A type set for a sheet applies when “Configure per sheet” is on; otherwise the type from the source settings is used.
- “Ignore rules”: which items on this sheet to drop at import time.
- “Field formulas”: calculations on this sheet’s values.
Each of the three windows is a separate topic with its own article. What matters here is that in a workbook with a dozen sheets, these settings aren’t shared. An ignore rule you set while on “Laptops” applies to “Laptops”.
What happens if an import is interrupted
A workbook with several sheets is imported in this order. First, the whole file is parsed: each sheet becomes a separate set of rows. Then Elbuz goes through the active sheets one by one.
As soon as the first of them returns at least one row, the source’s old product list is deleted. Rows from this and the following sheets go into temporary storage and are moved to the source’s product list only at the end, after all active sheets are processed.
- Start or end
- Action or result
- Decision: the path depends on the answer
So what’s left of the products after an interruption depends on the step where it happened:
- While the file is being parsed. Deletion hasn’t happened yet: the source keeps the products from the previous import.
- While sheets are being processed. The old list is already deleted, and the new rows aren’t moved yet. Temporary storage disappears with the stopped process, so the source has no products left: neither old ones nor ones from sheets already processed. The source’s product counter shows zero.
- No active sheet returned any rows. Nothing is deleted at all. The log shows “No data received, previous product list will be displayed”, and the previous list stays.
The exception is import stop rules. If at least one of them is on with the “Block” action and the source already has products, the old list is deleted not at the first sheet but only after the new data passes the rule check. An interruption before that point leaves the old products in place.
To stop an import started with the “Import” button, close the “Loading data...” window with the “Cancel” button or the close icon. There’s no separate “close and let it keep loading” option here.
With regular file reading, Elbuz checks for the stop signal after every sheet row, and during the sheet pass, before each next sheet. If the process doesn’t stop on its own within two seconds, Elbuz terminates it. The log shows “Import interrupted by the user!”.
Rerunning the import after an interruption is safe. Each run takes the whole file again and starts by deleting the source’s product list, so rows from the interrupted run aren’t duplicated. While a previous import of the same source is still running, a second one won’t start, and you see “This source is already being imported (started at ‹time›). Wait for it to finish or stop it with the “Stop” button.”
Elbuz considers an import alive if it started less than a minute ago or wrote at least one log line in the last 15 minutes.
How many sheets and rows you can import
- Elbuz doesn’t limit the number of sheets in a workbook. All active ones are imported.
- There’s no separate row limit per sheet. Regular reading goes to the last filled row of the sheet; the only limit is the maximum sheet size in Excel itself.
- The sheet preview shows the first 100 rows, and no more than 100 numbered columns in the header. The import takes the whole sheet, not just what’s visible in the preview.
How long a specific import took is shown in the log. After the file is parsed, the line “Data processed in: ‹time›” is written. Every thousand sheet rows add “Rows loaded: ‹N›”, and at the end comes “Time elapsed: ‹time›” for the whole run.
How to check what was read
There are two checks: before the import and after.
Before. The tab strip at the bottom of the window shows a preview of each sheet found in the latest file. Select a row in the grid, and the same sheet’s tab opens within half a second. It’s the fastest way to see what’s on a tab with an unclear name, and whether there are any products there at all.
After. The run log has a separate line for each sheet read: “Reading data from sheet: ‹name›”. These lines show exactly what the import took. No line for a sheet means it was skipped: either it’s deactivated or it wasn’t found in the file. A line for a sheet you didn’t expect means it’s time to check whether it’s hidden.
Checking a workbook with several sheets
Scenarios
The workbook has price list tabs and service tabs, columns are the same on all sheets
Goal: take products from the price list tabs and skip “Contacts”, “Calculations” and “Delivery terms”.
What to turn on: turn on “Configure per sheet”, clear “Sheet active” on the service tabs in the “Import from sheets” window, and turn the switch off again: column addresses are set once in the source card.
Result: the import skips deactivated sheets, and the log has no “Reading data from sheet” line for them. The shared set of addresses applies to the other sheets. What won’t happen: service sheets won’t disappear from the list and their settings won’t be deleted; you can tick the checkbox again at any time.
The same field is in different columns on different sheets
Goal: on “Smartphones” the price is in column D, on “Laptops” in F, and both sheets must import correctly.
What to turn on: “Configure per sheet” in the “Columns” section of the source card. Then, in the “Import from sheets” window, select each active sheet and set its addresses. The easiest way is the “Column mapping wizard”.
Result: each sheet is read by its own set of addresses. What won’t happen: the shared set from the card isn’t erased; it’s just not used while the switch is on. If at run time the list has no active sheet found in the file with filled-in addresses, the import uses the shared set.
The supplier hides calculation tabs in the workbook
Goal: don’t import products from sheets you can’t see in the Excel tabs.
What to turn on: nothing extra, since Elbuz checks for hidden sheets on every file parse. After the next import, open the “Import from sheets” window and clear “Sheet active” on rows where “Hidden sheet” is ticked.
Result: new sheets hidden in the workbook are added to the list already disabled, and the “Hidden sheet” column shows which existing sheets are hidden. What won’t happen: a sheet that was already active and was hidden by the supplier later stays active; you have to clear “Sheet active” on it yourself.
Don’t lose the source’s products if an import is interrupted
Goal: an interruption in the middle of the sheet pass shouldn’t leave the source with zero products.
What to turn on: for a source that already has products, at least one of the “Import stop rules” with the “Block” action.
Result: the old product list is deleted not at the first sheet but only after the new data passes the rule check. An earlier interruption keeps the old products, and a triggered “Block” rule cancels the replacement, keeping the old data. What won’t happen: on a source’s first import, with no products yet, nothing is postponed: there’s nothing to keep.
What to do when something goes wrong
| What you see | Why | What to do |
|---|---|---|
| “The list of sheets is empty, you may need to load data from the price list to update the information.” | The file has never been parsed, so there’s nowhere to get the sheet list from | Import the file with the “Import” button in the source card or in this window (where the list comes from) |
| There’s no “Import from sheets” link in the card | “Configure per sheet” is off — the link exists only in this mode. If there’s no switch either, the source isn’t in the “Microsoft Excel” format or the file hasn’t been parsed yet | Turn the switch on; if it isn’t there, check “File format” in the card and import the file again (where to find it) |
| “Per-sheet setup mode enabled.” instead of the column grid in the card | The “Configure per sheet” switch is on: there’s no shared grid in this mode | Edit addresses in the “Import from sheets” window, or turn off the switch and go back to the shared set (two sets of addresses) |
| You edit a column address, rerun the import, and nothing changes | The source has two sets of addresses, and the import uses the one chosen by the switch. You edited the other one | Check the switch and edit the set that’s active (two sets of addresses) |
| Products are labeled with one sheet, but their range comes from another | The workbook has a , and its data went into products | Compare the sheet list with the workbook tabs, deactivate hidden sheets and rerun the import (hidden sheet) |
| “Column addresses are not filled in for columns flagged “Consider uniqueness”!” or “Column addresses for loading data from the price list are not filled in!” | First message: columns of active sheets are mapped, but none of them has the “Consider uniqueness” checkbox and a filled-in address. Second: nothing is mapped in active sheets at all; this check runs earlier | Open the sheets window, select the sheet and fill in at least the “Name” address (sheet columns) |
| “Could not parse file: 0 columns. Check the format, selected sheet and header row.” | No headers were read from this sheet: the file wasn’t parsed, or the header row isn’t the first one | Import the file again and check “Load products from row starting from” for this sheet (sheet settings) |
| The “Sheet found in the price list” checkbox is cleared in the grid | The sheet isn’t in the latest file: the supplier removed or renamed the tab | Restore the old name in the file or map the new sheet from scratch; after 15 days the grid row disappears, but the addresses stay (disappeared or renamed) |
| The sheet is in the file, but there are no products from it | “Sheet active” is cleared, so the import skips the sheet | Tick the checkbox, rerun the import, then check the log (which sheets to turn off) |
| “Error: This field already exists!” | A field with this code has already been added to this sheet | Find the field in the grid and fix it instead of adding a second one (sheet columns) |
| “Load error” after toggling “Configure per sheet” | The request failed, and the switch went back to its previous position | Try again; if it keeps happening, it’s the connection, not the settings (per-sheet mode) |
| “Entry deleted” after clicking the trash icon in a sheet row | The sheet was deleted along with its addresses, formulas, rules and the products imported from it | There’s no way to restore it; the sheet reappears empty on the next file parse (deleting a sheet) |
| A browser system dialog with “Status: … Error: …” | The request to save or delete a row didn’t reach the server | Refresh the window and repeat the edit; make sure the value was saved |
FAQ
Why does the list have a sheet that isn’t in my file?
Either it’s hidden in the workbook itself, so you don’t see it in the Excel tabs, and the grid has “Hidden sheet” ticked for it. Or it was in earlier files and disappeared: then its “Sheet found in the price list” checkbox is cleared. More: hidden sheet.
The list of sheets (Excel worksheets) is empty and shows nothing. What should I do?
Import the price list file at least once: Elbuz takes the sheet list from the workbook when parsing it. Click “Import” in the source header and open the window again. If you were looking for an empty email list in Mail, see Mail in Elbuz.
Should I deactivate a sheet or delete it?
Deactivate it. Clearing “Sheet active” removes the sheet from the import just the same but keeps its settings. The trash icon deletes the sheet with its addresses, rules and products, with no undo. More: deleting a sheet.
I mapped addresses for one sheet, but the switch didn’t turn on. Why?
An edit in the grid turns the mode on only when at least two active sheets have filled-in addresses; the wizard turns it on right away. If you mapped one sheet in the grid, turn on “Configure per sheet” manually.
In per-sheet mode, not all sheets are mapped. What happens to the rest?
An active sheet with no filled-in addresses is read as empty: no products from it and no error message either. There’s one exception: if no active sheet has addresses, the safeguard kicks in and the import uses the shared set.
Can I copy addresses from another sheet?
No, there’s no such button: each sheet is mapped with its own set. Set addresses with the column mapping wizard, which also turns on per-sheet mode. More: sheet columns.
Where to find it and who has access
The “Import from sheets” window has no menu item of its own. You open it only from the card of a specific source, and only when “Configure per sheet” is on.
- From the source card
- List of price lists → source → “Settings” → “Columns” → turn on “Configure per sheet” → “Import from sheets”
- Access rights
- the “Import from sheets” window; also the “Settings” tab and the “Columns” section
- Changing sheets
- the right to edit price lists
- Prepare
- an Excel source whose file has been imported and parsed at least once
At first, the header of the “Columns” section has only the “Configure per sheet” switch. Sources in the “Microsoft Excel” format have it as soon as at least one sheet is found in the workbook. Its tooltip: “Column addresses are set for each Excel sheet separately (the “Import from sheets” window). Off — one global set of addresses”.
The “Import from sheets” link appears next to it only after you turn the switch on: the card reloads, and an explanation and the link replace the address grid. While the switch is off, there’s no link — even in a workbook with several sheets.
1
Configure per sheet switch2
Import from sheets button- This switch decides where the import takes column addresses from: one shared set for the whole file or a separate set for each sheet.
- This button opens the window with the list of the workbook's sheets, where each sheet gets its own columns.
, and files have no sheets, so these sources have neither the switch nor the link.
Task route
- In the “Columns” section, turn on “Configure per sheet” and follow the “Import from sheets” linkSource card, “Settings” tab
- Deactivate service sheetsImport from sheets
- Turn “Configure per sheet” back off if columns are the same on all sheetsSource card, “Columns” section
- Set column addresses for each active sheetImport from sheets, then “Column mapping wizard”
- Run the import and check in the log which sheets were readSource card, then the run log
Related topics
- To map the sheet columns themselves: How to map columns in the wizard.
- To filter out a sheet’s items at import time: Ignore rules.
- If categories on the sheet are marked with color or row grouping: How to extract supplier categories from a price list.
- To find the “Reading data from sheet” lines in the log: Price list log.
