Excel 시트별 분할

데이터 배포 — 회사 전체 통합 문서 대신 각 부서에 해당 시트만 보내세요.

너무 큰 통합 문서 — 느리고 무거운 파일을 빠르게 열 수 있는 집중된 조각으로 나눕니다.

시스템 가져오기 — 파일당 하나의 테이블만 허용하는 도구도 분할하면 정확히 맞습니다.

Two very different jobs share the word split, so make sure you are on the right page:

• Split Excel (this page) — takes one workbook and writes every sheet out as its own .xlsx file, packed into a single zip. Use it when a workbook is really several reports stapled together under one file name.
• Split Excel by column — keeps one sheet intact but breaks it into multiple files based on the values in a column you choose, for example one file per region, department, or salesperson.
• Filter rows in Excel — when you only need one slice rather than many files, filter the rows by a condition and export just the matching records.
• Extract unique values — not sure which values a column contains before splitting on it? List the distinct values first, then decide how to partition the data.
• Merge Excel files — the reverse operation: combine many workbooks back into one file with each sheet preserved as its own tab.

The workbook is parsed once, as soon as you drop it in, and the sheet list appears immediately. Each sheet is exported as a complete, valid workbook that opens on its own in Excel, LibreOffice, or Google Sheets — no shared dependencies and no broken references back to the original file.

Output files follow a predictable naming pattern: the original file name, a dash, and the sheet name, so a file named report.xlsx with sheets North and South becomes report-North.xlsx and report-South.xlsx inside one zip archive. Hidden metadata sheets used internally by the editor are excluded, and everything runs locally in your browser — your data never leaves the device.