Skip to main content
C
Claire29560469umnz
Participant
April 24, 2023
Answered

Impossible to import Excel sheet

  • April 24, 2023
  • 3 replies
  • 1544 views

Hi,

I have many excel documents to import in Indesign. Most of them have been imported without any trouble, but some can't be imported. I receive this message (translated from french) : "Impossible to convert this document. An undetermined error occured during conversion."

I did not create the excel docs, but they seem to be all similar (same presentation, very simple..), all created and saved in excel... I tried to rename the problematic ones, to import them in another indesign document...

What's wrong ?

Thanks

    This topic has been closed for replies.
    Correct answer Brad @ Roaring Mouse

    Have you tried to resave one of the problematic .xlsx files as old school .xls?  This saves it as a non-XML-based file which sometimes clears "issues".

    That being said, I had no issues importing formatted tables from either one of your supplied files: no errors.

    3 replies

    Brad @ Roaring Mouse
    Community Expert
    Brad @ Roaring MouseCommunity ExpertCorrect answer
    Community Expert
    April 27, 2023

    Have you tried to resave one of the problematic .xlsx files as old school .xls?  This saves it as a non-XML-based file which sometimes clears "issues".

    That being said, I had no issues importing formatted tables from either one of your supplied files: no errors.

      C
      Claire29560469umnzAuthor
      Participant
      April 27, 2023

      I tried to save it as an .xls and it worked ! Doing that, I also resaved the original one, which was in "protected mode", and now I can import this "resaved" original one. It doesn't make sense because they are all saved in that mode...

      Thank you !!

      C
      Claire29560469umnzAuthor
      Participant
      April 27, 2023

      Any idea ? I tried to copy and paste the table in another excel sheet, still doesn't work...

      BobLevine
      Community Expert
      BobLevineCommunity Expert
      Community Expert
      April 27, 2023

      I had the same issue and noticed a very large range in that named sheet. I changed it to A1:L3 and it imported fine. I think there might be a bug at play here with all of those empty cells.

      C
      Claire29560469umnzAuthor
      Participant
      April 27, 2023

      Ok, thanks for your help. The only solution I found today is to import the first line of the table and then copy/paste the table from excel to indesign...

      BobLevine
      Community Expert
      BobLevineCommunity Expert
      Community Expert
      April 24, 2023

      There's no way to tell unless we can see them. Also, are they XLSX or XLS? What version of InDesign and what are your import options?

      C
      Claire29560469umnzAuthor
      Participant
      April 25, 2023

      I have the last version (pro license). Every file is xslx. The options are basics : Sheet1, cells of the table, "organised" table, activ calcul sheet... (see joined image). I use the same options for every table.

      I joined 2 tables, 1 working and 1 not working.

      Terms & ConditionsAccessibility statement
      Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices