# Import case data from excel **URL:** \ **Category:** Users\ **Created:** [September 2, 2019, 10:41am UTC](https://forum.dimagi.com/t/import-case-data-from-excel/6806 "2019-09-02T10:41:35Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![nbirden](https://dimagi.b-cdn.net/user_avatar/forum.dimagi.com/nbirden/32/1083_2.png) [@nbirden](https://forum.dimagi.com/u/nbirden)\ **Post date:** [September 2, 2019, 10:41am UTC](https://forum.dimagi.com/t/import-case-data-from-excel/6806/1 "2019-09-02T10:41:35Z")
Hey All, I am trying to import data from excel to my application but I get an error. I am gonna attach the error message. I think it caused by mismatching case property? Could you please help me as soon as possible. Thanks, ![error%20commcare](https://dimagi.b-cdn.net/uploads/default/original/2X/f/f62d29be64d26744cb405414f4735554ff5f487e.png) M ---
**Author:** ![Ethan\_Soergel](https://dimagi.b-cdn.net/user_avatar/forum.dimagi.com/ethan_soergel/32/543_2.png) [@Ethan\_Soergel](https://forum.dimagi.com/u/Ethan_Soergel)\ **Post date:** [September 2, 2019, 11:08am UTC](https://forum.dimagi.com/t/import-case-data-from-excel/6806/2 "2019-09-02T11:08:29Z")
It looks like your excel file has values in the "owner\_id" column, but these values aren't actually IDs of any valid case owners. What are you using in that column? ---
**Author:** ![nbirden](https://dimagi.b-cdn.net/user_avatar/forum.dimagi.com/nbirden/32/1083_2.png) [@nbirden](https://forum.dimagi.com/u/nbirden)\ **Post date:** [September 2, 2019, 1:53pm UTC](https://forum.dimagi.com/t/import-case-data-from-excel/6806/3 "2019-09-02T13:53:24Z")
I want to generate a unique ID. That's why I put an empty column called owner id. I don't want to update cases. I want to create new cases from excel file. Even if I remove owner id column I get errror. ---
**Author:** ![Ethan\_Soergel](https://dimagi.b-cdn.net/user_avatar/forum.dimagi.com/ethan_soergel/32/543_2.png) [@Ethan\_Soergel](https://forum.dimagi.com/u/Ethan_Soergel)\ **Post date:** [September 2, 2019, 4:11pm UTC](https://forum.dimagi.com/t/import-case-data-from-excel/6806/4 "2019-09-02T16:11:25Z")
When you remove the owner\_id column, is the error message the same? ---
**Author:** ![nbirden](https://dimagi.b-cdn.net/user_avatar/forum.dimagi.com/nbirden/32/1083_2.png) [@nbirden](https://forum.dimagi.com/u/nbirden)\ **Post date:** [September 3, 2019, 7:21am UTC](https://forum.dimagi.com/t/import-case-data-from-excel/6806/5 "2019-09-03T07:21:55Z")
I've removed it before import data. Yea error message is the same. ---
**Author:** ![Ethan\_Soergel](https://dimagi.b-cdn.net/user_avatar/forum.dimagi.com/ethan_soergel/32/543_2.png) [@Ethan\_Soergel](https://forum.dimagi.com/u/Ethan_Soergel)\ **Post date:** [September 3, 2019, 8:57am UTC](https://forum.dimagi.com/t/import-case-data-from-excel/6806/6 "2019-09-03T08:57:12Z")
It looks like that error can also occur if owner name is specified, which is a bit misleading. Are you providing owner names? If so, do those names for sure correspond to users, locations, or groups with "case sharing" enabled? ---
**Author:** ![nbirden](https://dimagi.b-cdn.net/user_avatar/forum.dimagi.com/nbirden/32/1083_2.png) [@nbirden](https://forum.dimagi.com/u/nbirden)\ **Post date:** [September 3, 2019, 10:43am UTC](https://forum.dimagi.com/t/import-case-data-from-excel/6806/7 "2019-09-03T10:43:38Z")
There are owner names. I've created a group and "case sharing" is enabled. The name of this group is typed in owner name column ---
**Author:** ![Ethan\_Soergel](https://dimagi.b-cdn.net/user_avatar/forum.dimagi.com/ethan_soergel/32/543_2.png) [@Ethan\_Soergel](https://forum.dimagi.com/u/Ethan_Soergel)\ **Post date:** [September 3, 2019, 12:39pm UTC](https://forum.dimagi.com/t/import-case-data-from-excel/6806/8 "2019-09-03T12:39:06Z")
That does sound like it should work. My guess is for some reason or another it can't find the group. Could you report an issue from that upload page so the support team can investigate the specifics? As a temporary workaround, you may also try using owner id rather than owner name. To do that, go to the page of the group you want to use, and pull the group ID out of the URL - it should be 32 alphanumeric digits, for example, if the URL is `https://www.commcarehq.org/a/mydomain/settings/users/groups/ea04791d07824be894b04fae34f8cc3b/` the group ID will be `ea04791d07824be894b04fae34f8cc3b`