{"id":6813,"date":"2024-01-02T14:47:15","date_gmt":"2024-01-02T14:47:15","guid":{"rendered":"https:\/\/www.garysieling.com\/blog\/?p=6813"},"modified":"2024-01-02T14:47:15","modified_gmt":"2024-01-02T14:47:15","slug":"import-a-folder-of-csvs-into-a-single-google-sheet-1-per-tab","status":"publish","type":"post","link":"https:\/\/www.garysieling.com\/blog\/import-a-folder-of-csvs-into-a-single-google-sheet-1-per-tab\/","title":{"rendered":"Import a folder of CSVs into a single Google Sheet (1 per tab)"},"content":{"rendered":"\n

Got this from ChatGPT and tested.<\/p>\n\n\n\n

Go to apps script:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Paste the script below, add your folder ID, and save. The folder ID can be obtained from the URL to the folder:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Then, click Run – you will have to go through several security prompts to agree to trust the script.<\/p>\n\n\n\n

function importCSVFiles() {\n  var folderId = '1_ZVuufw69Ns9ZeOCdxWwN0GqJrSl9YgO';\n  var sheet = SpreadsheetApp.getActiveSpreadsheet();\n  var folder = DriveApp.getFolderById(folderId);\n  var files = folder.getFiles();\n\n  while (files.hasNext()) {\n    var file = files.next();\n    var csvData = Utilities.parseCsv(file.getBlob().getDataAsString());\n    var sheetName = file.getName().replace(\/\\.csv$\/, ''); \/\/ Remove '.csv' from the sheet name\n    var existingSheet = sheet.getSheetByName(sheetName);\n\n    if (existingSheet) {\n      existingSheet.clear(); \/\/ Clear existing sheet content\n    } else {\n      sheet.insertSheet(sheetName); \/\/ Create a new sheet if it doesn't exist\n    }\n\n    var targetSheet = sheet.getSheetByName(sheetName);\n    targetSheet.getRange(1, 1, csvData.length, csvData[0].length).setValues(csvData);\n  }\n}<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
Got this from ChatGPT and tested. Go to apps script: Paste the script below, add your folder ID, and save. The folder ID can be obtained from the URL to the folder: Then, click Run – you will have to go through several security prompts to agree to trust the script.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[6],"tags":[],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t