Skip to main content

How do I upload an Excel or CSV file as a source?

Overview

A data source is the foundation of every dashboard in Vantage. BeforeLets you can add widgets, apply filters, or share insights, Vantage needs data to work with. The fastest way to bring data into Vantage is by uploadingupload an Excel (.xlsx) or CSV (.csv) file directly from your computer.

When you uploadas a file,data source for dashboards. Vantage reads itsthe file's columns and rows, stores them in its analytics engine,rows and makes the data available for dashboards andto widgets. You can upload multiple files to create separate data sources, and later define relationships betweenjoin them tousing combine data across sources.relationships.

When to Use

UploadUse anthis Excelfeature or CSV file when you need to:when:

  • Analyse spreadsheet data — You have sales figures, audit scores, inventory counts, or survey results in a spreadsheet and want to turn themspreadsheet data into charts and KPIs.KPIs
  • BringYou inhave data from an external system — You exported data from another toolsystem (ERP, HRMS, POS) as a file and want to visualise it in Vantage.
  • CreateYou need a one-time or periodic datasnapshot snapshotinstead —of Thea datalive doesconnection
    • not
  • You change frequently enoughwant to need an automated API connection; a manual upload is simpler.
  • Prototypeprototype a dashboard quickly — You want to test a dashboard layout and widget configuration with real data before setting up a live API connector.

Concepts

  • Data Source – A named data set inside Vantage that widgets query.query
    • Each uploaded file becomes its own data source with a unique table of columns and rows.

  • Connector – The method used to bring data intoin Vantage.(Excel/CSV, Uploading an ExcelAPI, or CSV file is one connector type; REST API and internal Converseforms)
    • forms are others.

  • Ingest – TheAutomatic process that readsloads your uploaded file, maps its columns, and writes the datafile into Vantage’Vantage's analytics engine
    • (ClickHouse). Ingest runs automatically after you upload.

  • Column Mapping – VantageVantage's detects each column’sdetected name and data type (text,for number,each date)column; from the file. You can review and adjust theseeditable before thesaving
    • data is saved.

  • Replace vs Append – WhenReplace you re-upload a file to anoverwrites existing datarows; source,Append you can choose to replace all existing rows with the new file’s data, or append theadds new rows to whatthem
    • is already there.

  • Typed Columns – VantageEach stores each column with a specificcolumn's data type (String, DateTime, Int64, Float64, etc.). Correctfor typescorrect ensure filters, sorting,filtering and aggregationsaggregation
    • work
as expected.

Set Up Guide

Before You Start

From the Home Page, click the Vantage Dashboard widget to open Vantage. If you have not added this widget yet, follow the Custom Widget help doc to set it up.

  1. OpenGo the Data Sources screen — In the Vantage sidebar, clickto Data Sources. You will see a list of all existing data sources for your organisation.
  2. Start a new upload — Click the + Add Source (or Upload) button and→ select Excel / CSV as the connector type.
  3. Choose your file — Browse your computer and select the .xlsx or .csv file you want to upload. The file is sent to Vantage and the ingest process begins automatically.
  4. Review the column mapping — Vantage displays the detected columns with their names and data types. Check that dates are recognised as dates, numbers as numbers, and text as text. Adjust any column type if needed.
  5. Name the data source — Give the data source a clear, descriptive name (e.g., "Store Sales — Q3 2026" or "Employee Training Scores"). This name appears in the dashboard builder when you add widgets.
  6. Save — Click Save. The data is now stored in Vantage and ready for use in dashboards.

From

Best here you can:

Practices

  • Create a dashboard and add widgets that query this data source — see How do I create a dashboard?
  • View and edit the uploaded data — see How do I view and edit data in a source?
  • Define a relationship to join this data with another source — see How do I create a relationship between data sources?

Best Practices

Use a header row in the first row of your file — Vantage readsnames columns from it to name each column automatically.

  • Remove blank rows and columns before uploading
    • — extra blanks create empty columns in your data source.
  • Keep dates in a consistent format
    • (e.g., YYYY-MM-DD or DD/MM/YYYY) so Vantage detects them as date columns.
  • Avoid merged cells in Excel files
    • — merged cells do not translate into clean rows and columns. If your data changes regularly, re-
  • Re-upload the updated file and choose Replace to keep the data sourcecurrent
    • current.
  • Use one sheet per file — Vantage reads the first sheet
    • by default.
  • Keep file sizes manageable
    • — very large files take longer to ingest.

    • How do I connect a REST API as a data source?
    • How do I connect internal Converse forms as a data source?
    • How do I view and edit data in a source?
    • How do I create a relationship between data sources?
    FAQs

    FAQs

    Can I upload more than one file? Yes.
    Yes, Eacheach file becomes its own data source. You can then create relationships between them if they share a common column.

    What file formats are supported?
    Excel (.xlsx) and CSV (.csv) files are supported..

    Can I update the data after uploading? Yes.
    Yes Re-— re-upload an updated file to the same data source and choose Replace to overwrite the old data, or Append to add new rows.Append.

    What happens if my column names change between uploads? If column names differ from the original upload,
    Vantage may create new columns.columns; Keep columnkeep names consistent across uploads.consistent.

    Version Notes

    Last Updated: Oct 2026

    Back to top