Consolidate every tab of an Excel workbook into one table
Use “Consolidate every tab of an Excel workbook into one table” in Recued. Reads every worksheet, including hidden ones, and appends one summary row per tab to a table you nominate.
How it works
Inspect the data fetches, transforms, gates, and output this recipe runs.
Process (24 steps)
session_raw
?
session_id
default
Apply default
session_persists
compare
Check if session raw result persistChanges does not equal false
have_persistent_session
template
Generate text from a template
fail: step.session_persists equal false
sheets_raw
?
sheets
default
Apply default
have_sheets
template
Generate text from a template
fail: step.sheets is_empty
sheet_count
count
Count items in sheets
hidden_sheets
filter
Filter by condition
hidden_count
count
Count items in hidden sheets
ranges
?
stats
map
Extract from each item
usable
filter
Filter by condition
read_count
count
Count items in usable
every_sheet_read
compare
Check if read count equals sheet count
total_rows
sum
Sum values in
total_cells
sum
Sum values in
values
map
Extract from each item
value_row_count
count
Count items in values
have_values
template
Generate text from a template
fail: step.values is_empty
append
?
close
?
card
to_summary
Format results as a summary card
preview
to_table
Format results as a data table
Settings
Configurable at install. Defaults shown — change them anytime in Recued.
item id
setting
=
[object Object]
drive id
setting
=
[object Object]
microsoft
setting
=
target table id
setting
=
[object Object]
Trust & control
What installing this recipe would let it do. Recued grants these permissions at install — review them there before approving.