Update your table

Update or upload data to any table using spreadsheets

Jestor will update an existing Jestor table with data from your Google Sheets, Excel or CSV. You'll be able to keep track of past imports.

You can select a key for matching, edit fields and select 3 different methods:

  1. Only upload new records
  2. Create new records
  3. Update records
2326

Setting up the data import

Start by clicking on the Import data icon on the left menu.

868

After that, select your Connector, which contains the data you'd like to import. Let's begin with Google Spreadsheet by clicking on it

2822

Types of Connection

Now there'll be three types of connections for you to choose:

  • The second one is Update your table - to update or upload data to any table using spreadsheets

Jestor will update an existing Jestor table with data from your Google Sheets. You'll be able to keep track of past importations.

You can start to update by clicking on the blue button on the right side

1106

Update your table

To update your table, first select the table which will be updated

566

Then choose a Google Account to connect to and select a spreadsheet along with the tab

1076

Lastly, choose the method to import your data to Jestor:

  • Only upload new records
  • Create new records
  • Update records

And click on Next to continue

1077

Field matching

We're almost there! Check out if the matching is correct to upload the data.

1125

For this, select a Key! A Key is an ID to match the spreadsheet with Jestor. The key variable should be a unique identifier to avoid duplicity.

795

Confirm that the columns are correct and choose if you want to delete any.

When everything's just the way you like it, click on "Finish Migration". This will start the process of updating your table.

1106

Don't worry if it's a lot of information to upload: you can keep using jestor normally while it's updating your data and you'll receive a notification in your browser, mobile or desktop App as soon as your table is up to date.

1149

📘

Did we mention that all of this counts as one single action? This is a great way to build the initial structures for your jestor in a quick, efficient manner.