Skip to main content
B
Blieper
Inspiring
September 13, 2023
Answered

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

  • September 13, 2023
  • 1 reply
  • 189 views

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

    This topic has been closed for replies.
    Correct answer Blieper

    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.

    1 reply

    E
    Community Expert
    Eugene TysonCommunity Expert
    Community Expert
    September 16, 2023

    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.

    B
    BlieperAuthorCorrect answer
    Inspiring
    September 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.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices