Need help with Excel file import Issue.

[Lisa Goldman]

Hello,

I have an Excel file that I'm trying to import into the question_choice table. The file includes a "Text" column with data, but during the import preview, the "Text" column appears empty.

Any assistance would be appreciated.

[Rafael Batistot · Accepted solution]

Hi @Lisa Goldman 

The "Text" value not come in the template from question_choice, may you try via transformap 

https://www.servicenow.com/community/developer-forum/add-question-choices-to-a-select-box-variable-b...

[Shashank_Jain]

@Lisa Goldman ,

I tried it on PDI!

If you are importing it via excel template it won't work!

For the column Text, I think that is not proposed because it's translated Text but you can fix it: import it via data source.

It will populate the text value correctly!

Hope it helps!
 

[Shashank_Jain]

Hii @Lisa Goldman ,

You can select multiple answers as accepted.

If this helped you, please mark it as accepted. That will be much appreciated!