Forum Discussion

Mammifero's avatar
Mammifero
Copper Contributor
Feb 08, 2021
Solved

sharepoint import excel file with TAGS column

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

SharePoint Online
  • nimesh_th's avatar
    nimesh_th
    Feb 08, 2021

    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 Replies

Sort By
  • AnniSand's avatar
    AnniSand
    Copper Contributor
    May 13, 2022
    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.
  • nimesh_th's avatar
    nimesh_th
    Copper Contributor
    Feb 08, 2021

    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.

    • Mammifero's avatar
      Mammifero
      Copper Contributor
      Feb 08, 2021

      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 

Resources