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 the columns in the SP list are type Choice, which is styled with coloured pills.
1. Will my spreadsheet still import successfully, and will the SP list automatically populate the Choice column with the appropriate values and use the pre-defines colours I have configured.
2. One of the columns in the SP list is read only (status), and the default should be 'in progress'. Can I still import the spreadsheet if one of the columns is read only?