/g-csv

Paste or upload .csv files to Google Sheets

Primary LanguagePythonMIT LicenseMIT

g-csv

Manages .csv files and uploads or pastes them to Google Sheets.

Usage

Installation

With Python installed, and in a command window, enter: pip install gcsv

Code

Use the following code example as a guide, replacing the following dummy strings with relevant information.

  • my_csv_path: the path to your CSV (e.g C:\reports\mycsv.csv)
  • my_spreadsheet_id: the ID (or "key") of a spreadsheet; can be found in the spreadsheet URL after /d/ but before /edit
  • my_worksheet_gid: the worksheet (or "tab") name of the paste destination
  • start_row: the starting row of the paste destination
  • start_col: the starting column of the paste destination
import gcsv

csv = gcsv.GCSV(r'my_csv_path')

csv.paste_to('my_spreadsheet_id',
             my_worksheet_gid,
             start_row,
             start_col)