spreadsheet-splitter

0.1.0 verified Sat May 09 auth: no python

A command-line tool to split large Excel files (.xls/.xlsx) into smaller chunks with low memory usage. Version 0.1.0, requires Python >=3.13. Initial release, no breaking changes yet.

pip install spreadsheet-splitter

Common errors

error ModuleNotFoundError: No module named 'spreadsheet-splitter' ↓

cause Trying to import using the PyPI name with hyphens instead of the correct module name with underscores.

fix

Use 'import spreadsheet_splitter' or 'from spreadsheet_splitter import split_spreadsheet'.

error ImportError: cannot import name 'split_spreadsheet' from 'spreadsheet_splitter' ↓

cause The function may be named differently or not exported. Check the documentation.

fix

Verify the exact function name in the library's documentation; currently 'split_spreadsheet' is correct.

Warnings

gotcha The module name uses underscores (spreadsheet_splitter) not hyphens (spreadsheet-splitter). Importing with hyphens will fail. ↓

fix Use 'from spreadsheet_splitter import split_spreadsheet'.

gotcha Requires Python >=3.13. Older Python versions will fail to install or run. ↓

fix Upgrade Python to 3.13 or later.

Imports

split_spreadsheet

wrong

from spreadsheet-splitter import split_spreadsheet

correct

from spreadsheet_splitter import split_spreadsheet

Hyphens are not valid in Python module names; use underscores.

Quickstart

Splits 'large.xlsx' into files with 1000 rows each, placed in the 'chunks' directory.

from spreadsheet_splitter import split_spreadsheet
split_spreadsheet('large.xlsx', chunk_rows=1000, output_dir='./chunks')