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.
Download the Excel import template.
How to Import an Excel File into Linkly
Populate the Excel sheet with the fields you require.
For custom domains, split the domain and slug apart. For example, for domain.com/mypage, put domain.com in the domain column and /mypage in the slug column.
Export the Excel file as CSV format.
Go to File → Save As, select a location, choose CSV UTF-8 (Comma delimited) from the Save as type dropdown, then click Save.
In Linkly, go to Integrations → Bulk Import.
Select the CSV file and upload it.
Click Start Import to import your links.
Linkly will generate links for valid rows.
Verify your imported links.
Check that all your links have been created correctly.
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 be one of
platform,country, orrotatorfor a given link. - rule_matches — e.g.
android,ios,windows,mac,linuxfor platforms orGB,US,CAfor countries. - 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 blank) | https://nature.com,https://science.com | 50,50 |
Geotargeting Example
| rule_what | rule_matches | rule_url | rule_percentage |
|---|---|---|---|
| country,country | GB,US | https://gov.uk,https://whitehouse.gov | (leave blank) |
Device Targeting Example
| rule_what | rule_matches | rule_url | rule_percentage |
|---|---|---|---|
| platform,platform | android,ios | https://play.google.com,https://apple.com | (leave blank) |
Frequently Asked Questions
I uploaded a CSV file, but nothing imported!
Linkly only creates links where the rows are valid. If Linkly isn't importing, just let us know and we'll check it for you.
Why should I use CSV UTF-8 format?
Excel's default CSV format may not handle special characters correctly. Using CSV UTF-8 (Comma delimited) ensures proper encoding for international characters and URLs.
Can I auto-generate slugs on my domain?
Yes, just leave the slug field blank and they'll be auto-generated.
Why aren't my slugs working?
Check that your slugs start with /, so they should look like /offer. Invalid slugs will receive an auto-generated slug.