Import data from a CSV file to your Google Spreadsheet

I’m trying to read a CSV file saved in my Google Drive and copy data to my Google Spreadsheet.

Imagine my CSV file’s name is “singleColumn.csv” and it is located in my Google Drive folder. If you want to get your drive folder id see here; How to find your Google Drive folder ID.

This is how my CSV file looks like;

csv

Go to your Spreadsheet, open your Script Editor, Write functions below.

These functions will search your drive folder for given file name (singleColumn.csv) and read it. Then paste data row by row on your Spreadsheet.

Contact me if you need further improvements and changes.

Cheers!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s