Importing Accounts - Mapping Address and Name?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • mudokai
    Junior Member
    • Nov 2025
    • 23

    #1

    Importing Accounts - Mapping Address and Name?

    How do we correctly map import data that has columns for First / Last Name and Address on separate fields but I can't find where the 'Address' field is able to even be mapped individually prior to even considering the fact that 'address' is one input on EspoCRM?
  • heint
    Member
    • Jun 2025
    • 51

    #2
    Greetings.

    Are you trying to import account data in CSV format with the "Export all fields" checkbox?
    Because in step 2 of the import process, I can choose what field I want to map while importing data with the "Export all fields" checkbox on:
    Click image for larger version

Name:	image.png
Views:	0
Size:	33.2 KB
ID:	123528

    Same with the first/second name. I took an example from the lead record, but the logic is the same here:

    Click image for larger version

Name:	image.png
Views:	0
Size:	11.9 KB
ID:	123529

    If you need to import account data from an outside resource where the address field is a single string, you can find the following link useful:
    https://forum.espocrm.com/forum/gene...ce=chatgpt.com.

    Where the idea is to paste all address information into the custom varchar or text field and then parse it to respective fields using a formula script.​

    Comment

    • victor
      Active Community Member
      • Aug 2022
      • 1075

      #3
      The Address field is quite complex and you cannot import data directly into it. The Import file should contain more than one Address column (depending on whether you need, for example, Postal Code and County).

      Click image for larger version  Name:	image.png Views:	0 Size:	5.2 KB ID:	123531

      Comment

      Working...