# Working With Large Data

Arcwise connected data tabs can have millions, or even billions, of rows. If you went through the process in [Connecting data](/connecting-data/connecting-data.md) and the result had more than 200,000 cells then **your Arcwise connected data tab will only display 100 rows**. This data is a preview.

You can work with large data in nearly the same way as normal data. You can use all the functionality available for Arcwise connected data tabs. See [Overview](/arcwise-setup/integrations/overview.md).

{% content-ref url="/pages/4MhQxTzyKlRbRAcB4q71" %}
[Adding Columns](/using-arcwise-in-sheets/arcwise-connected-data/adding-columns.md)
{% endcontent-ref %}

{% content-ref url="/pages/3SeHnU1cK8FnIjrpBYA2" %}
[Filtering](/using-arcwise-in-sheets/arcwise-connected-data/filtering.md)
{% endcontent-ref %}

{% content-ref url="/pages/oVn4IxVynBRvtOhNB3t3" %}
[Sorting](/using-arcwise-in-sheets/arcwise-connected-data/sorting.md)
{% endcontent-ref %}

{% content-ref url="/pages/T67I8XOJ4viF4Fqykr81" %}
[Pivot Tables](/using-arcwise-in-sheets/pivot-tables.md)
{% endcontent-ref %}

{% content-ref url="/pages/qq49bpFdPmAWobFw4QrR" %}
[Creating Manual Visualizations](/using-arcwise-in-sheets/creating-manual-visualizations.md)
{% endcontent-ref %}

## Suggestions for working with large data

{% hint style="info" %}
The easiest way to work with large Arcwise data is to use the AI analyst. The AI analyst works especially well when your data is large.
{% endhint %}

When working with large data you can only see a 100 row preview in the sheet. It is useful to add sorting and filters to observe different values of the data. Additionally, you can apply pivot tables to aggregate the data and make it small enough to fit within a standard spreadsheet tab.


---

# Agent Instructions: 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://docs.arcwise.app/using-arcwise-in-sheets/working-with-large-data.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.