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

Google spreadsheet Indesign

New Here ,
Jun 08, 2023 Jun 08, 2023

Copy link to clipboard

Copied

Hello everyone!

I have a project where I need to place a Google Spreadsheet with data from a catalog into InDesign. Using data merging, I can integrate all the data into the InDesign file while preserving the column structure. Now, my question is: is it possible for the customer to make adjustments to the data at a later time? The overall structure will remain the same, but, for example, the price may need to be changed, and I want it to automatically update in InDesign.

Is this possible? Currently, I download the Google Spreadsheet as a .csv file and use data merging, but this prevents automatic adjustments from being made via the spreadsheet that would also reflect in InDesign.

Does anyone happen to have any ideas?

TOPICS
Experiment , Import and export , Print , Scripting

Views

178

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 ,
Jun 08, 2023 Jun 08, 2023

Copy link to clipboard

Copied

This may work for you: DocsFlow » Em Software

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 ,
Jun 08, 2023 Jun 08, 2023

Copy link to clipboard

Copied

Thank you! Do you happen to know if there are any free options available? Or any other method besides applying a data merge?

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 ,
Jun 08, 2023 Jun 08, 2023

Copy link to clipboard

Copied

Well, you get what you pay for. The Em Software solutions are excellent. I have no financial interest in this at all. If you want to manage things, this is the way to go.

 

The only other thing you could consider is linking an Excel spreadsheet and dump the Google Sheets. I will warn you that simply saving a Google Doc or Google Sheet as either Word or Excel will not work properly.

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 ,
Nov 07, 2023 Nov 07, 2023

Copy link to clipboard

Copied

Is it still not possible to import exclusive lists into InDesign and have them automatically updated in the InDesign file whenever changes are made to the exclusive 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 ,
Nov 07, 2023 Nov 07, 2023

Copy link to clipboard

Copied

LATEST

I assume you mean Excel and it has always been possible to link it when placing. 

2023-11-07_07-17-02.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