Collection export/import duplicated existing data

[grantsenior]

Hello, hope somebody can help me with this. I may have done something wrong here but haven’t read, or found a way of getting around this.

I imported a CSV file of data into a collection, made some adjustments in Webflow collection set, then exported the same collection as a CSV file and added a few rows and made a few adjustments to some, then re-imported it. I ended up with a double up of data, every item that was in the export was created again on the re-import = duplicates. Is this what I should expect or is there a way of stopping this from happening?

Looking at the CSV that got exported, there is no ID column, so I guess that’s why it happened.

Grant

---

Here is my site Read-Only: LINK
(how to share your site Read-Only link)

[webdev (Jeff Selser)]

Yep. If you wanted to work offline with data you already uploaded, change it, and upload your changes, you would need to use the API.

[grantsenior]

Thanks for that. I’m guessing you’re referring to here CMS API | Webflow Features

Happy to do my own research into this, but any chance you can you elaborate, or suggest a method that you use with Webflow to speed things up for me?

Cheers

[webdev (Jeff Selser)]

I have my own databases, servers, and apps. I normally manage data via API’s. So it depends where and what you store your data in, or apps you use, etc.

You could look at using Google Sheets, or Airtable for example, and then something like Zapier to bridge those products to the webflow api. Zaps (a predefined integration) exist in Zapier.

[grantsenior]

Great! Thanks, I’ll look into those.

Cheers