CSV Import: Assign key to overwrite existing fields

When importing a CSV if you allow us to assign a KEY to one of the fields we can use the csv import to overwrite data in current CMS items rather than Webflow creating an additional, duplicate item. 

This to me feels like one of those things that should have been in the box with the delivery of the CSV, but then again if I could build it myself I wouldn't be asking you to ;)

  • Ed Bini
  • May 15 2017
  • Shipped
CMS
  • Boris Périsset commented
    22 Apr 11:16am

    This is soooooooooo cool! Thanks for shipping this crucial Update!
    Wow. It works really well. I'm more than happy!


    I could fix little but annoying things in no time.

    Like this old bug i had, where some word spaces were too small on mobile devices (who knows why). So i could download my 235 collection items. Open the csv. Search and replace those spaces and voila! 2560 corrections done!

    Same with similar issues in my text.


    The only thing I don't have a proper workflow is with the richtext elements. The plain html in the csv, which makes it hard to work outside of the editor with it. Any suggestions?



    One thing you could improve.

    While changing the slug, the collection items are going from published to draft state. I realized it only after some time on the published site.

    I needed to check all items and stage them for publish and publish the site again. no big deal. But I think, this could be done better, by just inform/warn us with a note, when changing the slug or after changing the slug in the summary of the import.

  • Dave Cruickshank commented
    20 Apr 06:41pm

    This works beautifully now. Thank you.

  • Admin
    Webflow Admin commented
    20 Apr 05:31pm

    Good news. It's now possible to update CMS items via a CSV upload. https://webflow.com/feature/easily-manage-and-update-large-cms-collections

  • Alex Dixon commented
    31 Mar 01:45pm

    +1

    I assumed that this would be default behaviour until I recently tried to reimport items from an previous Webflow export :(

    Ideally it would be a checkbox: Override existing items with matching ID

  • Nicholas Hirons commented
    24 Mar 11:48am

    This is a massive gap for anyone trying to sync content/collections or bulk import with bi-directional referencing - would love to see this prioritized!

  • Alexander Engl commented
    8 Feb 03:02pm

    Such a basic feature... how can this STILL be missing???

  • Wombat Invest commented
    31 Oct, 2021 03:59pm

    WTAF as if you don't have this feature. It's actually very annoying YET AGAIN WF is lacking basic features

  • Geffrey Barendregt commented
    28 Jun, 2021 12:04pm

    Upvoting. As some have said, this probably should have been 'in the box' with the CSV feature. Not being able to externally update a collection list makes Webflow unusable for certain projects.


    Would very much appreciate an update on this.

  • Dave Cruickshank commented
    27 May, 2021 07:30pm

    Has this been addressed? If you're importing and updating, say, a product inventory... not having the ability to overwrite items based on some common element (url, or title), makes syncronizing an inventory with an external system (via CSV) impossible, without completely deleting the existing webflow inventory and re-uploading it every time. Yikes.

  • Peter Van Laer commented
    19 Apr, 2021 03:42pm

    Any updates on this?

  • Joshua Jia commented
    1 Apr, 2021 10:15pm

    If not having this function, large scale migration would be a nightmare.

  • A BONNE ECOLE A BONNE ECOLE commented
    23 Jan, 2021 11:08am

    Much needed especially when you need to updated hundreds of records.

  • Maxim Traxel commented
    7 Jan, 2021 02:13pm

    We need this feature.

  • Tom Schweers commented
    28 Jun, 2020 05:15pm

    Was very disapointed when I found out this was not possible. Much needed!

  • Matthew Spiegelhalter commented
    8 Jun, 2020 11:03pm

    1000% needed, this would make product management much easier, say I need to change the tax code for many products, I have to go into every individual product and change the field.

    Whereas with overwrite I could assign this tax code to all the products at the same time in excel or google docs, then upload it and boom, it's done.

  • John Atkinson commented
    28 Mar, 2018 12:45pm

    Absolute necessity this features. We also need to be able to export a .csv of any given collection. As the data may have been updated by the client.

  • Jérôme Lanon commented
    20 Nov, 2017 09:54am

    Same feelings! It's very frustrating to not be able to update via CSV some fields!

  • +59