Page 1 of 1
Bulk upload companies & contacts-Solved
Posted: 19 Jan 2017, 14:58
by vvon66
Hello - Is there any way to bulk upload companies and contacts from an excel sheet or CSV file? I read through all of the documentation I could find and didn't see it mentioned. Any help is appreciated. Thank you!
Re: Bulk upload companies & contacts
Posted: 19 Jan 2017, 15:14
by RussH
Yep absolutely - just go to Settings, Administration, Import.
Re: Bulk upload companies & contacts
Posted: 19 Jan 2017, 15:34
by vvon66
Great! I just found it. Another question...
I have a huge file of companies and contact names. Should I import the list as companies or contacts? If I import as companies, will it also import the contacts to that company? I only have one contact per company name on this list.
Thank you!
Re: Bulk upload companies & contacts
Posted: 19 Jan 2017, 16:03
by vvon66
I played around and realized it was best to add as contacts.
Opencats will automatically add the company name if there is no company already in the system. If you have a company in your import list without a contact name, it will add them as "nobody" but still add the company. Then when you get a contact name, you can update that profile.
I hope this helps someone in the future

Re: Bulk upload companies & contacts
Posted: 19 Jan 2017, 16:04
by cptr13
It'll help the documentation.

thank you!
Re: Bulk upload companies & contacts
Posted: 19 Jan 2017, 17:23
by vvon66
cptr13 wrote:It'll help the documentation.
thank you!
Anything else I find, I will be sure to add it!