> 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.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://www.rforseo.com/rpivottable.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.