> For the complete documentation index, see [llms.txt](https://www.rforseo.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://www.rforseo.com/rpivottable.md).

# Explore data with rPivotTable

[rpivotTable](https://cran.r-project.org/web/packages/rpivotTable/vignettes/rpivotTableIntroduction.html) is a great package by Enzo Martoglio that allows you to explore a small dataset using an HTML drag\&drop interface that looks like the pivot interface from Google Sheet or Excel.

## Install and load rPivotTable <a href="#id-4-explore-crawled-data-with-rpivottable" id="id-4-explore-crawled-data-with-rpivottable"></a>

as usual the instruction are quite straightforward

```r
#install package rpivottable to be done once
install.packages("rpivottable")
# And loading 
Library(rpivottable)
```

Imagine you want to explore a data frame called MERGED ( see [how to create a data frame using a CSV file](/export-data/send-and-read-seo-data-to-excel.md#read-your-data-from-a-csv) )

**Its just one line of code**

```r
# launch 
rpivotTable(MERGED)
```

it will open an HTML page, and you'll be able to drag and drop KPIs from the left column

![This create a drag & drop pivot explorer](https://www.gokam.co.uk/wp-content/uploads/2020/08/LgfVsFu6NL.gif)

You can also use the top dropdown list to make it display a plot instead of a table.

![It’s also possible make some quick data viz](https://www.gokam.co.uk/wp-content/uploads/2020/08/UmtYC25Kdh.gif)

To easily sort

![](/files/-MZvmSpYC2Ao60vHrGmU)

and filter

![](/files/-MZvmaGdTHANQKXQ5rKP)

[Here is a demo HTNL file ](https://www.gokam.co.uk/rpivottable.html)to try it yourself.