Bulk Importing Links with Google Sheets
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 spreadsheet 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.
Spreadsheet 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 spreadsheet instead.
How to Import Links from a Spreadsheet
Open the Google Sheets import template.
Populate the spreadsheet 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.
Click File → Download → Comma-Separated Values (.csv).
In Linkly, go to Integrations → Bulk Import.
Select the CSV file and upload it.
Linkly will generate links for valid rows.
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.
Can I use Excel?
Yes, but cautiously. Excel exports CSV files slightly differently from Google Sheets. If you're having trouble, try using Google Sheets.
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.