Upload Csv To Google Sheets Using Gspread

I have a Json object which needed to be uploaded to the Google Spreadsheet. I have searched and read various resources but could not find the solution. Is there a way to upload obj

Solution 1:

You can import CSV data using gspread.Client.import_csv method. Here's a quick example from the docs:

import gspread

# Check how to get `credentials`:# https://github.com/burnash/gspread

gc = gspread.authorize(credentials)

# Read CSV file contents
content = open('file_to_import.csv', 'r').read()

gc.import_csv('<SPREADSHEET_ID>', content)

This will upload your CSV file into the first sheet of a spreadsheet with <SPREADSHEET_ID>.

NOTE

This method removes all other worksheets and then entirely replaces the contents of the first worksheet.