Forum Discussion
SP List Import Choice Column
I have a spreadsheet containing approx. 20 columns thousands of rows. I have created a new SP online list to match the spreadsheet layout, now I want to import the spreadsheet, however a few of t...
Hi,
I am working on the presumption that you are importing from excel?
1. As long as the wording matches how it is written in the choices of sharepoint it will put them in and assign the colour, It does need to be exact though or you will get an error each time, So if you have Smith as the choice Smiths, Smth, miths will all be errors. This is an easy enough fix by just filtering the choice columns in excel and making sure they are in the correct format.
2. Yes when in edit in grid view you can paste multiple rows in as long as the same amount of columns are populated. It will populate the read only also.
Hope this helps.
Thanks,
Edd
I am working on the presumption that you are importing from excel?
1. As long as the wording matches how it is written in the choices of sharepoint it will put them in and assign the colour, It does need to be exact though or you will get an error each time, So if you have Smith as the choice Smiths, Smth, miths will all be errors. This is an easy enough fix by just filtering the choice columns in excel and making sure they are in the correct format.
2. Yes when in edit in grid view you can paste multiple rows in as long as the same amount of columns are populated. It will populate the read only also.
Hope this helps.
Thanks,
Edd