Question: how to import data into excel pivot table?
Answer: STEP 1: Go to Insert > Tables > PivotTable. STEP 2: Select Use an external data source and click Choose Connection. STEP 3: Select Browse for More. STEP 4: Select the Excel file with your data. ...  STEP 5: Select the first option and click OK. STEP 6: Click OK.