Importing data

Learn how to connect your data sources and input them into your data apps.

In this tutorial:

Understanding input and output

The first step to building your data app is adding data. Data apps function according to input and output datasets. Each time a block is added, input data is fed into the block and manipulated or transformed data is output.

Therefore when you first create your new app, some starting data is required. This dataset serves as your initial input data and is transformed as more and more steps are added.

In a train track analogy where function blocks are the tracks, the data can be represented as the train car traveling through or across the tracks. As the train car passes through a track it is manipulated and a different dataset is output (columns may be added or taken away). This output dataset can then serve as the input for the next block or "track".

Importing data

To upload starting data into your app, use an "Import Data" block. You will be prompted to do this as soon as you create a new, blank app.

We provide many integrations with most popular databases, spreadsheets, CRMs, warehouses or business apps. Below are some of them, but you can find the whole list here.

For information on any of these specific integrations check out the Integrations video or the official documentation.

Import CSV or Excel file

With this simple example you'll learn how to import data by uploading a CSV or Excel file.

This "Read/Upload file" block allows you to choose a CSV or Excel file from your computer. Since these file types aren't automatically updated, you can check this box to allow users to upload personal or updated files when the app is published and run.

Once the data is loaded into the app a collapsible preview table shows up. You can then call that dataset as an input for any blocks you add below this point and each time the dataset is transformed a new output dataset is created and renamed.

Note that you can call any *preceding* dataset as an input, it doesn't have to be the output dataset from the step directly before it.

NEXT TUTORIAL

Adding steps