Embiro BI

Documentation › Connecting data

Uploading CSV and Excel files

Upload CSV, Excel and Parquet files into one of your databases and chart them in Embiro BI.

You can upload a CSV, Excel (.xlsx, .xls) or Parquet file and chart it like any other table. The file is loaded into a table in one of your organization's databases, so it needs a database connection that allows uploads.

Who can do this: Super Admin, Admin and Analysts.

Is your spreadsheet already in Google Sheets?

Connect it with Google Sheets instead. Charts then follow the sheet as people edit it, with no re-uploading.

Before you start: allow uploads on a database

Uploads go into a database you connected, and Embiro BI needs permission to create tables in it.

  1. Connect a database whose login can create tables in at least one schema, for example a PostgreSQL schema named uploads. A read-only login is not enough here.
  2. Edit the connection (Settings → Database Connections → pencil icon) → Advanced → Security.
  3. Tick Allow file uploads to database.
  4. Optionally list the schemas uploads may go into under Schemas allowed for File upload, such as ["uploads"].
  5. Click Finish.
-- PostgreSQL: a schema just for uploads, writable by Embiro BI's login
CREATE SCHEMA uploads;
GRANT USAGE, CREATE ON SCHEMA uploads TO embiro_uploader;

Upload a file

  1. Click + (top right) → Data → Upload CSV to database, Upload Excel to database or Upload Columnar file to database (Parquet).
  2. Choose the file.
  3. Choose the Database and Schema, and type a Table name, such as targets_2026.
  4. Check the options:
    • If table already exists: Fail (the default), Replace (delete the old rows and load the file), or Append (add the file's rows).
    • File settings: the delimiter for CSV files (, or ;), and which sheet to read for Excel files.
    • Columns: Columns to be parsed as dates, such as order_date, so time charts work. Set the Header row if the column names aren't in the first row.
  5. Click Upload.

The table appears in the database, and a dataset is created for it. Open Datasets to start charting.

Refreshing uploaded data

An upload is a copy taken when you uploaded it. To update it, upload the new file with the same table name and If table already exists: Replace. Charts and dashboards built on the dataset keep working, as long as the column names don't change.

Limits

  • Files up to 100 MB.
  • Keep column names in the first row, one row per record, with no merged cells or totals rows.

Something unclear or missing? Tell us and we'll improve this page.