Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

How to consolidate and update with cleaned csv data

Topic Labels: ImportingExporting
1410 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Matthew_Baggett
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi there. I’m losing my mind and can’t figure out what seems like a simple task…

I have a tab in a base that had a few columns missing data, so I downloaded it as a CSV, did a bit of cleaning, added the data to the empty columns in Excel, and now I want to consolidate the CSV back into the tab in the base, so that all the data is linked.

I installed the CSV import block, and tried to use it, but all it did was import the csv to a new tab, instead of updating the exiting tab with the new data to the proper columns.

any help is appreciated!

2 Replies 2

I don’t even see the option for making a new table when importing a CSV file. The top of the import block is where you choose the table where the data will be imported, so that’s the table it should use.

Could you post a screenshot or two showing the block setup, as well as your tables (blotting out sensitive data as needed)?

Hi there!

I figured it out! I had to chose the proper match field, once I did that it all worked.

thansk!