Can i import contacts from a spreadsheet?

Max Classic
1

Can I import contacts from an excel spreadsheet?

2

To import, you’d need to convert it to a csv file, @Tim_Guthrie_CFP.

1 Like
3

Here is a collection of articles that cover all you should need to know about importing contacts.

http://help.infusionsoft.com/userguides/contact-management/import-contacts

1 Like
4

Thanks. I did watch the video, afterwards snd imported about 500 contacts.

One new issue is most have the first and last names doubled:

Jim jim smith Smith

I think that is sn import issue. I plan on deleting and trying again, making sure nothing is double mapped.

Tim Guthrie, CFP
513-774-3325
937-377-1234

SmartVestor Pro

www.bullseyeinv.com<http://
www.bullseyeinv.com>

“Portfolios Targeted to Your Investment Goals”

5

I’ve not seen that happen before except when the field was mapped to two infusionsoft fields on import.

6

Tim, there are 2 areas where you likely ran into issues. One is the spreadsheet and resulting csv and the other is the field matching when importing.

On the spreadsheet first make sure that you do not have multiple columns with the same header. Then (and I know this sounds silly, but it can happen depending on how big the spreadsheet is!) make sure you don’t have duplicate name columns on there. If nothing else on here works you might also want to try opening the csv in notepad to see exactly what it looks like, but can be difficult to read, especially if the spreadsheet it is based on is large. Also, if you haven’t already, I would HIGHLY recommend separating the first and last names into different columns on your spreadsheet before importing.

When importing there is a step where you match the fields (step 6 in the link that @martinc provided earlier). Make sure to pay close attention to that, especially the name fields. I have seen all kinds of things here you have the first name trying to map to the last name, etc.

As long as you follow those steps and pay close attention things should go smoothly. Good Luck!

1 Like
7

Hello! You can try an automated tool - Data2CRM. The SaaS can help you move the contacts effortlessly and securely. You can also try a free Demo Migration to explore how the service functions in action.