How to Bulk Import Links into Your Flipbook

With our bulk link import feature, you can easily import hundreds of links at once into your flipbook using an .xls file. You can add either external links or product links, helping you save precious time and effort! 

As this feature requires a lot of technical knowledge, please have a technical member of your team assist you when setting up this feature.

Firstly, it is important that you download and view our .xls example template. The .xls file you upload must match our example template exactly (in terms of formatting and data input) for the upload to work. See Requirements when filling out your .xls template for bulk link import below.

Secondly, download the blank .xls template and add your relevant data.

• You must fill in the SearchText column. This is the only column that requires data for the feature to work. SearchText refers to the data that we will search for within your flipbook in order to add the relevant link. SearchText must be unique and must exactly match the text in your flipbook for us to accurately place your link (including spaces and special characters).
• Example: The product name in your flipbook is Porcelain Mug 21. Your SearchText in your .xls file must be Porcelain Mug 21.  If you have a product number instead of a product name, it is preferable to use that instead. It is easier for our system to search for definitive numbers rather than names / characters.
• SearchText should only be entered once. Even if the SearchText is displayed numerous times within your flipbook, it should only display once in your .xls document. There should not be two (or more) rows with the same SearchText. If there are two or more rows with the same SearchText in your .xls file, the links will not be imported.
• Mouseover text refers to the text that will display when your viewer hovers their mouse over your inserted link. 
• External Links must include the full web address, starting with https://… 
• Product Links must not include a currency symbol in the pricing column - only the number with a comma as a decimal point (ex. 99,95). You may select your currency option within the Shopping Cart feature.
• You do not need to fill in every column (only SearchText is required). 
• There cannot be any empty rows in the .xls file - our system will stop searching as soon as it recognizes a break in data.

Choose which icon should display beside your bulk links, which size the icons should be, which colour the icons should be, and the location of the icons in relation to the SearchText. 

You can also choose not to display an icon (None)  and the link will be inserted directly over your SearchText.

Finally, you can choose if you want your links to have a border around them when views on a mobile/tablet, to make it easier for them to find.

Once your .xls file has been successfully uploaded, Paperturn will give you an overview of where your links have been inserted. 

If you are satisfied with your results, click the blue Save button and your bulk links will be added. It can take up to 5 minutes for the links to populate and activate within your flipbook.

Note: This is a technically complicated feature. Links may not, in some circumstances, transfer perfectly when we convert your PDF to a flipbook. In this case, you can use Paperturn’s editor to manually add any missing links and adjust the placement of those links that have not transferred perfectly.