🌟Export to TSV: Unleash Your Short.io Links in Spreadsheets 🚀¶
Introduction¶
The PyShortIO library provides a convenient export feature that allows you to export all your Short.io links to a TSV (Tab-Separated Values) file. This feature enables you to:
Create a local backup of your Short.io links
Analyze your links outside of the Short.io dashboard
Quickly locate specific links without logging in to Short.io
Share link information with team members
The export functionality retrieves all links from your Short.io domain and formats them into a structured TSV document that can be easily viewed and edited in spreadsheet applications.
Usage Example¶
Here’s a simple example of how to export all your Short.io links to a TSV file:
# -*- coding: utf-8 -*-
from pathlib import Path
from pyshortio.api import Client
# Initialize client with your API token
client = Client(token="your_api_token")
# Export all links for your domain to TSV format
hostname = "your-domain.short.gy"
tsv = client.export_to_tsv(hostname=hostname)
# Save the TSV content to a file
path_tsv = Path("export.tsv")
path_tsv.write_text(tsv)
Example output tsv:
export.tsv
1id short_url original_url title path tags folder_name allow_duplicates clicks_limit cloaking password password_contact redirect_type ttl expire_at expire_url utm_source utm_medium utm_campaign utm_term utm_content android_url iphone_url skip_qs archived split_url split_percent integration_adroll integration_fb integration_ga integration_gtm
2lnk_5Dae_nayDcNFuqm4UTzzRDoSXl https://pyshortio.short.gy/mB7vEW https://example.com/ mB7vEW false false false false
3lnk_5Dae_RBZId9QOpsUdMDbgNTjO6 https://pyshortio.short.gy/python-org https://www.python.org/ Python Org python-org python Python false false false false
4lnk_5Dae_MwpWboBw60IxFez3SJJfj https://pyshortio.short.gy/RYydyQ https://short.io/integrations/ Short io integrations RYydyQ integrations, short.io Short IO false false false false
5lnk_5Dae_Ex065BRA4RvQSsMtX0lMq https://pyshortio.short.gy/yIOj1m https://short.io/features/ Short io features yIOj1m features, short.io Short IO false false false false
6lnk_5Dae_MS9qthAgs513fxpQoGIDt https://pyshortio.short.gy/orat2q https://short.io/pricing/?utm_medium=reddit Short io pricing orat2q pricing, short.io Short IO false false reddit false false
7lnk_5Dae_vRTLKkQfLz1sGNCZxqzlJ https://pyshortio.short.gy/jDBsY6 https://short.io/pricing/?utm_medium=twitter Short io pricing jDBsY6 pricing, short.io Short IO false false twitter false false
8lnk_5Dae_Eaj0gpQbzjPeilEJhphaS https://pyshortio.short.gy/4ON4wH https://short.io/pricing/?utm_medium=linkedin Short io pricing 4ON4wH pricing, short.io Short IO false false linkedin false false
9lnk_5Dae_LODwquZ0IKm5OQ5DxFRMe https://pyshortio.short.gy/sq1Nwn https://short.io/pricing/ Short io pricing sq1Nwn pricing, short.io Short IO false false false false
Viewing and Editing Exported Links¶
After exporting your links, you can:
Open the TSV file in any text editor to view the raw data
Import the TSV file into Google Sheets by using “File > Import > Upload” and selecting “Tab-separated values”
Open the TSV file directly in Microsoft Excel
Use the data for analysis, reporting, or sharing with team members
The exported TSV file includes key information such as original URLs, shortened URLs, titles, paths, and tags, providing a read-only view that allows you to quickly locate the links you want to use without needing to log in to the Short.io dashboard.
Integration with Other Features¶
The export feature complements the existing sync functionality, allowing you to:
Export your current links
Make modifications in your spreadsheet application
Save as TSV
Use the 🌟Sync TSV: The Power Tool for URL Management at Scale 🚀 feature to apply your changes back to Short.io
This workflow provides a flexible way to manage your Short.io links using familiar spreadsheet tools.