About SeekTable web pivot tables for sharing & embedding

No matter if your data is in Excel, CSVs, or a database, SeekTable turns your raw numbers into clear, actionable insights and helps you track every part of your business, from sales and finance to production and audits:

• What happened?
  Generate automated daily, weekly, and monthly reports to stay on top of your operations without the manual work.
• When and Who?
  Compare performance across different time periods. Quickly identify trends and see exactly who or what is driving your numbers.
• How much?
  Instantly summarize your sales, profits, inventory, or billable hours in the real time. Get the big picture or dive into the details with one click.

You can get answers on these questions in seconds simply by uploading your data file into SeekTable and create useful reports in a easy-to-use reports builder or simply ask your questions via AI-powered capabilities. Configured reports may be saved, exported to PDF or Excel file (preserving the layout), shared to other SeekTable users, published to web and embedded into any web page. You can automate reports generation and deliver them on schedule.

SeekTable usage is not limited only to pivot tables: it is also good for basic charts and usual flat table reports as well.

Supported Data Sources

• CSV/TSV/Excel/DBF files
• SQL connectors: SQL Server, MySql (MariaDB, SingleStore, MindsDB), PostgreSql (Amazon Redshift, QuestDB, cube.js), Oracle, ClickHouse, Google BigQuery, Snowflake, PrestoDB/Trino, DuckDB/MotherDuck, Teradata, Databricks, SAP HANA
• MongoDb (+ protocol compatible cloud services: Amazon DocumentDB, Azure Cosmos DB)
• ElasticSearch
• XMLA OLAP server endpoints (SSAS, icCube)

Reports based on CSV data may be refreshed simply by uploading a newer version of the file.

When a database is used as a data source you always get actual data which makes SeekTable perfect for live (operational) reports; if your dataset is too large for direct queries you may use report parameters to apply filters by indexed column(s), use pre-aggregated data views or consider to use a specialized data warehouse.

Note: initial setup of DB-based cubes requires some IT knowledge. In particular, you should be able to specify a connection string and allow incoming connections from SeekTable's server; in the case of SQL DB you need to know how to query your data. If you're not sure how to do that you may ask your IT or DB administrator to help you.

Web Pivot Table Features

Pivot tables is a great way to explore your data - even if you're not quite sure what you're looking for yet. No IT background needed, it is enough to understand basic pivot table concepts. Advanced capabilities are supported as well:

• Multi-level grouping (several dimensions per rows or columns), totals/sub-totals (configurable).
• Several values (measures) in one table
• Sort table by values, subtotals or labels
• Quick table filtering in Excel-like or search-like manner
• Select cell ranges and copy selection into the clipboard (as in Excel)
• Customizable dimension/measure labels, numbers formatting and table styles.
• Easy data exploration with drill-down function and expand/collapse mode
• Pivot charts: bar, stacked bar, horizontal bar, line, scatter, area, pie, donut
• Server-side pagination for large pivot tables (thousands of rows or columns), top/last N rows/columns limits
• Value calculations: percentage of grand total/row total/column total, difference from prev/next row/column, differences as percentages, running totals
• Heatmaps (highlight max values)
• Custom expressions (formulas) are supported for both dimensions and measures. Conditional HTML formatting for table's cells.
• A matrix can display consolidated data combined from multiple data sources (external lookups, combined measures)

Flat Table Features

You can use flat table reports to display raw (unaggregated) records.

• Choose what columns to display
• Sort by column and simple filter by columns (applied in data source query)
• Server-side pagination: prev/next or "show more"
• It is possible to link cells to create custom navigation between reports

Sharing/Export Features

• Both pivot tables and flat tables may be exported to PDF, CSV, Excel, JSON or plain HTML. Pivot tables may be exported to Excel PivotTable (2 worksheets: report's aggregated data + Excel PivotTable that displays it).
• Excel exports support colors and links configured with HTML formatting.
• Paginated PDF exports may include up to 50,000 rows. This limit can be increased in self-hosted SeekTable.
  PDF export of published report may be customized with CSS rules + custom title HTML (this requires "Advanced publishing" subscription). PDF footer may be customized in self-hosted SeekTable with activated white-label mode.
• You can automate reports generation and deliver them on schedule:
  • use built-in "Subscribe" function
  • setup tasks in 3rd party automation platforms: Zapier, MS Power Automate, Integromat
  • via SeekTable web API
• Reports may be published to web with a public link and embedded into any web page with IFRAME. Secure embedding with row-level security is supported in the self-hosted version.
• Cubes/reports maybe shared with other SeekTable users in a secure way with "Team sharing" capability.

AI Features

• Ask Data: search-driven reporting capability that helps users start ad-hoc data analysis simply by typing a natural language query.
• Semantic search: useful when users can access many cubes. By simply typing a natural language query into the search box, users can find the cubes most relevant to their request (linked to the "Ask Data" function).
• AI-assisted report analysis: use report's "AI" menu to run pre-configured prompts ("Discovering Insights", "Detect Anomalies") or or ask their own questions about the report's data.
• Connect AI agents to SeekTable MCP server: use cloud-based tools like Claude and ChatGPT, or locally hosted AI agents (Claude Code, Codex, Gemini CLI, GitHub Copilot, Opencode), to chat with your business data and unlock the full power of modern AI.