Known Participant

Question

Using Mac Numbers to produce Excel file for placing in ID

Forum|Forum|1 year ago
March 25, 2024
3 replies
1424 views

I am on a Mac and do not have Excel. So I Export to -> Excel from Numbers. I then want to import this Excel file into ID.

ID will not place the file. I get the error message:

It just won't place it. However, I can use this same file in other programs (FileMaker) without issue.

Can anyone out there use Numbers to produce an Excel file and then place it in ID?? Is this a bug or am I missing something?

Thank you.

Import and export

This topic has been closed for replies.

Brad @ Roaring Mouse

Community Expert

The XLSX format is basically a zipped folder of XML entries. What is causing the issue is that Numbers doesn't properly write one of these entries (app.xml) where it requires an entry for "Application". In a normal Microsoft Excel file, this would say:

<Application>Microsoft Macintosh Excel</Application> .

However, Numbers doesn't include anything at this spot (which makes some sense since it's not Excel), but InDesign seems to need something there (e.g LibreOffice will add <Application>LibreOffice/xxxxx</Application>) for the file to be importable.

So, again. the answer now, until Apple finally fixes this, as mentioned, is to export out as the old .xls format.

leo.r

Community Expert

@Brad @ Roaring Mouse

> (e.g LibreOffice will add <Application>LibreOffice/xxxxx</Application>)

...and since you mentioned LibreOffice - which I also thought about - I wonder if @Chloe_Sunshine can just resave the file from LibreOffice?

Brad @ Roaring Mouse

Community Expert

I was going to say that, but then they would have to get Libre up and running only to do that, when just simply exporting as .xls from Numbers would solve the problem. I don't think there's anything an .xlsx would offer InDesign over an .xls. {EDIT: apparently (thanks @Chloe_Sunshine !) Numbers 12.2 and up has removed the .xls export ability, so maybe the LibreOffice route is a possibility. That or actually getting Excel to resave the file)

Joel Cherney

Community Expert

Some years ago, the workaround was to export XLS instead of XLSX, as per this thread from @SJRiegel from 2017. I have no idea if that is still current, but it's worth a try.

Edit: here's the link to the thread

C

Chloe_SunshineAuthor

Known Participant

It doesn't look like the XLS is an option. There's just save as Excel and it ends up being the XLSX variety.

C

Chloe_SunshineAuthor

Known Participant

OK. I see what you're saying, but . . . this is my "Export Your Spreadsheet" dialog box and I sure don't see any Avanced Options!

I have Numbers version 13.2 (7038.0.87), running under Ventura 13.6.5. Why would they be different?

Just googled this. Apparently Numbers 12.2 dropped this feature.

BobLevine

Community Expert

This is a common problem with fake Excel and Word files. The only fix is to open them in Excel and resave them. If you want to report it anywhere, report it to Apple.

If you only have one file, feel free to post it and I'm sure one of us can open and resave it for you.

C

Chloe_SunshineAuthor

Known Participant

Thanks for the input. Just seems strange that FM, for example, can deal with the file but ID can't.

It probably won't be that big an issue - there are workarounds - but I was just curious.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded