Bulk Importing Links for Microsoft Excel
You can easily import thousands of links into Linkly.
Important - Read this first
If you are going to import more than a few URLs - let us help you.
Importing links is error prone and we can help you get it right first time.
Prepare a microsoft excel sheet of all the fields you want and send it to us using the chat widget in your workspace, and we’ll help you get it uploaded.
Microsoft Excel Import
If you need to set custom fields on your links (say, for example, if you want to use your own domain with the links), you can import a sheet instead.
Click here to download Microsoft Excel Sheet template.
Import Excel File in Linkly
Populate the excel sheet with the fields you require.
For custom domains, split the domain & slug apart, so for domain.com/mypage, domain.com goes in column domain, and /mypage goes in slug.
![Populate the excel sheet with the fields you require.]()
Populate the excel sheet with the fields you require.Export excel file as CSV Format.
Go to File tab -> Click Save As -> Select location -> Choose "CSV UTF-8 (Comma delimited)" from "Save as type" dropdown -> Click Save.
![Export excel file as CSV Format.]()
Export excel file as CSV Format.Once done, in Linkly, go to Integrations -> Bulk Import:
Select the Excel file and upload it. Linkly will generate links for valid rows.
![Once done, in Linkly, go to Integrations -> Bulk Import:]()
Once done, in Linkly, go to Integrations -> Bulk Import:Now click Start Import to import links.
![Now click Start Import to import links.]()
Now click Start Import to import links.Links have been imported.
![Links have been imported.]()
Links have been imported.
Importing Rules - Rotator, Geotargeting & Device Targeting
There are four columns at the end of the import template used for importing rules.
- rule_what - rule type, should all be one of 'platform', 'country' or 'rotator' for a given link.
- rule_matches - e.g. android,ios,windows,mac,linux GB,US,CA
- rule_url - appropriate destination URL for the rule
- rule_percentage - comma separated list of integer percentages for rotators, e.g. 25,25,50.
Each field is a comma-separated list.
Rotators Example
| rule_what | rule_matches | rule_url | rule_percentage |
|---|---|---|---|
| rotator,rotator | leave field blank | https://nature.com,https://science.com | 50,50 |
| rule_what | rule_matches | rule_url | rule_percentage |
|---|---|---|---|
| country,country | GB,US | https://gov.uk,https://whitehouse.gov | leave field blank |
| rule_what | rule_matches | rule_url | rule_percentage |
|---|---|---|---|
| device,device | android,ios | https://play.google.com,https://apple.com | leave field blank |
