node package manager
Stop writing boring code. Discover, share, and reuse within your team. Create a free org ยป

plancha

plancha

A node CLI tool to flatten multi-sheet/tab spreadsheet files. Named for the inimitable tortilla press.

plancha

It'll turn this:

in

. . . into this:

out

Installation

npm install plancha -g

Usage

plancha -i <input .xlsx file>

Arguments

  • -i, --input (REQUIRED) Input filename/path of .xlsx file to be flattened.
  • -o, --output (OPTIONAL) Output filename. If not specified, this will default to the input filename with a _flattened suffix.

Notes

  • This will flatten any hidden sheets along with the visible ones, so be sure you want those included.
  • The assumption that launched this tool is that headers across individual sheets are at least similar/comparable to each other; doublecheck that you're not flattening a table that shouldn't be flattened.

License

MIT