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
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
thanks so much!
this tutorial help me a lot
I'm glad it did!
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
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!