> ## Documentation Index
> Fetch the complete documentation index at: https://basedash.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Tables

> Browse and analyze your data in a familiar spreadsheet interface

Basedash provides a powerful table view that lets you explore your raw data in a familiar spreadsheet-like interface. While you can't edit the data directly, you have all the tools needed to efficiently browse, search, and analyze your data.

![The orders table from the Acme warehouse in Basedash, with the table list on the left and rows showing ID, channel, customer ID, discount, and status](https://mintcdn.com/basedash/aH3kb-Bl5OLwdg2n/images/features/tables/hero.webp?fit=max\&auto=format\&n=aH3kb-Bl5OLwdg2n\&q=85\&s=e258137e6b911788cb51ee895db2e7bc)

## Features

### Data browsing

* View any table in your database
* Automatic data type detection and formatting

### Search and filter

* Full-text search across all columns
* Advanced filtering with multiple conditions
* Search history for quick access

### Column management

* Reorder columns via drag and drop
* Hide/show columns
* Sort by multiple columns
* Pin columns to left
* Resize column widths

### Data formatting

* Automatic formatting based on data types:
  * Dates and timestamps
  * Numbers and currencies
  * URLs and email addresses
  * JSON and arrays
  * Boolean values

## Best practices

1. **Efficient browsing**
   * Use filters to narrow down data
   * Pin frequently used columns
   * Hide unused columns

2. **Performance**
   * Start with filtered views for large tables
   * Leverage quick filters for common queries

3. **Organization**
   * Document special columns or data types

## FAQ

> [accordion] Can I edit rows in a table?
>
> No. Tables are read-only. To change data, edit it in your database, or ask
> [chat](https://basedash.com/docs/features/accuracy-and-trust.md#read-only-by-default) to propose a
> change on a data source that supports approved writes.

> [accordion] Is the data live?
>
> Yes, tables query your data source when you open them and load 100 rows at a
> time as you scroll. If [query
> caching](https://basedash.com/docs/administration/organization-settings.md#query-caching) is on, you may
> see cached results first. Use **Refresh data** to query again.

> [accordion] Can I export a table?
>
> Yes. Open **Copy or export data** in the table's footer and export as CSV,
> JSON, Excel, or Markdown. Exports keep your filters, sorting, and column
> order, use fresh data, and include up to 1,000,000 rows.

> [accordion] Why don't I see a table or column?
>
> If it's new, click **Sync schema** at the top of the table list. It may also
> be [hidden](https://basedash.com/docs/administration/data-visibility.md), or an admin may have limited
> your [access](https://basedash.com/docs/administration/data-source-access-control.md). See
> [Troubleshooting](https://basedash.com/docs/help/troubleshooting.md#connecting-a-data-source).

> [accordion] Can view-only members browse tables?
>
> No. The **Data** page and table exports are for admins and members.
> View-only members can open charts and dashboards that are shared with them.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.