Another problem could be that your separator, usually a comma, is present in a text field that is not delimited by quotes,  making that field into 2 fields giving you an extra column in that row.

Will

Will

William G. Cowan
________________________________
From: Code for Libraries <[log in to unmask]> on behalf of Max <[log in to unmask]>
Sent: Monday, January 16, 2023 7:22:29 PM
To: [log in to unmask] <[log in to unmask]>
Subject: [External] [CODE4LIB] "The rows are not all the same number of columns."

[Some people who received this message don't often get email from [log in to unmask] Learn why this is important at https://aka.ms/LearnAboutSenderIdentification ]

This message was sent from a non-IU address. Please exercise caution when clicking links or opening attachments from external sources.
-------

Hi code4lib folks:

Does anyone know a tool or hack to help fix a problem at a CSV that's
causing a "The rows are not all the same number of columns." error when
trying to import the CSV at a web application? I'm trying to use the CSV
Import module <https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fomeka.org%2Fs%2Fdocs%2Fuser-manual%2Fmodules%2Fcsvimport%2F&data=05%7C01%7Cwgcowan%40iu.edu%7C98d9cc93c4fa41a28a7e08daf82183c8%7C1113be34aed14d00ab4bcdd02510be91%7C0%7C0%7C638095120077267200%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=PjRN47Tr82ap7rllK%2FKDSiSDKXbzxyqkGzpNWaqX%2BRU%3D&reserved=0> at
Omeka S. I've had success in the past with different CSV files. But some
kinda problem at the CSV I'm trying to import right now is causing this
error, & reviewing the CSV in Excel & as plain text (literally counting
commas to confirm rows are the same number of columns) isn't helping.
Thanks!

Cheers all,
Max

Maxwell Gray
https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fmaxgray20.com%2F&data=05%7C01%7Cwgcowan%40iu.edu%7C98d9cc93c4fa41a28a7e08daf82183c8%7C1113be34aed14d00ab4bcdd02510be91%7C0%7C0%7C638095120077267200%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=9Y%2FNtdNU1c%2Bj%2BXvPrugoNWpvafhKCES4Sd5rK1yiu%2Bg%3D&reserved=0