Frequently Asked Questions

Who are you? How safe my data on SeekTable? is owned and maintained by the same team that supports NReco Components (located in Kyiv, Ukraine).
This is 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 very sensitive data you can consider usage of self-hosted (on-premise) installation.

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

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 usually store normalized data and you can use them as data sources directly (without any additional ETL); but CSV files very often contain incomplete/raw data that needs cleaning/enrichment or another tranformations. Typical case when dataset is saved as many CSV files: SeekTable needs single CSV file and you need to combine these CSVs somehow on your side.

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 free 7-days trial period.

Subscribe to a report (schedule report generation)

In case of live data source (database, or auto-sync 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.

You still can use reporting functionality provided by self-hosted SeekTable version which is distributed in form of docker images. SeekTable can be installed on any Linux server that is supported by Docker (Kubernetes is also suibtable 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 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 script and use SeekTable API directly - 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.

SeekTable is a reporting tool and its primary purpose is data visualization. However, in case of SQL data source potentially it is possible to have a capability to edit record values or delete rows.

If you're insterested in this feature please let us know.

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.

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