Copy link to clipboard
Copied
Trying to place a simple .xlsx file into InDesign and get the attached error message. What the heck?
I converted it to .csv using google docs just to see if maybe it was a problem with the .xlsx. It wouldn't even give me the option to place it. Weird thing that I'm using the same CC version on my Mac at work (well, I think it's the same version, anyway since we use CC) and it places .xlsx files created with Google docs just fine since I do it all the time at work. Not sure why the one at home doesn't work. Could it be the OS? Using High Sierra here at home and Mojave at work.
UPDATE: I just trie
...Copy link to clipboard
Copied
Was the file actually created in Excel or another application and saved as Excel?
Copy link to clipboard
Copied
According to my customer, it was created in Microsoft Office Excel. I tried converting to a .csv file and InDesign won't even recognize it. I just tried to import another .xlsx file that I know for a fact was created in Microsoft Office Excel and it gives me the same message.
Copy link to clipboard
Copied
Is this happening with all InDesign files or just this one? If it’s just this one, export it to IDML and try with that. If it’s all of them, then try resetting your preferences.
Copy link to clipboard
Copied
I'm creating a new page. I'm not opening an existing INDD file and placing. It's a new doc. I even tried uninstalling INDD and reinstalling. No go.
Copy link to clipboard
Copied
Tried resetting my preferences. Didn't work.
Copy link to clipboard
Copied
3rdrockgraphics wrote
According to my customer, it was created in Microsoft Office Excel.
Ask again, and ask specifically if it was created in another program such as Google Docs and then saved as an Excel file.
Can you open it in Excel and resave it?
~ Jane
Copy link to clipboard
Copied
I can only open in Google docs myself. I don't have Excel. I'm on a Mac and don't have Office. I tried resaving it, didn't work. No, I cannot import ANY Excel files at all. I tried a few others that i know for a fact were created and saved in Excel (as I mentioned earlier) and those won't import either.
Copy link to clipboard
Copied
3rdrockgraphics wrote
I can only open in Google docs myself. I don't have Excel. I'm on a Mac and don't have Office.
Hi
If you don’t have Excel, how did you open it and convert it to .csv?
When you converted it to .csv, did you keep it as a text only file? Or accidentally save again in another native format? A .csv is text only and can’t hold any formatting at all. That’s another thing to double-check.
I also have a Mac. Office 365 can be put on 5 devices and it’s okay to mix Windows and Mac.
Jane
Copy link to clipboard
Copied
I converted it to .csv using google docs just to see if maybe it was a problem with the .xlsx. It wouldn't even give me the option to place it. Weird thing that I'm using the same CC version on my Mac at work (well, I think it's the same version, anyway since we use CC) and it places .xlsx files created with Google docs just fine since I do it all the time at work. Not sure why the one at home doesn't work. Could it be the OS? Using High Sierra here at home and Mojave at work.
UPDATE: I just tried resaving and renaming the same file using 365 (a friend has it) and it places fine. The frequency I would need Office 365 just doesn't warrant the $ to spend on it, really (even tho it's cheap, I know). I'd say maybe 5x a year I need it.
I also just tried using zamzar online to convert the xlsx customer sent to xls and THAT worked too.
I guess I'm all set! Thanks to everyone for all their help!
Copy link to clipboard
Copied
FWIW, O365 (IMO) is well worth it for OneDrive alone. That and you can share it with five others who also get their own storage and account for use on 5 different devices and you have a big bargain.
Copy link to clipboard
Copied
Ok I just tried ANOTHER xlsx file and THAT one worked! Could it be a certain version of Excel like a really old one might cause this problem?
Copy link to clipboard
Copied
3rdrockgraphics wrote
Ok I just tried ANOTHER xlsx file and THAT one worked! Could it be a certain version of Excel like a really old one might cause this problem?
Hi
A really old version of Excel would be .xls. They changed the format in 2007 and renamed the extension to .xlsx. The older .xls files should also work.
~ Jane
Copy link to clipboard
Copied
You just saved my life in 2020 with the zamzar online resource. I've been looking for like an hour for a solution to this same issue. I also don't use any Office programs frequently enough to justify buying it. Anyway, thank you from the future. 2020 is garbage but you just made it a little better.
Copy link to clipboard
Copied
Same here! Converting the .xlsx file to .xls with zamzar online worked for me and saved sooooooooo much time. THANK YOU SO MUCH!
I made .xlsx with google doc then convert it into .xls.
inDesign 2021 v16.2.1
Mac BigSur v.11.4
Copy link to clipboard
Copied
Never heard of Zamzar before, saved me loooot's of time today...
Thanks