Upload txt file data (in CSV form) to Google Sheet

Get help with using AutoHotkey (v1.1 and older) and its commands and hotkeys
rc76
Posts: 155
Joined: 07 Nov 2020, 01:45

Upload txt file data (in CSV form) to Google Sheet

Post by rc76 » 30 Apr 2024, 04:21

Is there anyway we can upload a txt file's data (which already in CSV format) on your local C:\ to your google sheet on the cloud?

Any example of how I can get started will be super awesome!

User avatar
boiler
Posts: 17706
Joined: 21 Dec 2014, 02:44

Re: Upload txt file data (in CSV form) to Google Sheet

Post by boiler » 30 Apr 2024, 06:15

You mean you want a script to do it rather than manually going to File > Import in Google Sheets?

rc76
Posts: 155
Joined: 07 Nov 2020, 01:45

Re: Upload txt file data (in CSV form) to Google Sheet

Post by rc76 » 30 Apr 2024, 10:32

Yes, because it will be on a frequent basis of importing (on an hourly basis).

So prefer to automate the process.

rc76
Posts: 155
Joined: 07 Nov 2020, 01:45

Re: Upload txt file data (in CSV form) to Google Sheet

Post by rc76 » 30 Apr 2024, 11:55

Basically i wish:
(1) From every hour's txt's line items (in CVS format), to append each line item to a google sheet's particular tab.
(2) Only append onto google sheet, not replacing it.

Post Reply

Return to “Ask for Help (v1)”