sharepoint import excel file with TAGS column

[Mammifero]

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 · Accepted 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.

[#3]

@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

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

IT WORKS 

[#4]

Could somebody please explain the following in more detail please:
" add a dummy record, export it to excel and then format the file to be copied using Quick Edit view. "
Thank you.