How to Use Data Merge in Affinity Publisher 2

Подписаться 1,6 тыс.

Просмотров 12 тыс.

50% 1

This is your tutorial for how to use the data merge feature found in Affinity Publisher & Affinity Publisher 2. This tutorial will teach you the basics of creating your text, creating your CSV file, linking fields and finally generating your document!
Data Merge in Affinity Publisher 1:
You'll find the Data Merge Manager under the Document tab, 3rd from the bottom option.
You'll find the Fields window under the View tab, then choose Studio, then choose Fields option.
Any questions? Leave a comment below!
0:00 Data Merge in Affinity Publisher
0:26 Creating Text Boxes in Affinity Publisher
0:55 Creating a CSV file in Google Sheets
2:10 Bring Your CSV file into Affinity Publisher
2:26 Linking CSV file with Data Merge Fields
3:08 Generate a Data Merged File in Affinity Publisher
3:45 Data Merge in Affinity Publisher Notes in Description
4:00 Let's Hit 1,000 Subscribers!!!
Thanks for watching my video! If you'd like to see more, come back Wednesdays to see a NEW video!!
Use Music on RU-vid without the Copyright Hassle!
Get a 60 free trial to Epidemic Sound for use on YOUR RU-vid Channel!
Use the link here: www.epidemicsound.com/referra...
See behind the scenes of the channel!
Instagram: / theryantuscher

Развлечения

Опубликовано:

8 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 31

@Chrsly Месяц назад

Shouldn't you be busy being Spiderman? Seriously - love these videos.

@zach0069 8 месяцев назад

Usually don't comment on videos like these, but this converted a task that usually takes me over an hour into a process thats

@RyanTuscher 8 месяцев назад

Thanks for watching the video and commenting! I’m happy that it was able to help you! Have a great rest of your day!

@UnrealBucket 5 месяцев назад

Thanks for the useful video. I've just opened the Published for the first time and wondered how to import CSV data.

@alekszewczyk7544 Год назад

Nice video - straight forward, great example explained everything. Liked and subscribed!

@maimai._. 7 месяцев назад

Thank you! This makes it so much easier to understand

@hardikpshah25 11 месяцев назад

Thank you so much Ryan for sharing this! :)

@mochannel2482 10 месяцев назад

Great video. Thank you so much

@novembremullins3562 6 месяцев назад

Oh my lord almighty, thank you so much. This was immensely helpful.

@AndrewStephensonKDPLowContent Год назад

Great video, Ryan. I've been using Affinity and the precursors (Serif suite) for years and it's great. I make low content books and the data merge is brilliant for planners, diaries and prompt journals. I was holding off buying V2 because, for what I need, V1 does it all. But I think I'll take advantage of the universal license offer they have on at the moment- Publisher, Designer and Photo for £89- because I'm sure there'll be new features in the future that won't appear on V1. Subbed, by the way!

@PerfectPencil 5 месяцев назад

I bought this software specifically to do this. First project 26 columns and 100 lines. Woof. All in all though, money and time WELL spent. Doing it by hand would have been nuts considering they keep changing the the values on me.

@ParlorPunch Год назад

Great job Ryan, quick and helpful! Is there a way to export each individual page? you mentioned making business cards, which is what I'd like to do. How do you automatically export each one of those individual cards as a png or jpg? thank you again

@blackkitt98 5 месяцев назад

Great tutorial! Is it possible then to batch export each page as its own file? So in your example, instead of a PDF with all the pages together, each one as an individual jpg.

@rfcesq5474 2 месяца назад

Excellent video. As an aside, Affinity's inability to work with Google Sheets without export makes me want to scream.

@MrIstuff Год назад

Thank you, how will I go about preserving the text box size if i want the generated text to stay within a specific area?

@RyanTuscher Год назад

The Data Merge also works with the Frame Text Tool. You can use the frame text tool to keep your text within a given area instead of extending in one long line. The process is the same for linking the object and the text.

@geekconnoisseur Месяц назад

Can the value be a local path to an image?

@mtm7031 Год назад

Wow

@OzFuntime2010 5 месяцев назад

can you use http: links in the data merger function

@tushycatt 10 месяцев назад

I followed the guide for making trading cards.. however whenever I have more than 1 row with details, all the others just copy the first?

@RyanTuscher 10 месяцев назад

What row does your information for the trading cards start? It should have a heading in row 1 and the information starting on row 2. If you’re still having a problem, I’d have to look into it.

@RyanTuscher 10 месяцев назад

Are you trying to data merge with multiple trading cards per page?

@chrisabaird 2 дня назад

Is it possible to create a data merge where the information goes into a text box on same page?

@RyanTuscher 2 дня назад

Can you explain this a little more? Do you want two rows on the same page or just more information from the same row?

@chrisabaird День назад

@@RyanTuscher think kind of like a classified ads section in a newspaper. A lot of items with various text, fonts, one right after the other, with equal spacing between them. Thanks

@RyanTuscher Год назад

How many 2023 resolutions do you still have going?