Jump to content
You must now use your email address to sign in [click for more info] ×

[Implemented] Data merge

Recommended Posts


This Data merge implementation is awesome news!

I'm unsure this is the right place to post about this (if not, please correct me! :).

I started playing with AP Beta and it seems to be working fine. It seems all the rows of my xlsx file are not recognized: is there a known limitation to the amount of read rows? Or does something needs to be done in the spreadsheet (formatting, file format...)?

Thanks for your help and have a nice day!

Link to comment
Share on other sites

3 hours ago, leminilab said:

Is it the proper place to discuss this issue or is there a dedicated Beta version sub-forum?

Hello @leminilab,

you find forums to report bugs there:



Affinity Designer 1 & 2   |   Affinity Photo 1 & 2   |   Affinity Publisher 1 & 2
Affinity Designer 2 for iPad   |   Affinity Photo 2 for iPad   |   Affinity Publisher 2 for iPad

Windows 11 64-bit - Core i7 - 16GB - Intel HD Graphics 4600 & NVIDIA GeForce GTX 960M
iPad pro 9.7" + Apple Pencil

Link to comment
Share on other sites

On 8/30/2018 at 1:10 PM, Patrick Connor said:


Welcome to the Serif Affinity forums and thank you for your contribution to the Affinity Publisher suggestions.


On 8/31/2018 at 5:21 PM, Patrick Connor said:

@gregoiredierendonck, @Sponka, @debiant, @Josh Mills, @lights95 , @BoloGauranga, @TomJG  @am2008, @J. One, @ilocho and anyone else I have missed (sorry)

Welcome to the Serif Affinity forums :)

I have pinned this popular post to the top of the forum for others to find more easily. I cannot say if this will be implemented anytime soon, but clearly it would be desirable to you and others.

What is the way to integrate images?

Link to comment
Share on other sites

  • Staff
19 minutes ago, polochon said:

What is the way to integrate images?

There is some documentation in the 1.9.0.help already, and the next beta build due soon, has more help on this topic. Questions on functionality are probably best placed in the relevant beta forum, rather than this longstanding feature request

Patrick Connor
Serif Europe Ltd

"There is nothing noble in being superior to your fellow man. True nobility lies in being superior to your previous self."  W. L. Sheldon


Link to comment
Share on other sites

2 hours ago, polochon said:

Before the data merge I inserted a mark. After the merge a full index will appear in the left studio, but when I click "Insert an index" I only get the name of my section and the total range of pages ...  How to ?

As Patrick mentioned above, you should start a new topic in the appropriate Publisher Beta forum for your OS to ask your questions about using data merge.

-- Walt
Designer, Photo, and Publisher V1 and V2 at latest retail and beta releases
    Desktop:  Windows 11 Pro, version 23H2, 64GB memory, AMD Ryzen 9 5900 12-Core @ 3.00 GHz, NVIDIA GeForce RTX 3090 

    Laptop:  Windows 11 Pro, version 23H2, 32GB memory, Intel Core i7-10750H @ 2.60GHz, Intel UHD Graphics Comet Lake GT2 and NVIDIA GeForce RTX 3070 Laptop GPU.
iPad:  iPad Pro M1, 12.9": iPadOS 17.5, Apple Pencil 2, Magic Keyboard 
Mac:  2023 M2 MacBook Air 15", 16GB memory, macOS Sonoma 14.5

Link to comment
Share on other sites

  • 3 weeks later...

  Love this new feature - now its exactly as I wished to have it in 1.0.

Is it planned to build some basic if/then rules? Like    

If "field 1" is not empty, then insert char ", "+"field 1".


Regards, Martin

iMac 27", 2017/Big Sur 11.2.2
MacMini M1/BigSur 11.2.2

Link to comment
Share on other sites

  • 1 month later...

Keyboard is not immediately active after inserting a field.

Doubleclicking on a filed (in the Fields pane) inserts that filed. But keyboard is not immediately active so in order to insert a character (space, return, ..) one has to point and click in the text frame to start typing. It would be nice to have the keyboard ready immediately after a field was inserted.

Link to comment
Share on other sites

17 hours ago, Valencia said:

Affinity Publisher Beta Data Merge is RIDICULOUSLY good!! I've been waiting for years for this, but I'm shocked, even the beta is snappier and better than what I remember working with data sets in Adobe. You guys deserve every award!! 🔥🏆

I appreciate that comment. As we always want more and improved features, it is refreshing to consider the positive advancements that are being made along the way.

Link to comment
Share on other sites

THANK YOU for data merge.

I was just checking it out and it works and its easy and it's amazing.

One last feature to make it perfect for me is probably a bit hard to implement because of the way it works in publisher. I was using Photoshop variable replacements to create .psd files. There I was able to have one field in my csv for the filename. When I export my files in publisher i get numbered files and it's hard to find the right file.


(I am using this in a broadcast environment to create on-air design like lower thirds sometimes for hundreds of people. Good to have the persons name in the filename to quickly find what i am looking for)

Link to comment
Share on other sites

Kudos! Amazing job for the new Datamerge features.

Some little enhancements requests for an updated 1.1 version of it:

1. Add a «Text Overset Detection» report
2. Add a «missing or wrong images path» report, of better before executing the merge
3. Add the ability to use relative path for image base on the location of the sources db file. It’s actually a pain to have to edit the full path each time the a folder is moved.
4. Add a «remove blink fields» option. A must for mailing address datamerge.

... and for a 2.0 version:
1. Add various if/then condition possibilities

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.