CLI tool to search text in XLSX, XLS, CSV, TSV and ODS files. It works similarly to Unix\GNU Linux grep.
xlsxgrep is a CLI tool to search text in XLSX, XLS, CSV, TSV and ODS files. It works similarly to Unix/GNU Linux grep.
Grep compatible: xlsxgrep tries to be compatible with Unix/Linux grep, where it makes sense. Some of grep options are supported (such as
Search many XLSX, XLS, CSV, TSV and ODS files at once, even recursively in directories.
Regular expressions: Python regex.
Supported file types: csv, ods, tsv, xls, xlsx
usage: xlsxgrep [-h] [-V] [-P] [-F] [-i] [-w] [-c] [-r] [-H] [-N] [-l] [-L] [-S SEPARATOR] [-Z] pattern path [path ...] positional arguments: pattern use PATTERN as the pattern to search for. path file or folder location optional arguments: -h, --help show this help message and exit -V, --version display version information and exit. -P, --python-regex PATTERN is a Python regular expression. This is the default. -F, --fixed-strings interpret PATTERN as fixed strings, not regular expressions. -i, --ignore-case ignore case distinctions. -w, --word-regexp force PATTERN to match only whole words. -c, --count print only a count of matches per file. -r, --recursive search directories recursively. -H, --with-filename print the file name for each match. -N, --with-sheetname print the sheet name for each match. -l, --files-with-match print only names of FILEs with match pattern. -L, --files-without-match print only names of FILEs with no match pattern. -S SEPARATOR, --separator SEPARATOR define custom list separator for output, the default is TAB -Z, --null output a zero byte (the ASCII NUL character) instead of the usual newline.
xlsxgrep -i "foo" foobar.xlsx
xlsxgrep -c -H "(?i)foo|bar" /folder
pip install xlsxgrep
Release history Release notifications | RSS feed
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Hashes for xlsxgrep-0.0.29-py3-none-any.whl