Differences Pulling in Data from Excel vs CSV

1

Hi EM community,

I am wondering if anyone can tell me what is going on. I have a file that I pull manually from a client portal. The native format of that file is xlsx. If I try to load it in as is I get errors for “null string was not in the correct format” or “yyyy-MM-ddT00:00:00 Input string was not in the correct format.”

When I save the file, instead as a CSV, it loads in beautifully without any other changes.

Does anyone know what causes this issue? I am assuming it has to do with the data type being a date in excel and then converted to a string when the file is saved as a CSV.

image
image808×651 9.59 KB

Here is what the formatting looks like in excel.

image
image536×686 15.1 KB

Any pointers would be greatly appreciated!

2

Most probably the xlsx file is generated by a 3rd party utility that doesn’t stick to the specification and generates a file with a broken structure. Since there is a broad variety of such 3rd party tools, EasyMorph can recover some but not other malformatted xlsx files. You happened to get a file that EasyMorph can’t recover (yet).

If the CSV format works for you, I would suggest sticking with it for now. If not, send the XLSX file to our support and our engineers will analyze what’s wrong with it.

3

Hi, Twitch.

The Excel Command action (Workflow; External) has a “Re-save” option that may resolve the formatting issues.

So, plug this in first, to Re-Save/“fix” the file, then Import. See if that’s any better. :+1:

CraigT

1 Like
4

CraigT,

This worked! Thank you sir.

Best,

Sean