Answer the question
In order to leave comments, you need to log in
How to import txt file with given delimiter options to google spreadsheet using script?
You need to import a txt file that looks like this
in google spreadsheets to get it like this
There is a script that only imports but does not set the settings
function importCSVFromGoogleDrive() {
var file = DriveApp.getFilesByName("programs-list.csv").next();
var csvData = Utilities.parseCsv(file.getBlob().getDataAsString());
var sheet = SpreadsheetApp.openById('ID').getSheetByName('Import');
sheet.getRange(1, 1, csvData.length, csvData[0].length).setValues(csvData);
}
Separator Type: Automatic
Convert Text to Numbers and Dates: No
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question