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.