Importing e-mails csv error

[InnoVites]

Hi,

I get the following error message when I try to import e-mails via csv:

"This file isn't a valid CSV or Excel spreadsheet. This file’s type is message/rfc822."

The funny thing is, I get this message for all types of csv files. Even when trying to reimport the original hubspot error log from a previous successfull e-mail import.

Does anyone know what the cause for this problem could be?

Thank you for your help!

Rgds,

Fred

[SimonSchubert · Accepted solution]

I had the same issue and could solve it.

It seems non-printable characters were the problem.

These non-printable characters are invisible control characters or formatting markers that aren’t typically visible in the content. These include:

Control characters (such as carriage return \r, newline \n, tab \t, etc., that aren’t meant to be displayed in text).

Special non-printable Unicode characters that sometimes get inserted during copy-pasting or exporting from certain platforms.

You can easily remove them with python. The isprintable() function I used ensured that only characters intended for display (letters, digits, punctuation, etc.) were kept, stripping out any hidden formatting issues that could disrupt HubSpot’s import process.

[InnoVites]

Thank you. Converting to xlsx is not possible due to the size of the values which hit Excels limits.

[karstenkoehler]

Hi @InnoVites,

That's indeed strange. This might be a temporary issue with HubSpot. Have you tried again, now that some time has passed since your original post? Does this occur in other browsers as well?

How about converting the file into xlsx?

In any case, this sounds like a bug and you could flag it with HubSpot Support directly.

Best regards