Forum Discussion

GiulianoDeLuca's avatar
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

Resources