Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
1

Importing .xlsx into InDesign

Community Beginner ,
Jul 10, 2023 Jul 10, 2023

Help!

I'm designing a quote template document for a client - in which they'd like an editable table that can add up their inputted data (once exported as a pdf). I'm not exactly sure how to pull this off - but thought I'd start by importing/placing an excel/numbers table as a starting point. No matter what I do, what preferences are clicked - every time I try to place any .xlsx file - InDesign says: "Cannot place this file. No filter found for requested operation." I've tried different formats from numbers, to excel, to downloaded sheets from google docs - no luck. I've checked the "create links when placing text and spreadsheet files" box under Preferences > File Handling, too. My mac software and adobe software is all up-to-date. 

 

Any help/advice would be really appreciated. Thanks!

Thank you!

 

 

TOPICS
Bug , Feature request , Import and export , Performance
653
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Jul 10, 2023 Jul 10, 2023

This is typical of "fake" Excel documents created in other applications such as Google Sheets. Was the file actually saved in Excel?

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
Jul 10, 2023 Jul 10, 2023

Thanks for responding so quickly! The original file is made in Numbers - not Microsoft Excel (I don't have it). Will find and try an original Excel file.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Jul 10, 2023 Jul 10, 2023

Hi @Sofia Sabella , From Numbers try choosing .xls rather than .xlsx as the Export Format

 

Screen Shot 3.png

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
Jul 19, 2023 Jul 19, 2023

Hi @rob day

I don't have this as an option when exporting! 

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Jul 19, 2023 Jul 19, 2023

Looks like Apple dropped the option. I rarely use Numbers and am still using an old version 6.1

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Jul 19, 2023 Jul 19, 2023

I have a feeling you are going to need to save the .xlsx directly from Microsoft Excel.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Jul 19, 2023 Jul 19, 2023

As I mentioned earlier, these fake Excel files just don't work. Issues also arise with fake Word docs. Opening in the real programs can usually, but not always help.

If the OP would like to post the fake Excel file, I'll be happy to open it and resave it here to see if helps.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Jul 19, 2023 Jul 19, 2023

My Apple Number’s .xls export Format works, but looks like the newer Numbers versions no longer include that option.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
Jul 19, 2023 Jul 19, 2023
LATEST

Hi @BobLevine - will try this tomorrow. Will borrow someones microsoft excel! Appreciate that offer - am currently only in testing mode - so don't even have the proper excel sheet ready. If I can't get access to one - might take you up on that! 

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
Jul 19, 2023 Jul 19, 2023

I'm going to borrow a laptop with Microsoft Excel tomorrow and try reworking. Thanks @rob day 

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines