• AffProfAffProf
  • Home
  • Dashboard
  • Products
  • Links
  • Tags
Account
  • Profile
  • Settings
  • Billing
  • Help Center
  • Contact & Feedback
  1. Home
  3. Help Center
  5. Import & export links
Back to Help Center

Import & export links

Move link data in and out of AffProf using CSV files. This is useful for migrations, bulk updates, UTM changes, backups, and reports.

Bulk CSV import is a Pro feature. Export is available on all plans, including Free.
  • Migrating from another shortener or spreadsheet.
  • Updating destination URLs across many links at once.
  • Adding UTM parameters to a batch of existing links.
  • Backing up your link library before major changes.
  • Sharing your link list with a teammate or in a report.
In this guide
Export your linksEdit and re-uploadImport basicsCSV columnsPreview and errorsConfirm importHow updates workClean import tipsLimitationsCommon questions
Export your links
Export downloads every link in your account into the same CSV format that import accepts.
  1. 1Go to Links.
  2. 2Click Export CSV in the top toolbar.
  3. 3The file downloads immediately to your computer.

The export contains these columns: product, link, slug, platform, fallback_url, utm_source, utm_medium, utm_campaign, utm_content, utm_term, is_enabled, notes, tags.

  • Includes all links regardless of status: active, broken, or disabled.
  • Includes metadata such as UTMs, fallbacks, notes, and tags.
  • Tags are joined with |, the same format import uses.
Export does not include click analytics, health check history, or per-link brand assignments. For full analytics export, contact hello@affprof.com.
The export -> edit -> re-upload workflow
This is the fastest way to make bulk changes once you have a few dozen links.
  • Update 50 destination URLs after an affiliate program rotates URLs.
  • Add utm_source=newsletter to email campaign links.
  • Rename a tag across many links at once.
  • Disable seasonal links after a promotion ends.
  1. 1Export your full link list to CSV.
  2. 2Open the CSV in Excel, Google Sheets, Numbers, or another spreadsheet app.
  3. 3Make your changes with find/replace, sorting, filtering, or direct cell edits.
  4. 4Save as CSV. Do not change to XLSX or another format.
  5. 5Re-upload via Links -> Import CSV.
  6. 6AffProf updates existing links by matching the slug column.
Important: the match is by slug. If you change a slug in the CSV, AffProf treats it as a new link instead of updating the existing one.
Import: starting fresh or migrating
Use import when you want to add bulk content to AffProf.
  1. 1Go to Links and click Import CSV in the top toolbar.
  2. 2Drag a CSV into the dropzone or browse for one on your computer.
  3. 3If this is your first import, click Download template.
  4. 4Use the Fields & example tab to see every accepted column.
import-link-step1.png
import-link-step2-fields-example.png
CSV columns
Four columns are required. Optional columns enrich the imported links.
Required columns
product
Product name. Created automatically if missing.
Blue Yeti Microphone
link
The destination affiliate URL.
https://www.amazon.com/dp/B002VA464S
slug
Short link slug. Lowercase letters, numbers, and hyphens only.
blue-yeti-amazon
platform
Affiliate network or marketplace.
amazon
Optional columns
fallback_url
Backup destination if the link breaks.
https://yourbrand.com/backup
utm_source
UTM source parameter.
instagram
utm_medium
UTM medium parameter.
bio
utm_campaign
UTM campaign parameter.
spring-launch
utm_content
UTM content parameter.
hero-button
utm_term
UTM term parameter.
creator-tools
is_enabled
Accepts true/false, yes/no, or 1/0.
true
notes
Internal note, only visible to you.
Best performer in Instagram bio
tags
Pipe-separated tag names. Max 10 per link.
amazon|tech|review
product,link,slug,platform
Blue Yeti Microphone,https://www.amazon.com/dp/B002VA464S,blue-yeti-amazon,amazon
Kindle Paperwhite,https://www.amazon.com/dp/B0CFPHTMDX,kindle-paperwhite-amazon,amazon
Notion,https://affiliate.notion.so/abc123,notion-affiliate,notion
Upload, preview, and fix issues
AffProf previews valid rows and shows exactly what needs fixing.
import-link-step3.png
  • You see the total number of valid rows ready to import.
  • A preview table shows the first rows for spot-checking.
  • Row numbers match the original CSV.
  • Use Replace if the file looks wrong.
import-link-step4-if-there-are-errors.png
  • Invalid URL: must start with http:// or https://.
  • Invalid slug: only lowercase letters, numbers, and hyphens.
  • Missing required field: product, link, slug, or platform is empty.
  • Slug conflict: slug already exists or appears twice in the CSV.
  • Slug too long: max 100 characters.
You can import valid rows now and fix the rest later, or fix everything first and click Replace to upload the corrected CSV.
Confirm import
When all rows look good, click **Import links**.
import-link-step5.png

AffProf processes the batch and shows how many links were created or updated. Close the dialog and your links appear immediately in the Links table.

How updates work

For each CSV row, AffProf checks whether a link with that slug already exists in your account.

  • If yes, AffProf updates that link with the new CSV values. Everything except the slug itself can change.
  • If no, AffProf creates a new link.
  • The slug is the identity of a link. To rename a slug safely, export, change the slug, import as a new link, then delete the old one.
Tips for clean imports
  • Keep your CSV in UTF-8.
  • Quote fields with commas, for example "Notion, the all-in-one workspace".
  • Start directly with column names: product,link,slug,....
  • Test with 5-10 rows before importing hundreds.
  • Use pipe for tags, not commas: amazon|tech|review.
  • Save as CSV, not XLSX.
Limitations
  • Maximum 10 tags per link. Extra tags are ignored.
  • Slugs must be unique within your account.
  • AffProf supports CSV format. If your file is XLSX or ODS, export it to CSV first using your spreadsheet app.
  • Per-link brand assignments are not included in import/export.

Common questions

If I delete a link, will it come back if I re-upload my old CSV?

Yes. Import creates new links for any slug not currently in your account, with no previous analytics history.

Can I delete links via CSV?

No. Deletion must be done through the UI for safety. CSV import only creates and updates.

What happens if I change the slug in my CSV?

AffProf treats it as a new link. The old link with the old slug stays unchanged.

Can I use export to back up links before a big change?

Yes. Export before bulk changes so you can restore most fields later if needed.

Why does export not include analytics?

Click data is large and changes often. Use Dashboard or per-link analytics for current analytics.

Can I schedule recurring exports?

Not currently. Each export is manual. Tell us at hello@affprof.com if scheduled exports matter to your workflow.

Need help with a specific CSV?

Email hello@affprof.com with your file attached and a description of what you are trying to do. We respond within 24 hours, faster for Pro users.