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.
- 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. - Edit the connection (Settings → Database Connections → pencil icon) → Advanced → Security.
- Tick Allow file uploads to database.
- Optionally list the schemas uploads may go into under Schemas allowed for File upload, such as
["uploads"]. - 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
- Click + (top right) → Data → Upload CSV to database, Upload Excel to database or Upload Columnar file to database (Parquet).
- Choose the file.
- Choose the Database and Schema, and type a Table name, such as
targets_2026. - 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.
- 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.