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

Import single cell values from Excel

New Here ,
Aug 14, 2020 Aug 14, 2020

Copy link to clipboard

Copied

Hi everyone, is it possible to import single cell values from Excel into a cell (existing table)?

Glad about any help!

 

Adobe InDesign CC 2020

TOPICS
How to , Import and export , Print

Views

1.6K

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

correct answers 3 Correct answers

Community Expert , Aug 14, 2020 Aug 14, 2020

Linking between InDesign and Excel doesn't work well. Any formatting applied in InDesign gets lost when you update.

 

I'm told that a good alternative is WordsFlow from Em Software. "

  • What if you could place Word and Excel documents with live links in InDesign, and proceed with production, while your authors and editors continued working on the original documents?"

 

http://emsoftware.com/products/wordsflow/

Votes

Translate

Translate
Advisor , Aug 23, 2020 Aug 23, 2020

You can certainly copy/paste. But it seems to me you could also use import options for Excel (select file name, then hold down the Shift key while clicking the Place button); the import options dialog lets you restrict which cell or cells you want to import. 

You could set up the linking feature in Preferences (File Handling > Create Links When Importing Spreadsheet). As Steve mentions, you'll can lose formatting when the link is updated, but if you apply a Cell Style, this is easily corrected.

...

Votes

Translate

Translate
Community Expert , Aug 24, 2020 Aug 24, 2020

I agree with Diane, so long as the table has cell styles that are well formed, the incoming content from the table should come in based on the cell style formatting. Also, using the show import options feature, it is possible to control what cells you want to /not to import. For example:

 

Screen Shot 2020-08-24 at 21.21.18.png

 In this example I've created a table style called table style 1 and have assigned cell styles to the body rows. When I use the show import options feature, I can also give it the cell range, I don't have to

...

Votes

Translate

Translate
Community Expert ,
Aug 14, 2020 Aug 14, 2020

Copy link to clipboard

Copied

There's no Import command. But if you select the content of the destination table cell, select the content of the Excel cell and copy and paste.

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
New Here ,
Aug 14, 2020 Aug 14, 2020

Copy link to clipboard

Copied

Copying and pasting would be one possibility, but I would like to have control over the values if something changes in the source 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 ,
Aug 14, 2020 Aug 14, 2020

Copy link to clipboard

Copied

Linking between InDesign and Excel doesn't work well. Any formatting applied in InDesign gets lost when you update.

 

I'm told that a good alternative is WordsFlow from Em Software. "

  • What if you could place Word and Excel documents with live links in InDesign, and proceed with production, while your authors and editors continued working on the original documents?"

 

http://emsoftware.com/products/wordsflow/

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
Advisor ,
Aug 23, 2020 Aug 23, 2020

Copy link to clipboard

Copied

You can certainly copy/paste. But it seems to me you could also use import options for Excel (select file name, then hold down the Shift key while clicking the Place button); the import options dialog lets you restrict which cell or cells you want to import. 

You could set up the linking feature in Preferences (File Handling > Create Links When Importing Spreadsheet). As Steve mentions, you'll can lose formatting when the link is updated, but if you apply a Cell Style, this is easily corrected. If you have access to LinkedIn Learning/Lynda.com, I have a video on this topic. Here is the LinkedIn Learning video: https://www.linkedin.com/learning/indesign-tables/working-with-linked-word-and-excel-documents

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 ,
Aug 24, 2020 Aug 24, 2020

Copy link to clipboard

Copied

I agree with Diane, so long as the table has cell styles that are well formed, the incoming content from the table should come in based on the cell style formatting. Also, using the show import options feature, it is possible to control what cells you want to /not to import. For example:

 

Screen Shot 2020-08-24 at 21.21.18.png

 In this example I've created a table style called table style 1 and have assigned cell styles to the body rows. When I use the show import options feature, I can also give it the cell range, I don't have to bring in the whole spreadsheet.

If the answer wasn't in my post, perhaps it might be on my blog at colecandoo!

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 ,
Aug 25, 2020 Aug 25, 2020

Copy link to clipboard

Copied

LATEST

Hi MASSON-RK21,

don't know exactly what your scenario is.

 

Do you have a table in InDesign that is not linked to an Excel file and you want to update the contents of one single cell through place and link of a table file from Excel?

 

This could be done if you place and link one cell of that Excel table aside from the other table in its own text frame and anchor the text frame to a text cell in your table. Every time you update the placed and linked Excel file the anchored one cell table can be updated through the Links panel.

 

But of course this is a very clunky, perhaps insane workflow.

 

Regards,
Uwe Laubender

( ACP )

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