Cutter is a simple cli program for cutting large text/csv files into chunks that are digestible by Excel.
Excel can only open files that have approximately a million rows or less. Files bigger than that fail to open.
Cutter solves this problem by:
- Splitting a large text file into numbered chunks, each a million rows or less
- Preserving the column headers on each chunk
What makes cutter different from the POSIX split command?
- It automatically defaults to Excel friendly defaults
- No need to futz around with command line arguments
- File chunks are automatically renamed to the original file name, followed by
_part1,_part2, instead ofxaa,xbband etc.. - Drag and drop works in windows
- Save
cutter.exeinto a folder - Drag and drop the file you want to split onto
cutter.exe
The split chunks will be safely deposited in the folder from which you dragged over the file.
If you want to use the terminal:
Usage: cutter.exe [options] <filename>
Options:
-v, --version Print version information and exit
-h, --help Print this message and exit
- Go to Latest Release
- Under Assets, locate the file ending in
_Windows_x86_64.zip - Download it
- Double click on the downloaded file
- Drag
cutter.exefile to a desired folder (eg. Desktop)
Now you can drag and drop files onto cutter.exe to split them.
To install cutter on your system you can use one of the following methods:
You can install cutter using go install:
go install github.com/maciakl/cutter@latestUse grab:
grab maciakl/cutterUse scoop:
scoop add maciak https://github.com/maciakl/bucket
scoop update
scoop install cutter