: 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

@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.

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})

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.

Vote Up Vote Down

@Dunderdale640

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

Vote Up Vote Down