Import automatically CSV file to Google Sheets (updated version in description)

Learn here how to automatically import CSV into a Google Sheet with Sheetgo. Useful to use a CSV file from statistical software in Google Sheets for visualization.

If you use CSV format to process huge amounts of data but need Google Sheets' functionalities to visualize and report from that data, create an automatic connection between the two.

____________________________________________

____________________________________________

[chirondragon]

I have an issue when importing the airport.csv file for flight simulation, we have all countries added but some of the show the unrecognized character � or ?, how to correctly import the csv file to prevent this, please.

[ailenviennesebastian]

Is there any way to import text files (not CSV files), a novel to be exact, into the google sheet using google app script?

[johnbezos]

i want to import the cvs file from a google trend search, any idea how to do this?

[MrElmujo]

Thank you very much, sheetgo is very useful and it helped with my issue.

[nacchuful]

I just cannot found how to setup delimiter. Bcoz mostly im using pipe as delimiter.

[joaocarlos]

Hello great class, congratulations could you inform if it is possible to send a ready.csv file to google drive?

[alisadate]

Hi Dear,
I have an issue with the size of my file. On my excel sheet i have around 40 000 line and I try every way even yours but still doesn't work.. Do you have any ideas ?

Thank you for your videos

Ali

[kyefang]

Does the Gsheet get automatic update if you change the linked csv file?

[nedh.]

Does this only work on a Windows OS computer? I can't get it to work on my google drive on my Mac. Doesn't follow this and/or even if I highlight the file, SheetGo doesn't allow me to select it.

[cullenpatel]

Can you specify a folder instead of a file for auto import. I want to run a report every 2 hours or so and have that file available automatically in google sheets for viewing but still have the old ones available for reviewing.

[vipralarajesh]

i have csv file for word press website. But my developer says that it's not in word press format for auto import data. Need your recommendations.

[marcpennings]

I regularly get a hours.csv send to me by email. When however I replace the hours.csv (delete the old, copy the new) on my Google Drive, the workflow remains to point to the original file, which is now in the Trash.
What am I doing wrong?

[danielstech]

I installed the addon, gave all the rights it wanted, but once I have tried to use it, it would get stuck in a continuous loop of loading. I've tied following all the instructions I could find on how to fix it, with no success. I've also tried to reach the online support, with nobody there (only a chatbot). This is a big disappointment for me.

[Antonio]

I see the csv file on drive but can't upload it, that option does not exist, just direct accest to drive but sheets doesn't recognize nothing

[chetansoni]

can we copy the data from CSV files to GoogleSheets?
let's say,
If, my file deleted from my PC. but still, I want my previous data to be stored/recorded somewhere.

[paullauraRealestates]

Hi Can it be sync back from google sheet to csv file? for example if I edit google sheet and it will go to CSv automatically?

[nicolecaday]

Can you import csv file and place the data in the same columns in google sheet? Ex. All the price from csv column to the price column in google sheet?

[nunnonugroho]

BS, this is not free. Useless, I can't even simply import data from Excel. It said "Excel as data source is a Advanced feature
Excel as data source is only available to Advanced Plan."

[christinadunham]

Followed the instructions step-by-step, but no data is displaying in the Google Sheet. Any ideas?

[mesalesme]

why doesn't it download... I go to add-on store, find sheetgo, hand over the rights to my life, and then ... nothing.... it doesn't show up in add ons