Split an Excel File, Every Setting: Sheets, Rows, Values, Dates (Free)
Every setting of the free Excel splitter on a 600-order workbook: by Sheet (4 files), by Row count (100 orders a file → 6 files, the header repeated in each), by Column value (one file per sales channel, plus one for the 15 orders with no channel so none go missing), by Date range (January to June → 6 files), and a split by day refused before it runs — 181 files, over the Free limit of 50. Three jobs. Nothing is uploaded.
Duração: 3:09Publicado:
O que vai aprender
By sheet: one workbook per sheet
By row count: 100 orders a file, header repeated
By column value: one file per channel (+ blanks)
By date range: one file per month
The Free limit: 50 files a split, said up front
Three jobs: teams, months, row-limited imports
Neste vídeo
Every setting of the free Excel splitter on a 600-order workbook: by Sheet (4 files), by Row count (100 orders a file → 6 files, the header repeated in each), by Column value (one file per sales channel, plus one for the 15 orders with no channel so none go missing), by Date range (January to June → 6 files), and a split by day refused before it runs — 181 files, over the Free limit of 50. Three jobs. Nothing is uploaded.
Split Excel, every setting, on a small studio's order ledger: 600 orders from January to June across four sheets. By Sheet makes one workbook per sheet you tick. By Row count cuts one sheet into equal pieces — 100 orders a file makes six files of 101 rows, because the header row is repeated in each. By Column value makes one file per distinct value: splitting on the sales channel gives web shop, markets, stockists and commissions, plus a fifth file for the 15 orders with no channel, so nothing is lost. By Date range groups a real date column by year, month or day: by month, six files. By day would be 181 files, and the plan says so before you press anything — over the Free limit of 50 — so the button stays off. Free splits one workbook of up to 25 MB into as many as 50 files; Pro goes to 2,000, adds CSV output and custom file names. Nothing is uploaded.
Transcrição completa
Cada palavra do vídeo, para ler, pesquisar ou percorrer.
600 orders · one workbook
Split Excel, every setting: by sheet, by row count, by the values in a column, and by date — and which to use for what. Free, and nothing is uploaded.
Formatting kept · 4 sheets
Split by Sheet · 4 files
Row count 100 · 6 files
Column value: Channel · 5 files
Date range by month · 6 files
181 files · over the Free limit of 50
Each part as .xlsx · ZIP
One report per team · Column value
Monthly files · Date range
An import with a row limit · Row count
Free: one workbook · 25 MB · 50 files
None of it left the browser. This is its own record of everything it fetched while all of that ran — not one request carried the workbook.
Free, no account, nothing uploaded. Bring your own workbook — and I will see you in the next one.
Subscreva para novos tutoriais
Novos tutoriais todas as semanas. Ferramentas gratuitas, sem enviar nada.