📋How to Import CSV Files into Google Spreadsheets with Google Apps Script

1. Overview

\[ \begin{array}{l} \textbf{You can automatically import CSV files into Google Spreadsheets --} \\ \text{using Google Apps Script to fetch, parse, and insert CSV data.} \\ \textbf{This is useful for automating data imports --} \\ \text{from external systems, cloud storage, or email attachments.} \end{array} \]

2. Core Steps

\[ \begin{array}{ll} \mathbf{Step\ 1:} & \text{Open a Google Spreadsheet where CSV data will be imported.} \\ \mathbf{Step\ 2:} & \text{Go to Extensions} \rightarrow \text{Apps Script.} \\ \mathbf{Step\ 3:} & \text{Write a script to retrieve the CSV file (local, Drive, or URL).} \\ \mathbf{Step\ 4:} & \text{Use Utilities.parseCsv() to convert CSV text into a 2D array.} \\ \mathbf{Step\ 5:} & \text{Clear the target sheet before inserting new data.} \\ \mathbf{Step\ 6:} & \text{Set the array values into the sheet in one batch operation.} \\ \mathbf{Step\ 7:} & \text{Run the script to see the CSV data loaded into your sheet.} \end{array} \]

3. Sample Google Apps Script

// Code.gs
function importCSVFromDrive() {
  var fileId = 'YOUR_CSV_FILE_ID';
  var file = DriveApp.getFileById(fileId);
  var csvData = Utilities.parseCsv(file.getBlob().getDataAsString());
  
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  sheet.clear();
  sheet.getRange(1, 1, csvData.length, csvData[0].length).setValues(csvData);
}

function importCSVFromUrl() {
  var url = 'https://example.com/data.csv';
  var response = UrlFetchApp.fetch(url);
  var csvData = Utilities.parseCsv(response.getContentText());
  
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  sheet.clear();
  sheet.getRange(1, 1, csvData.length, csvData[0].length).setValues(csvData);
}

4. Important Notes

\[ \begin{array}{l} \text{• Utilities.parseCsv() automatically splits text by commas and line breaks.} \\ \text{• Ensure CSV file encoding is UTF-8 to avoid character issues.} \\ \text{• For large CSVs, consider processing in chunks to avoid execution timeouts.} \\ \text{• UrlFetchApp requires enabling "Allow access to external URLs" in project settings.} \\ \text{• You can schedule this import using triggers for automatic updates.} \end{array} \]

5. Conceptual Flow (in LaTeX)

The process can be described as:

\[ \text{CSV File (Drive/URL)} \xrightarrow{\text{Apps Script Parse}} \text{Google Sheets Data Table} \]

Where: \[ \text{Inserted Data} = \{\text{Rows from CSV} \rightarrow \text{Cells in Sheet}\} \]