Import linked records with Excel CSV

[esforim]

You mean not need to EXCEL/CSV CONCATENATE right?

If so I would: create 3 field? And third field in EspoCRM use a CONCATENATE formula?

[harrytruman]

Hi Everyone,

I'm trying to upload a CSV of linked records. The first column has unique identifiers to update by. The second column is a list of record ID numbers that correspond to records in the first column. See attached screen shot.

When I upload a file like this, it only updates the linked records field with one value. The correct way to do this in Espo is to have column 1 with one ID number and the next row cell has a list of record ID numbers like 82400, 84500, etc.

Is there another way to upload a CSV like this without having to CONCATENATE the contents of a row into one cell. Any ideas. Thanks!