Forum Discussion
Jul 10, 2025
Excel to Microsoft Lists: Import Multi-Choice Columns the Smart Way! 🚀
✨ Want to import an Excel table into Microsoft Lists without losing multi-choice column data?
This video shows you a smart workaround that lets you:
- Use ;# to separate multiple values in a cell
- Import those into SharePoint / Microsoft Lists as Choice columns
- Automatically convert them into an array for use with JSON formatting, filters, and searches
Say goodbye to manually editing items one by one! 🙌
👉 Follow me for more Microsoft 365 & SharePoint tips!
📌 Post inspired by: LinkedIn post kudos to Federico Sapia
No RepliesBe the first to reply