Skip to main content
S
suseg
Participating Frequently
September 17, 2024
Answered

cuando uso "combinación de datos" en indesign y desde mi mac todos los acentos y ñs son cambiados

  • September 17, 2024
  • 1 reply
  • 751 views

Hola comunidad,

Esto siempre me pasa desde mi mac por lo que tengo que usar indesign desde una pc al hacer diplomas. Cuando utilizo la función de combinación de datos para poner los nombres de los participantes me aparecen con palomitas y otros símbolos en donde lleva tildes y ñs.

Ya probé hacer el archivo con los nombres desde excel y también desde google sheets exportándolo como "valores separados por tabulaciones" (.tsv), todo se ve bien pero al momento de usarlo en indesign aparecen esos problemas.

Correct answer Abhishek Rao

Hi @suseg,

 

I understand how frustrating it can be when accents and ñs don't appear correctly in your merged data, especially when working on important documents like diplomas! Could you please confirm the version of InDesign you're using and provide details about your Mac's operating system?

A possible cause of this issue is the encoding format. When exporting your data from Excel or Google Sheets, ensure that the file is saved as "UTF-16" instead of UTF-8 or ASCII, as InDesign works better with UTF-16 encoding for special characters. Additionally, make sure that the fonts you're using support these special characters. 

 

Let me know if that helps, and feel free to share more details so I can assist further! 😊

 

Thank you, 
Abhishek Rao

1 reply

Abhishek Rao
Community Manager
Abhishek RaoCommunity ManagerCorrect answer
Community Manager
September 18, 2024

Hi @suseg,

 

I understand how frustrating it can be when accents and ñs don't appear correctly in your merged data, especially when working on important documents like diplomas! Could you please confirm the version of InDesign you're using and provide details about your Mac's operating system?

A possible cause of this issue is the encoding format. When exporting your data from Excel or Google Sheets, ensure that the file is saved as "UTF-16" instead of UTF-8 or ASCII, as InDesign works better with UTF-16 encoding for special characters. Additionally, make sure that the fonts you're using support these special characters. 

 

Let me know if that helps, and feel free to share more details so I can assist further! 😊

 

Thank you, 
Abhishek Rao

    J
    Juan_Balay9003
    Participant
    March 7, 2025

    Thank you so much for this answer. This worked perfectly. UTF-16 gives two options, UTF-16 LB and LE. LB worked for me.

     

    Thanks!

     

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices