SOLVED

sharepoint import excel file with TAGS column

New Contributor

esempio.jpg

Good Morning to all from Italy

forgive me for my bad English.

 

i have the following question

i have imported in Sharepoint an excel file with a column called TAGS like in the attached image

if i try to modify in Sharepoint the Column type to Choice (allow multiple choice) no chance to have multiple value imported.
there's a chance to do that ?

 

Matteo

 

thanks to all

2 Replies
Best Response confirmed by Mammifero (New Contributor)
Solution

@Mammifero When using multiple choice option on SharePoint, it uses slightly different separator i.e. instead of semicolon it uses ;# as separator.

Suggest to add a dummy record, export it to excel and then format the file to be copied using Quick Edit view.

@nimesh_th 

a really BIG thanks to your very fast replay

now i have created the right procedure

i have modifyed my excel file like attached image

1.jpg

 

 

 

 

 

after the procedure in the field list i have written the tags value

2.jpg

IT WORKS