Importing customers from a spreadsheet with special characters

Import contacts into CRM from a spreadsheet with special characters

Download Contact Management Software     Reached the Final for a CRM Award in the Software Satisfaction Awards 2011 Reached the Final for a CRM Award in the Software Satisfaction Awards 2012

CRM Testimonials

When importing customers from a spreadsheet into Amphis Customer, you may see an error if there are special characters in the spreadsheet such as vertical bars.

Import Spreadsheet Special Characters

Find the Special Character in the Spreadsheet

The special character will be displayed in the text box on the error page so you can simply copy and paste it from there into a search field and search for the special character in the spreadsheet. The most common special character found is a vertical bar separator character |.

Don't confuse the vertical bar with a I or L character. The vertical bar is not a normal character. You'll normally find it to the left of Z on your keyboard and you need to press shift.

Separator Special Character Vertical Bar

If you replace all instances of | with a capital I which looks similar and doesn't cause problems for the Import, that will fix the problem.

Replace or Delete the Special Character in the Spreadsheet

Having found the special character in the spreadsheet, you can either delete it or replace it with a similar character which doesn't cause problems for the Import.

For a vertical bar character that looks like this...

Import Spreadsheet Special Character Vertical Bar

you could replace it with a capital I which looks like this.

Import Spreadsheet Special Character

Just go into Excel and click Ctrl F to bring up the Find and Replace form. Click the Replace tab.

Enter the vertical bar separator character into the top field.

Separator Special Character Vertical Bar

Enter I into the bottom field. Click Replace All. That will replace all the vertical bar characters with I to fix the problem. Save your spreadsheet and try the Import again.

Replace Special Character

Video

 

More Information

We have some short CRM Videos about Amphis Customer CRM Software and also a CRM Quick Guide with more details and screenshots. We have Prices, Customer testimonials and CRM Software Case Studies or why not Download our CRM Software Free 60 Day Trial and try it for yourself ?


Download CRM Software Free 60 Day Trial
Download CRM Software Free 60 Day Trial

Bookmark and Share