Script to convert CSV to table

Pierre73 

Example how to change the code to format the cells in email column as hyperlinks:

async function main(context: Excel.RequestContext) {
  // Get the file from OneDrive
  let response = await fetch("<YOUR_FILE_URL>");
  let csvData = await response.text();

  // Get the current worksheet
  let sheet = context.workbook.worksheets.getActiveWorksheet();

  // Split the CSV data into rows
  let rows = csvData.split("\n");

  // Loop through each row
  for (let i = 0; i < rows.length; i++) {
    // Split the row into columns
    let columns = rows[i].split(",");

    // Loop through each column
    for (let j = 0; j < columns.length; j++) {
      // Set the value of the cell
      sheet.getCell(i, j).values = [[columns[j]]];

      // Format the email column as a hyperlink
      if (j === 2 && i > 0) {
        sheet.getCell(i, j).hyperlink = `mailto:${columns[j]}`;
        sheet.getCell(i, j).format.font.color = "blue";
        sheet.getCell(i, j).format.font.underline = "Single";
      }
    }
  }

  // Create a table from the data
  let table = sheet.tables.add(sheet.getUsedRange().getAddress(), true);
  table.getHeaderRowRange().format.fill.color = "#4472C4";
  table.getHeaderRowRange().format.font.color = "white";

  await context.sync();
}

Just hope the file isn't in OneDrive.