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

Datamerge can't import csv files anymore that were Excel and exported bij Numbers

Explorer ,
Sep 13, 2023 Sep 13, 2023

Copy link to clipboard

Copied

Is this a error in Numbers or in InDesign.

 

I can merge the Excel file, but not the exported Numbers file. The only thing that works now is that I export to .txt file. Is this chanched in the update or what is the best way to connect for Datamerge.

Thanks, Henri

TOPICS
Import and export

Views

53

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 1 Correct answer

Explorer , Sep 21, 2023 Sep 21, 2023

Hello,

I openend the Excel file and saw imediatly what was wrong. In the headerrow in the first cel was nothing placed. And that was the issue. After that the csv worked well... I think the pressure for the order was the thing I didn't look to well, excuses. Thanks for your time Eugene.

Votes

Translate

Translate
Community Expert ,
Sep 15, 2023 Sep 15, 2023

Copy link to clipboard

Copied

What's the file format of the exported Numbers file?
Sometimes datamerge won't work if it's the wrong filetype - or something structurally wrong with the data. 

You'd need to examine your Excel export with your Numbers export in a text editor to determine what is the issue.

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
Explorer ,
Sep 21, 2023 Sep 21, 2023

Copy link to clipboard

Copied

LATEST

Hello,

I openend the Excel file and saw imediatly what was wrong. In the headerrow in the first cel was nothing placed. And that was the issue. After that the csv worked well... I think the pressure for the order was the thing I didn't look to well, excuses. Thanks for your time Eugene.

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