Welcome!

Data Uploader Errors

Hello,

I am attempting to upload a csv into a smartsheet plan. I am getting about 60% of my rows imported successfully while about 40% are continuously skipped. Some of these rows contain odd characters in various cells that are not traditional letters/numbers. I am unable to figure out why.

For context I am reviewing the Log Messages. Almost all of my errors have a similar associated message. "Error reading Excel File. Expected 75 columns, but row 249 has 74". Can anyone help me interpret this? I am attaching and uploading a csv so I am unsure why its reading an excel file. I also don't know how to investigate the columns piece of the error message.

Any insight would be very helpful

Find more posts tagged with

Comments

L_123

Check the last comma in the file. if there isn't a comma at the very end try adding one and saving it, and vice versa.

If that doesn't work -

Try opening the file in excel and saving it as xls or another excel filetype then importing it.

Matt@spec

Happy New Year!! Could you tell me if a fix was ever presented for this? I am having the same issue. I did check and a comma is set after the last column. If i convert to .xls, it works fine. Unfortunately, this is not a fix as we can only currently push out .csv from our system. I have attached a screenshot of the current log. Any help would be greatly appreciated.

Screen Shot 2019-03-1 at 10-28-43.png

_Stephanie_

I'm having the same problem. It's skipping 8 out of 37 rows, saying it expected 73 columns but those rows only have 72. I can't see any difference between those 8 rows and the others. All have commas a the end. I saved as .xlsx file and tried again. This time is said it was successful instead of giving me an error message, but then said all the rows had been skipped. I also tried saving as .xls file and it just gave me an error in the settings, saying it couldn't parse the content and no input columns were found.

Has anyone come up with a solution to this? Thanks!

Andrée Starå

Hi Stephanie,

If you haven’t already, I would recommend that you reach out to the Smartsheet Support Team. Smartsheet Support Team

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Sign in to join the conversation!

Quick Links

Trending discussions

I am getting an error message when attempting to export to excel
I am attempted to export to excel. I have two different smartsheet documents to export. One of them exported to excel fine, but not the other. This happened a few weeks ago. I make sure all columns were the correct size & no cells were hidden. "We have found a problem with (file) Do you want us to try and recover as much…
Need Help w/ Report View - Nothing Is Showing
Hello Smartsheet Community, I need some help with a report that I created and shared with a customer. The customer is not seeing any of the information that is pulling into the report. See screen shot below that the customer texted me. I do have the report filter only showing the customer their product pulling from our…
How can I hard code a cell based on a trigger?
BLUF: When I create an Invoice, I need the cell-link to my live price data to be severed. I currently have a Price sheet for my products that is updated frequently. I use Control Center to create Projects, which includes an Invoice sheet. I have a dropdown on my invoice sheet to select a product, and then I use Index…