Mobile app version of vmapp.org
Login or Join
Miguel516

: InDesign corrupts imported excel-files. Win/Mac issue with character sets I'm on a Mac, working on an InDesign file. I get some XSLX files with numbers in them, and when I place them into my

@Miguel516

Posted in: #AdobeIndesign #Mac #MicrosoftExcel

I'm on a Mac, working on an InDesign file. I get some XSLX files with numbers in them, and when I place them into my document, all spaces are replaced with an 'Ê'. I'm thinking this is some issue with character sets, but I'm unable to fix it.

There seems to be no option to save an XSLX file to another character set from Excel. I tried to import my file to Google Sheets, and export it again (this should set the character set to UTF-8), but then InDesign wont allow me to place it in my document at all.

Any ideas?

10.04% popularity Vote Up Vote Down


Login to follow query

More posts by @Miguel516

4 Comments

Sorted by latest first Latest Oldest Best

 

@Lengel450

I could not get Excel files with thousand separators to show correctly in InDesign. As I said in my question the separator get's replaced by an "Ê". I could of course do a search and replace for this symbol but that is not a good solution since I will have to repeat this each time I change any linked excel-file.

My solution was to remove the separator in the Excel-file and add a GREP-style in InDesign that uses a bigger tracking unit on every third digit.

10% popularity Vote Up Vote Down


 

@Phylliss782

It's a known bug caused by the separator.
You can disable the separator (or change it) in Excel, but if you want to keep your spaces, best acceptable solution is a Grep find/change query : (?<=d)Ê(?=d{3})

10% popularity Vote Up Vote Down


 

@Holmes874

You can simply copy and paste xls tables into indesign, as long as you create a table large enough. Although when there are merged cells in the xls the pasted formatting may jump rows. Just be careful and double check everything.

10% popularity Vote Up Vote Down


 

@Dunderdale640

Try exporting excel sheet as a tab delimited text file and make a new table, typefaces etc.

10% popularity Vote Up Vote Down


Back to top | Use Dark Theme