WeWeb's workspace

WeWeb IncApr 14, 2026

Parse CSV & update table

2views

Parse CSV & update table

WeWeb Inc

Learn how to import CSV data into your WeWeb table by using a loop and conditional logic to either update existing records or insert new ones. This workaround helps you manage data updates until a native upsert action is available.

Parse CSV & update table

WeWeb Inc

Learn how to import CSV data into your WeWeb table by using a loop and conditional logic to either update existing records or insert new ones. This workaround helps you manage data updates until a native upsert action is available.

Chapters

00:00

Introduction

Overview of the CSV update workflow and the challenge of data replacement.

00:19

CSV Parsing Setup

01:01

API Endpoint Configuration

01:57

Implementing the Loop

02:28

Conditional Update Logic

03:47

Future Improvements

04:07

Alternative Matching Methods

Transcript

00:00

Hey, win.

00:01

I hope you're doing well.

00:02

So we don't have like, an action to like just delete your entire table and update it with completely new records.

00:11

But you can achieve what you're trying to do with with a loop.

00:16

so let me just show you how this works.

00:19

first, so I have a file upload element here and you can upload a CSV.

00:27

And so that's in the interface and then in Data API I have a couple of things.

00:33

First I have a function.

00:35

So this is actually a template.

00:37

you can add it like this.

00:38

Maybe you already have this.

00:40

but so yeah, you would in functions you would add one and then go to data and use this, the parsecsv to rows.

00:51

And you see here it has an input.

00:53

So you can add a test file if you want and you don't need to change anything here.

01:01

Then in your API endpoints, I created a new one, a completely new one.

01:06

you could edit the add row one, the default one.

01:11

I prefer to start from scratch just because I didn't want to break anything.

01:15

so the way it works is I created a parameter with that I call CSV and it's type file, it expects a file.

01:25

And I have a test file here.

01:27

and then I'm calling this function.

01:33

So I create an action that is yeah, here functions.

01:39

And I look, I called the parsecsv to rows function that I had created here.

01:45

And then what I did is so you can see like if I test data, you see that, Sorry, this is the result.

01:53

So we get headers, so the column names and rows.

01:57

and then I created a loop, a for loop.

02:00

So the for loop I bound to the action results, the rows so of when the CSV was parsed.

02:11

So that's the data.

02:12

You know, one row is for example here I have a name and description, but I don't have an id.

02:17

it's the spreadsheet, by the way.

02:20

And you see, for some I have IDs because they already exist in my table, in my web table.

02:25

And for some I don't have IDs, they're brand new.

02:28

so I'm iterating through this and then I have a branch, that's saying okay, if I.

02:36

And by the way, to get this preview of the loop, you need to test the entire workflow.

02:40

That's kind of a, it can be tricky in terms of ux, but you need to do that so that way you can access here you can access a loop item.

02:54

And so here what I'm doing, the condition is, does my loop item have an ID or is it empty?

03:01

You know, so if it's not empty, if it already exists in the table, if it's not empty, I will update the row and I will say, I will take the ID of my looped item and then update, you know, bind to the name in description.

03:22

But if the, if the ID is empty, it's just an empty string.

03:31

Sorry.

03:31

I will then insert a new row.

03:33

I want.

03:34

I will let WeWeb tables generate an ID, but I will bind to the name in description and.

03:43

Yeah, that's it really.

03:47

So we should probably create a new action called upsert so that you don't have to do this condition and it does it automatically.

03:55

we'll create a product ticket for this, but in the meantime you need to create the branch yourself.

04:00

So to check if the record already exists or not.

04:03

And then it will update accordingly.

04:07

So let me see, here, my table.

04:16

So let's say instead of here instead of yellow fruit.

04:28

First of all I need to kind of.

04:30

Yeah, that's a maybe that's not great.

04:37

So yeah, you don't need to do it on the id, you can do it on the loop, you can do on the name, to check if the name already exists.

04:45

It might be Better than with IDs in your use case.

04:49

the only thing is you might have a typo here.

04:53

I think you get the logic.

04:57

Let me know if not, let me know if anything is unclear or if you struggle.

05:01

Just add a couple screenshots, to help me unblock you.

Parse CSV & update table