Jump to content
ivan lavosky

Automatic data filling based on Excel

Recommended Posts

Hi,

I am using Affinity Designer.

I want to create around 200 namecards with different name and other personal data printed on it. 

I have created the base template for the namecards and I also already had the names and data of the people that will be printed to that namecards.

Is there any way to automatically fetch the personal data from other source like Excel into Affinity Designer? So my namecards would be automatically filled with the prepared data.

 

Thanks for your help

Share this post


Link to post
Share on other sites

Hi ivan lavosky and Welcome to the Forums,

We don't have data merge just yet.  It's something that should be coming to Publisher at some point and might make it's way into Designer if the Dev team feel it fits with Designer.

 

Share this post


Link to post
Share on other sites

This is for Publisher (not Designer) but you can currently get the beta version of Publisher for free so you might want to try it. (Or anyone else that wants to try it)

Set up a new document page the size of your namecard

Add a blank text frame and change the font, font size etc to what you want printed.

Outside of Publisher take your Excel file (or whatever) and create a text file with the names and data that you want printed on each namecard.

In that text file end each person's data with a unique set of characters like xxxxxx

Back in Publisher in the text frame select Text > Insert Text From File and insert the text file you just created.

Use Text > Find to find and replace all occurrences of xxxxxx with a page break command

Then Shift-Click the text flow arrow of the text frame to automagically add a new page for all the data records in your text file.

Hopefully you will end up with 200 namecards ready to print but I don't have the time to create 200 data records to test this out so consider the above a working theory of how I would try it, you may need to make adjustments along the way.


Due to the fact that Boris Johnson is now our Prime Minister, punctuation, spelling and grammar will never be worried about ever again.  We now have far bigger problems to be concerned about.

Share this post


Link to post
Share on other sites

Another possibility is to store/export your Affinity Designer namecard layout with some embeded name place holders (#name# etc.) into some portable text editable format like SVG/EPS and then use some script or scripting language to do your own data merge handling with that namecard file then.


☛ Affinity Designer 1.7.3 ◆ Affinity Photo 1.7.3 ◆ OSX El Capitan

Share this post


Link to post
Share on other sites

Hi there,

I've just tried the idea to use Affinity Publisher with excel file to propagate files with unique text.

Unfortunately, I cannot upload any data file (I tried: xlsx, csv,  ods). Is this feature available in Beta version of the Publisher?

 

 

Share this post


Link to post
Share on other sites
5 hours ago, OdFori said:

Any update?

This function is not yet supported.

You will know it's available when it appears in one of the beta releases, probably for Publisher not Designer if I had to guess.


-- Walt

Windows 10 Home, version 1909 (183623.476), 16GB memory, Intel Core i7-6700K @ 4.00Gz, GeForce GTX 970
Affinity Photo 1.7.3.481 and 1.8.0.514 Beta   / Affinity Designer 1.7.3.481 and 1.8.0.514 Beta  / Affinity Publisher 1.7.3.481 and 1.8.0.518 Beta

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×

Important Information

These are the Terms of Use you will be asked to agree to if you join the forum. | 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.