Go to theHometab and click on theClose and Loadicon. Choose where you want to load the result (e.g., a new worksheet). A new window namedImport Datawill open, from that window, chooseExisting worksheetfromWhere do you want to put the data?option. After that choose the location of th...
The CSV file gets loaded in the given worksheet (i.e., VBA). The macro uses commas as the separation delimiter to distribute the data into columns.Read More: How to Import CSV Data into Excel Download the Excel WorkbookCustomer Info.csv Import CSV into Existing Sheet.xlsm ...