Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

How to consolidate and update with cleaned csv data

Topic Labels: ImportingExporting
1640 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!