Forum Discussion
Invalid CSV format - number of col in rows do not match number of columns in headers-missing commas?
Hi Colleagues, how is it possible that when uploading csv format with org file I got an error message that number of columns in row does not match number of columns in header? why is it only for some of them and not for all? Do you know how to fix it? Should I add the commas manually?
Hi VI_Migration, I recommend taking a look at this page of the documentation to fix validation errors such as this one.
In your case, it may be that certain cells have commas already which may have messed up the conversion from spreadsheet to csv - I'd check for that first then check for missing commas on the rows/columns that the error message indicates.
1 Reply
- Jake_Caddes
Microsoft
Hi VI_Migration, I recommend taking a look at this page of the documentation to fix validation errors such as this one.
In your case, it may be that certain cells have commas already which may have messed up the conversion from spreadsheet to csv - I'd check for that first then check for missing commas on the rows/columns that the error message indicates.