spreadit

spreadit

spreadit is a simple CLI tool to write CSV data to Google Sheets.

Usage

spreadit --id <spreadsheet_id> --title <title> [--file <file>] [--range <range>] [--append]

Examples

# specify csv file
spreadit --file data.csv --id 1X2Y3Z4W5V6U7T8S9R0Q --title 'New Sheet'

# or pipe data
cat data.csv | spreadit --id 1X2Y3Z4W5V6U7T8S9R0Q --title 'New Sheet'

# or redirect into stdin
spreadit --id 1X2Y3Z4W5V6U7T8S9R0Q --title 'New Sheet' < data.csv

Options

Config file

You can specify the default options in the config file.

# ~/.config/spreadit/.spreadit.yaml
id: 1X2Y3Z4W5V6U7T8S9R0Q
title: New Sheet
file: data.csv
range: A1
append: true

Config file is searched in the following order:

1. --config option
2. $CURRENT_DIR/.spreadit.yaml
3. $XDG_CONFIG_HOME/spreadit/.spreadit.yaml
4. $HOME/.config/spreadit/.spreadit.yaml when $XDG_CONFIG_HOME is not set
5. $HOME/.spreadit.yaml

YAML, JSON or TOML format is supported.

Requirements

spreadit requires the following environment variables to be set:

• GOOGLE_APPLICATION_CREDENTIALS: path to the service account key file

See here for more details.

Install

You can install spreadit using the following command:

go install github.com/haijima/spreadit@latest

or you can download binaries from Releases.

License

This tool is licensed under the MIT License. See the LICENSE file for details.