View original (French)

Merge a Mac Numbers table into Indesign

Kambro Posted messages 55 Status Member -  
contrariness Posted messages 17903 Registration date   Status Member Last intervention   -
Hello,

I am unable to merge a Numbers document into InDesign; the Numbers file being in the form of a folder with "data", "images", etc., InDesign cannot open it during import.

Thank you in advance for your help,

Configuration: Mac OS X (10.9.5) / Safari 7.1.4

1 answer

  1.
    contrariness Posted messages 17903 Registration date   Status Member Last intervention   6 243
     
    I don't think there is an import filter for this type of file..
    But if you can convert it to Excel, there is an Excel filter available.
    0
    1. Kambro Posted messages 55 Status Member 8
       
      Hello contrariness,

      Thank you for your reply; I can convert it to Excel, but Indesign refuses to import the newly converted file. Is it a mistake on my part?

      Here is the original Numbers file:
      https://www.dropbox.com/sh/ye39x00y5c1hkcz/AABd8LEYD82WWupBiCzbpeRAa?dl=0
      Here is the converted Excel file:
      https://www.dropbox.com/sh/2ee941p4gzh6u2f/AAAOZjtf2nOisGbbyzur1v0pa?dl=0
      Finally, here is what I wanted to achieve in a synchronized manner in Indesign:
      https://www.dropbox.com/sh/ffjwhukc8kq136w/AAB8P-mYdJg9cxXpy-dWLXwwa?dl=0

      Thank you in advance for your service,

      Kambro
      0
    2. contrariness Posted messages 17903 Registration date   Status Member Last intervention   6 243
       
      Sorry, but I don’t have Indesign CC.. (I refuse to subscribe to the rental system for Adobe)...
      For importing into Indesign, make sure you have selected the import filter for Excel and that you have the correct version of Excel (it seems to me that the filter is for versions 97 or 2003). Also activate the “options” so you can choose the best one for your case.
      0
    3. Kambro Posted messages 55 Status Member 8 > contrariness Posted messages 17903 Registration date   Status Member Last intervention  
       
      I completely agree with you about not subscribing to the Adobe system; I take advantage of the fact that my brother has a Creative Cloud subscription for professional reasons, but in your place, I would do the same.
      I tried again, checking what you told me to do, but it replies: "no filter was found to execute the requested operation." I suppose the filter is intended for older versions.
      0
    4. contrariness Posted messages 17903 Registration date   Status Member Last intervention   6 243
       
      In Indesign CS6, there is only the import filter for Excel 2007 (menu "File/Import")
      Try saving it in 2007 version if you have the possibility...
      0
    5. Kambro Posted messages 55 Status Member 8
       
      I believe I exported it from Numbers in Excel 2007 because it offers me .xls or .xlsx; I chose the latter option.
      I then tried to import a randomly downloaded calendar in .xls: it works without problems.
      Then I tried with a table in .xlsx that I had in my archives: it works just as well. So there must be an issue with the conversion in Numbers.
      0