# Importing CSV Issue **URL:** \ **Category:** Suporte\ **Tags:** csv\ **Created:** [Fevereiro 21, 2024, 8:09pm UTC](https://tainacan.discourse.group/t/importing-csv-issue/1769 "2024-02-21T20:09:11Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![RationalRevolt](https://avatars.discourse-cdn.com/v4/letter/r/c57346/32.png) [@RationalRevolt](https://tainacan.discourse.group/u/RationalRevolt)\ **Post date:** [Fevereiro 21, 2024, 8:09pm UTC](https://tainacan.discourse.group/t/importing-csv-issue/1769/1 "2024-02-21T20:09:11Z")
Hello, While trying to update my collections via CSV and google sheets, when I import said edited CSV file into Tainacan, it creates new items instead of updating previous ones. Any help? thank you. ---
**Author:** ![mateus.m.luna](https://yyz2.discourse-cdn.com/free1/user_avatar/tainacan.discourse.group/mateus.m.luna/32/3_2.png) [@mateus.m.luna](https://tainacan.discourse.group/u/mateus.m.luna)\ **Post date:** [Fevereiro 22, 2024, 11:24am UTC](https://tainacan.discourse.group/t/importing-csv-issue/1769/2 "2024-02-22T11:24:04Z")
Hello @RationalRevolt! Welcome to our forum! Starting by the basics, does your CSV file contains the `special_item_id` field properly? ---
**Author:** ![RationalRevolt](https://avatars.discourse-cdn.com/v4/letter/r/c57346/32.png) [@RationalRevolt](https://tainacan.discourse.group/u/RationalRevolt)\ **Post date:** [Fevereiro 22, 2024, 4:02pm UTC](https://tainacan.discourse.group/t/importing-csv-issue/1769/3 "2024-02-22T16:02:03Z")
There is no special\_item\_ID field. How should I insert this? It wasn’t there when I exported to csv from my collection. ---
**Author:** ![mateus.m.luna](https://yyz2.discourse-cdn.com/free1/user_avatar/tainacan.discourse.group/mateus.m.luna/32/3_2.png) [@mateus.m.luna](https://tainacan.discourse.group/u/mateus.m.luna)\ **Post date:** [Fevereiro 22, 2024, 5:34pm UTC](https://tainacan.discourse.group/t/importing-csv-issue/1769/4 "2024-02-22T17:34:35Z")
Uhmm, ok. It must exist because that is how the importer knows which item to update. However, it should be generated from the Exporter. Can you detail to me the steps that you took to obtain the current CSV file? ---
**Author:** ![RationalRevolt](https://avatars.discourse-cdn.com/v4/letter/r/c57346/32.png) [@RationalRevolt](https://tainacan.discourse.group/u/RationalRevolt)\ **Post date:** [Fevereiro 22, 2024, 5:40pm UTC](https://tainacan.discourse.group/t/importing-csv-issue/1769/5 "2024-02-22T17:40:00Z")
While in the collection I used the “View as” CSV to download it. Is there a different way to obtain this file? ---
**Author:** ![mateus.m.luna](https://yyz2.discourse-cdn.com/free1/user_avatar/tainacan.discourse.group/mateus.m.luna/32/3_2.png) [@mateus.m.luna](https://tainacan.discourse.group/u/mateus.m.luna)\ **Post date:** [Fevereiro 22, 2024, 5:47pm UTC](https://tainacan.discourse.group/t/importing-csv-issue/1769/6 "2024-02-22T17:47:45Z")
Yes! That “View as…” is what we call an “exposer”. It is a bit less complete than an actual Exporting. For that you should go to your Tainacan Admin → Exporters → CSV Exporter and select your collection. ---
**Author:** ![RationalRevolt](https://avatars.discourse-cdn.com/v4/letter/r/c57346/32.png) [@RationalRevolt](https://tainacan.discourse.group/u/RationalRevolt)\ **Post date:** [Fevereiro 22, 2024, 5:54pm UTC](https://tainacan.discourse.group/t/importing-csv-issue/1769/7 "2024-02-22T17:54:01Z")
Ohhh! Now I’ve got it! Thanks so much, that makes much more sense. ---
**Author:** ![RationalRevolt](https://avatars.discourse-cdn.com/v4/letter/r/c57346/32.png) [@RationalRevolt](https://tainacan.discourse.group/u/RationalRevolt)\ **Post date:** [Fevereiro 22, 2024, 5:56pm UTC](https://tainacan.discourse.group/t/importing-csv-issue/1769/8 "2024-02-22T17:56:00Z")
So now what would be the best way to add new meta data via CSV? Or is it better to do it via tainacan ui? ---
**Author:** ![mateus.m.luna](https://yyz2.discourse-cdn.com/free1/user_avatar/tainacan.discourse.group/mateus.m.luna/32/3_2.png) [@mateus.m.luna](https://tainacan.discourse.group/u/mateus.m.luna)\ **Post date:** [Fevereiro 22, 2024, 6:00pm UTC](https://tainacan.discourse.group/t/importing-csv-issue/1769/9 "2024-02-22T18:00:13Z")
Depending on what you want, it can be done both ways. If you first add by creating a column to your exported CSV just remember to select “Create metadata” in the mapping step during the Importer workflow. Relationship and Compound metadata are the ones that I believe it is best to do via interface, since they store data in some particular ways. But also for updating data, remember that some things can be done via Bulk Editition, selecting multiple items in the admin, without having to export and import again 😉. ---
**Author:** ![system](https://global.discourse-cdn.com/free1/uploads/tainacan/original/1X/7a4cda66d79553ef5eebf93769c00bdba65e7ab2.png) [@system](https://tainacan.discourse.group/u/system)\ **Post date:** [Fevereiro 27, 2024, 6:00pm UTC](https://tainacan.discourse.group/t/importing-csv-issue/1769/10 "2024-02-27T18:00:38Z")
Este tópico foi fechado automaticamente 5 dias depois da última resposta. Novas respostas não são mais permitidas.