Announcements
I have an Excel sheet with a column containing either "Yes" or "No". When importing (to a Yes/No Choice field), it appears this is creating an error. Is there something I need to do to the Excel sheet values?
Go to the table you want to import data to, click open in excel
You can then see how data are structured in excel view, for example, Yes/No field are stored as TRUE / FALSE, use this format to translate your data, and then paste them to the excel sheet you just downloaded (the sheet you download here has a dynamic link to dataverse so you can manipulate directly)
Remember to use "publish" button on the right hand side panel to publish your data to dataverse
I just answered this questions with a detailed work through for how to solve it, I don't know what's going on maybe someone just deleted my post
Basically go to the page of your table, click edit in excel, and you can see how Yes No field are stored, they should be "TRUE / FALSE"
@Stevieed Thanks for the response. I have changed and all worked fine...Thank You
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 538
WarrenBelz 420 Most Valuable Professional
Haque 305
