JLFreeman.Eric Posted August 19, 2019 Share Posted August 19, 2019 (edited) Hello, We are looking for an application to create our product catalog, but the data source will be an Excel file. Can Affinity Publisher use the "Import data into a template" to create a product catalog, as we can do in Microsoft Publisher? Thank you for your help, Eric Edited August 19, 2019 by JLFreeman.Eric Quote Link to comment Share on other sites More sharing options...
Staff stokerg Posted August 20, 2019 Staff Share Posted August 20, 2019 Hi JLFreeman.Eric and Welcome to the Forums, Affinity Publisher doesn't currently have the ability to import Excel data and flow it to template. You can copy and paste Excel data into tables in Publisher but we don't currently have an automatic data merge function. Data merge will be coming at a later date jezekjan and JLFreeman.Eric 2 Quote Link to comment Share on other sites More sharing options...
rhyswoos Posted November 5, 2019 Share Posted November 5, 2019 is there any progress updates on a Data Flow / Data Merge tool for Publisher ? jezekjan 1 Quote Link to comment Share on other sites More sharing options...
Tone Camara Posted April 23, 2020 Share Posted April 23, 2020 @stokerg So any way to design a product catalog with lots of products doing data merge out of Publisher? Maybe using word, excel or other alternatives and then import the data into Publisher I've just bought Publisher thinking I could do data merge I have to design a catalogue with 5000 items (I can get a excel with description, codes, prices...), and images are provided through the public web URL of the company How would you do the process? Thanks Tone Quote Link to comment Share on other sites More sharing options...
JLFreeman.Eric Posted April 23, 2020 Author Share Posted April 23, 2020 (edited) Documentation to create a catalog (Excel to publisher merge) : Create a catalog merge / Créer une fusion de catalogue EN : https://support.office.com/en-us/article/create-a-catalog-merge-42d37310-fcad-493f-8102-7c8ef3862eb2 FR : https://support.office.com/fr-fr/article/créer-une-fusion-de-catalogue-42d37310-fcad-493f-8102-7c8ef3862eb2?ui=fr-FR&rs=fr-FR&ad=FR If you have multiple Categories, you can creat multiple PDF and merge all PDF together. Best regards, Eric. Edited April 23, 2020 by JLFreeman.Eric Quote Link to comment Share on other sites More sharing options...
Tone Camara Posted April 23, 2020 Share Posted April 23, 2020 12 minutes ago, JLFreeman.Eric said: Documentation to create a catalog (Excel to publisher merge) : Create a catalog merge / Créer une fusion de catalogue EN : https://support.office.com/en-us/article/create-a-catalog-merge-42d37310-fcad-493f-8102-7c8ef3862eb2 FR : https://support.office.com/fr-fr/article/créer-une-fusion-de-catalogue-42d37310-fcad-493f-8102-7c8ef3862eb2?ui=fr-FR&rs=fr-FR&ad=FR Best regards, Eric. So I was wrong buying Affinity I did must go for Microsoft It would be possible to do it with Filemaker? Quote Link to comment Share on other sites More sharing options...
Stanislav Briza Posted October 29, 2021 Share Posted October 29, 2021 Hi there, is there any update on this topic? I need to write a technical reports with numerous tables. I natively use libre office calc and I would like to link them with affinity and be able to have them automatically updated. Quote Link to comment Share on other sites More sharing options...
thomaso Posted October 29, 2021 Share Posted October 29, 2021 2 hours ago, Stanislav Briza said: is there any update on this topic? Yes, meanwhile APub has a Data Merge feature: (but there is no "automatic update" to external text content) Serif Article about APub's Data Merge:https://affinityspotlight.com/article/populate-pages-in-an-instant-with-affinity-publishers-powerful-data-merge-manager/ Data Merge in the Affinity Online Help:https://affinity.help/publisher/en-US.lproj/index.html?page=pages/Advanced/dataMerge.html?title=Data merge Video intro (8 min):https://www.youtube.com/watch?v=TTUSPWkiIDk Video detailed (2 hours):https://www.youtube.com/watch?v=wav8wuucZUY Quote macOS 10.14.6 | MacBookPro Retina 15" | Eizo 27" | Affinity V1 Link to comment Share on other sites More sharing options...
RatWolf6 Posted January 13, 2022 Share Posted January 13, 2022 Will be there an option in the Future to update the tables, so you don't must import all tables again and format then? For me, there will be hundreds of tables. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
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.