Sales Hub Onboarding

InnoVites
Participante

Importing e-mails csv error

resolver

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

0 Avaliação positiva
1 Solução aceita
SimonSchubert
Solução
Participante

Importing e-mails csv error

resolver

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.

 

Exibir solução no post original

3 Respostas 3
SimonSchubert
Solução
Participante

Importing e-mails csv error

resolver

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
Participante

Importing e-mails csv error

resolver

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

0 Avaliação positiva
karstenkoehler
Membro do Hall da Fama | Parceiro
Membro do Hall da Fama | Parceiro

Importing e-mails csv error

resolver

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

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.