Exporting data from PowerPivot

  • Select all the PowerPivot table
  • Copy the data
  • Past the data in a text file (for example PPtoR.txt)
  • Read the text file in R using tab delimiter: read.table("PPtoR.txt", sep="\t"...)