Thank you! This was a huge help for me. I had found some other code that I couldn't get to work. This gave me exactly what I need. I'm going about it a little bit differently in that I have a specific folder and I need to go through that folder file by file. If the file name is the one I'm looking for then I import the CSV as a new sheet and give it a specific name. Works perfectly!
🎯 Key points for quick navigation: 00:00 *📝 Introduction to CSV files* - CSV is a text file representing a table with elements separated by commas. - CSV files are lightweight and useful for data transfer between software. - Understanding CSV basics is crucial before importing into Google Sheets. 04:30 *📊 How to import CSV into Google Sheets* - Two main methods to import CSV into Google Sheets: uploading directly or using the "Import" function. - Various options available during the import process, like replacing, appending, or inserting the CSV data. - Understanding how Google Sheets handles CSV data alignment and data types upon import. 07:57 *🔄 Automating CSV import using Google Apps Script* - Exploring the concept of automating CSV imports at specific times. - Creating a script to automatically import CSV data into Google Sheets. - Customizing the script for specific needs, like appending data or creating new sheets. 25:49 *📁 Automating CSV Compilation Process* - Demonstrates the ability to compile multiple CSV files into one folder automatically. 26:19 *🔄 Modifying Existing Sheets* - Explains how to import data into an existing sheet instead of inserting a new sheet. - Highlights the option to replace existing data or append new data carefully in Google Sheets. 27:27 *📋 Implementing Automation Methods* - Shows how to create a menu for easy access to importing CSV data in Google Sheets. - Introduces setting up triggers to automate the import process on a daily basis. - Discusses the benefits and considerations of manual versus automatic import options based on the project's specific needs. Made with HARPA AI
Hey I've got a question. How would I go about creating a code you mentioned at 9:48 ? I would like to import a .txt file into a select sheet within my spreadsheet using the import via upload feature.
What if i have a save csv file that will be added to the folder, and i want it to grab the next one and adding it in? Example: cities01.csv, cities02.csv, cities03.csv So 1st of the month it will run to grab the previous month report and compile it in the sheet
I am getting an error "Cannot read properties of undefined (reading 'length') referring to line 19. Any idea how I can fix this? Everything else seems to be working, but it is not actually importing the data, I assume because of this "range / length" problem. Any help would be wonderful.
Thank you! This was a huge help for me. I had found some other code that I couldn't get to work. This gave me exactly what I need. I'm going about it a little bit differently in that I have a specific folder and I need to go through that folder file by file. If the file name is the one I'm looking for then I import the CSV as a new sheet and give it a specific name. Works perfectly!
🎯 Key points for quick navigation:
00:00 *📝 Introduction to CSV files*
- CSV is a text file representing a table with elements separated by commas.
- CSV files are lightweight and useful for data transfer between software.
- Understanding CSV basics is crucial before importing into Google Sheets.
04:30 *📊 How to import CSV into Google Sheets*
- Two main methods to import CSV into Google Sheets: uploading directly or using the "Import" function.
- Various options available during the import process, like replacing, appending, or inserting the CSV data.
- Understanding how Google Sheets handles CSV data alignment and data types upon import.
07:57 *🔄 Automating CSV import using Google Apps Script*
- Exploring the concept of automating CSV imports at specific times.
- Creating a script to automatically import CSV data into Google Sheets.
- Customizing the script for specific needs, like appending data or creating new sheets.
25:49 *📁 Automating CSV Compilation Process*
- Demonstrates the ability to compile multiple CSV files into one folder automatically.
26:19 *🔄 Modifying Existing Sheets*
- Explains how to import data into an existing sheet instead of inserting a new sheet.
- Highlights the option to replace existing data or append new data carefully in Google Sheets.
27:27 *📋 Implementing Automation Methods*
- Shows how to create a menu for easy access to importing CSV data in Google Sheets.
- Introduces setting up triggers to automate the import process on a daily basis.
- Discusses the benefits and considerations of manual versus automatic import options based on the project's specific needs.
Made with HARPA AI
Thank you for the index!
Kind Regards
ReferenceErrir: is not defined how ?
Hey I've got a question. How would I go about creating a code you mentioned at 9:48 ? I would like to import a .txt file into a select sheet within my spreadsheet using the import via upload feature.
I will very soon do a part 2
Kind Regards
What if i have a save csv file that will be added to the folder, and i want it to grab the next one and adding it in?
Example: cities01.csv, cities02.csv, cities03.csv
So 1st of the month it will run to grab the previous month report and compile it in the sheet
I will do part 2 very soon
Kind Regards
thanks so much!
this tutorial help me a lot
I'm glad it did!
I am getting an error "Cannot read properties of undefined (reading 'length') referring to line 19. Any idea how I can fix this? Everything else seems to be working, but it is not actually importing the data, I assume because of this "range / length" problem. Any help would be wonderful.
May it be that your data has no rows?
Regards!
How to import TSV file?
hmmm
I think it should work similarly, but haven´t tried it.
You may start by removin or modifyinf this condition
if (type == "text/csv")
Regards!