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

Importing .xlsx into InDesign

Community Beginner ,
Jul 10, 2023 Jul 10, 2023

Copy link to clipboard

Copied

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

Views

327

Translate

Translate

Report

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

Copy link to clipboard

Copied

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

Votes

Translate

Translate

Report

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

Copy link to clipboard

Copied

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.

Votes

Translate

Translate

Report

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

Copy link to clipboard

Copied

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

 

Screen Shot 3.png

Votes

Translate

Translate

Report

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

Copy link to clipboard

Copied

Hi @rob day

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

Votes

Translate

Translate

Report

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

Copy link to clipboard

Copied

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

Votes

Translate

Translate

Report

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

Copy link to clipboard

Copied

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

Votes

Translate

Translate

Report

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

Copy link to clipboard

Copied

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.

Votes

Translate

Translate

Report

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

Copy link to clipboard

Copied

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

Votes

Translate

Translate

Report

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

Copy link to clipboard

Copied

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! 

Votes

Translate

Translate

Report

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

Copy link to clipboard

Copied

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

Votes

Translate

Translate

Report

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