Frequently Asked Questions



Who are you? How safe my data on SeekTable?

SeekTable.com is owned and maintained by the same team that supports NReco Components (located in Kyiv, Ukraine).
This is a fully bootstrapped product, and its existence doesn't rely on investements. You may be sure that when you decide to use SeekTable in your company it will be maintained for many years without surprises. Contact us to ensure that SeekTable is provided by a reliable vendor.

Your data is used only to build visualizations and reports requested by you; see our privacy policy for more details. As any other internet service SeekTable cannot be 100% safe, and in case of sensitive data you can consider usage of a self-hosted (on-premise) version.


Is SeekTable really free?

Yes, SeekTable offers free fully-functional personal accounts (all data source connectors are available), and we don't plan to remove them in the future.

With paid subscriptions you can unlock advanced SeekTable features:

  • team sharing: ability to share cubes/reports with other SeekTable users in a secure way.
  • advanced publishing/embedding capabilities
  • special options for self-hosted SeekTable: users management / disable public signup, single sign-on, use your brand logo (white-label) / hide links to seektable.com


Share cubes/reports with other SeekTable users

It is possible to share your cubes and/or reports with your team members using team-sharing feature:

  • invite users into your team (in self-hosted mode confirmation by email is not needed)
  • share a cube (data source) or reports to team with access rules:
    • who can access the cube or report: all team members or you can choose users
    • for cube: what dimensions/measures should be accessible (all or you can choose items)
    • for report: what report options are enabled (Rows/Columns/Values/Chart/Filter selectors, Format/Params tabs, export formats)
  • record-level permissions: you can use special report parameter to filter report data by user's email

You can easily evaluate this feature with a free 14-day trial: just click on "Share to team" and then activate your trial. If you need more time to test team sharing functionality feel free to contact us.


Data preparation: transform/clean/merge

SeekTable is a data visualization/reporting tool, and it expects that data is already in the form that is suitable for that. Databases often store well-normalized data and you can use them as data sources directly (without any additional ETL); however, CSV files may contain incomplete/raw data that needs cleaning/enrichment or another tranformations. Typical case is when dataset represented by many CSV files: SeekTable needs a single CSV file and you have to combine these CSVs somehow on your side before upload.

For this purpose you can use Easy Data Transform: this is a desktop app (Win/Mac OS) where you can perform various data tranformations using GUI without need to write a code. The tool has a free 7-days trial period.


Subscribe to a report (schedule report generation)

In case of live data sources (database, or auto-synchronized CSV) you might want to automate report generation on schedule (daily, weekly etc) and get a report with newest values directly to your email inbox (or Slack/Drive/Dropbox/OneDrive etc), without the need to open SeekTable app. For this purpose SeekTable has connectors in the following integration platforms:

  • Zapier: you can create "zaps" that trigger on some event and execute an action in your SeekTable account: report export, share report by email, CSV file upload.
  • Microsoft Flow: you can create workflow automation to deliver reports on schedule and perform the same actions in your SeekTable account as in case of Zapier.

How to install SeekTable on my server?

We realize that in some cases you cannot use SeekTable as a cloud service for number of reasons - say, in case of sensitive data that should not leave your company's intranet or your local computer (or when your DB is not acccesible from internet at all).

You still can use reporting functionality provided by a self-hosted SeekTable version which is distributed in the form of docker images. SeekTable can be installed on any Linux server that is supported by Docker (Kubernetes is also suitable for this purpose).
If you're looking for embedded pivot tables as a component take a look to the PivotData microservice - this is reporting engine used by SeekTable. It includes web pivot builder example that can be integrated into any web application.


Translate SeekTable to non-English language

Cloud SeekTable is English-only, however in case of self-hosted version you can modify/translate UI labels to your native language (German, Spanish, French, Polish, Russian etc).
Note that this capability requires a subscription for white-label mode.

Technically UI localization is performed by editing of the JSON configuration (key-value pairs) in the admin area.


Can I use an API to access SeekTable reports?

Web API is available for the following actions:

  • Generate report to HTML, PDF, Excel, CSV or PNG image
  • Share report by email
  • Upload CSV data (create or refresh existing cube)

This API may be used directly or in Zapier/Microsoft Flow automations.


Automate CSV file import from Google Drive/OneDrive/Dropbox/URL

In some cases you might want to keep reports created by CSV data in sync with:

  • Google Drive (including spreadsheets editable with Google Sheets)
  • Microsoft OneDrive (including Excel files)
  • Dropbox (only CSV/TSV files)
  • public URL (only CSV/TSV files)

This kind of automation is possible with Zapier or Microsoft Flow. Or you can write your own shell script and use SeekTable web API directly - say, with curl or your favorite programming language.


Connect pivot tables to Google Analytics data.

For now SeekTable doesn't have built-in connector for Google Analytics data. However, we already investigated technical possibility of this and GA connector may be implemented for live reporting with the following limitations:

  • only pivot table reports (no flat tables)
  • no totals / sub-totals for GA measures
  • max number of cells with values in the report is 10,000

If you're interested in SeekTable connector for Google Analytics please contact us.


Use database %X% as a data source. Is that possible?

If this database is SQL-compatible and it has an ODBC driver for Linux (or ADO.NET provider) we can add it to the list of supported connectors upon request. Examples of databases that may be potentially used with SeekTable:

  • Vertica
  • Exasol
  • AWS Athena
  • Apache Drill
  • QuestDB

Edit table data and write back to a database

In case of non-aggregated reports (flat table type) it might be useful to have a possiblity to edit values directly from the report.

However, SeekTable is a reporting tool and its primary purpose is data exploration & visualization (it has read-only access to the data source). If you want to modify your database records with a web interface it is better to use more appropriate tools for this purpose:

  • Use no-code/low-code platform to create a CRUD web app for your DB: Appsmith (free/open-source/self-hosted), Retool (cloud service/free tier available), MS Power Apps etc.
  • Sometimes it is enough to use DB management tools like phpMyAdmin / pgAdmin etc.
  • In simple cases you may use GoogleSheets to edit rows and then sync it with SeekTable CSV cube for reports.

It is possible to integrate SeekTable reports with a web-based CRUD app in this way: you can use HTML formatting capabilities to generate links inside your reports for opening appropriate record form (where the user can make necessary data modifications).


SeekTable technology stack

SeekTable consists of two web applications:

  • Reporting engine (PivotData microservice): .NET Core app (3.1-LTS runtime).
  • Web UI: this is ASP.NET Core 3.1 app with SPA front-end for the main flows.

A self-hosted version is distributed as docker images published on DockerHub; all pre-requisites are already included into these images which makes initial deployment / upgrades really simple.


Which browsers does SeekTable support?

As a business app SeekTable is rather conservative in this question and supports even legacy versions of web browsers:

  • IE 9+, Edge (legacy/new)
  • Chrome (56+)
  • Firefox (52+)
  • Safari (11+)
  • Mobile versions and touch-screens are fully supported