No-code Databases 101

Importing, exporting and syncing data

January 9, 2023
This post is part of a series:
No-code Databases 101
If you haven't read the previous post
Querying and filtering data
you should read that first.

In a no-code context, you can use tools like Airtable and Noloco to import and export data from your database. This can be useful if you want to transfer data from other external sources, such as spreadsheets or CSV files, or if you want to share your data with others.

To import data into Noloco or Airtable, follow these steps:

  1. Navigate to the table that you want to import the data into.
  2. Click on the "Import" button.
  3. Choose the file that you want to import and select the appropriate options (such as the data format and field mapping).
  4. Click on the "Import" button to start the import process.

To export data from Noloco or Airtable, follow these steps:

  1. Navigate to the table that you want to export the data from.
  2. Click on the "Export" button.
  3. Choose the file format that you want to export to (such as CSV or Excel).
  4. Select the appropriate options (such as the data range and field mapping).
  5. Click on the "Export" button to start the export process.

In addition to importing and exporting data manually, you can also use Airtable and Noloco to sync your data with other external sources. This can be useful if you want to automatically update your database with the latest data from another source, such as a website or a cloud storage service.

To sync data with an external source using Noloco or Airtable, you will typically need to use an integration or API. An integration is a pre-built connection between two applications that allows you to exchange data between them. An API (Application Programming Interface) is a set of rules and protocols that allows you to interact with a software application or service.

To use an integration or API to sync your data with an external source, follow these steps:

  1. Check the documentation or help section of your no-code tool to see if it has a built-in integration or API for the external source that you want to sync with.
  2. Follow the instructions provided to set up the integration or API connection

Up next in this series:
Advanced no-code database concepts