# Format for batch importing accounts

**URL:** <https://forum.sambapos.com/t/format-for-batch-importing-accounts/14245>\
**Category:** V5 Question\
**Created:** [March 2, 2017, 1:08pm UTC](https://forum.sambapos.com/t/format-for-batch-importing-accounts/14245 "2017-03-02T13:08:25Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![KuriGohan\_And\_Kameha](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/k/da6949/32.png) [@KuriGohan\_And\_Kameha](https://forum.sambapos.com/u/KuriGohan_And_Kameha)\
**Post date:** [March 2, 2017, 1:08pm UTC](https://forum.sambapos.com/t/format-for-batch-importing-accounts/14245/1 "2017-03-02T13:08:25Z")

</div>

I need to import some accounts from an excel spreadsheets with the batch import accounts option, but I can’t find the correct format. Can anyone help.

---

<div class="post-metadata">

**Author:** ![markjw](https://forum.sambapos.com/user_avatar/forum.sambapos.com/markjw/32/9942_2.png) [@markjw](https://forum.sambapos.com/u/markjw)\
**Post date:** [March 2, 2017, 1:20pm UTC](https://forum.sambapos.com/t/format-for-batch-importing-accounts/14245/2 "2017-03-02T13:20:09Z")

</div>

The format is

```auto
#<Account Type>
<Account Name>
...

```

So for example:

```auto
#Customer Account
John
Mary

```

will create 2 customer accounts (John and Mary)

---

<div class="post-metadata">

**Author:** ![KuriGohan\_And\_Kameha](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/k/da6949/32.png) [@KuriGohan\_And\_Kameha](https://forum.sambapos.com/u/KuriGohan_And_Kameha)\
**Post date:** [March 2, 2017, 1:28pm UTC](https://forum.sambapos.com/t/format-for-batch-importing-accounts/14245/3 "2017-03-02T13:28:42Z")

</div>

Thank you very much. That helped plenty.

---

<div class="post-metadata">

**Author:** ![emre](https://forum.sambapos.com/user_avatar/forum.sambapos.com/emre/32/39073_2.png) [@emre](https://forum.sambapos.com/u/emre)\
**Post date:** [March 2, 2017, 1:33pm UTC](https://forum.sambapos.com/t/format-for-batch-importing-accounts/14245/4 "2017-03-02T13:33:12Z")

</div>

To import with custom fields you can use this format. It supports CSV format but you need to define on first line which field maps to the custom field.

 ![](https://forum.sambapos.com/uploads/default/original/3X/e/6/e63581e454fb9736c71d8a25715342c74acbd6e5.png)

 ![](https://forum.sambapos.com/uploads/default/original/3X/6/8/6884c35a3aa7afc99a0a05b2a876800eae24f272.png)

---

<div class="post-metadata">

**Author:** ![markjw](https://forum.sambapos.com/user_avatar/forum.sambapos.com/markjw/32/9942_2.png) [@markjw](https://forum.sambapos.com/u/markjw)\
**Post date:** [March 2, 2017, 1:39pm UTC](https://forum.sambapos.com/t/format-for-batch-importing-accounts/14245/5 "2017-03-02T13:39:36Z")

</div>

That’s for batch entity import, but his question was about batch account import.

I take it we can only support account name in batch account import? But I think that’s all that matters anyway, the only other field is currency.

---

<div class="post-metadata">

**Author:** ![emre](https://forum.sambapos.com/user_avatar/forum.sambapos.com/emre/32/39073_2.png) [@emre](https://forum.sambapos.com/u/emre)\
**Post date:** [March 2, 2017, 1:43pm UTC](https://forum.sambapos.com/t/format-for-batch-importing-accounts/14245/6 "2017-03-02T13:43:10Z")

</div>

Yes sorry you’re right. I misunderstood that.
