IA sur votre appareil : performant et privé.

Tutoriels

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.

Durée: 3:09Publié le:

Ce que vous allez apprendre

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

Dans cette vidéo

  1. 0:00Six hundred orders, one workbook
  2. 0:23What it reads
  3. 0:45By row count
  4. 1:03By column value
  5. 1:23By date range
  6. 1:38The Free limit
  7. 1:53What you get
  8. 2:06Three jobs
  9. 2:24Free and Pro
  10. 2:40Nothing is uploaded

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.

Transcription complète

Chaque mot de la vidéo, à lire, à chercher ou à parcourir.

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.

Abonnez-vous pour les nouveaux tutoriels

De nouveaux tutoriels chaque semaine. Outils gratuits, rien n'est envoyé.