Data Exports
Export data from Tether to use in spreadsheets, reports, and other tools.Why Export Data?
| Use Case | Description |
|---|---|
| Reporting | Create custom reports |
| Analysis | Analyze in Excel or other tools |
| Sharing | Share with stakeholders |
| Backup | Keep local copies |
| Integration | Use in other systems |
Export Formats
| Format | Best For |
|---|---|
| CSV | Spreadsheets, data import |
| Excel (.xlsx) | Formatted reports, analysis |
| Sharing, printing |
Exporting from Different Areas
SKU Export
Available fields:
- SKU code and name
- Collection
- Status
- Dimensions
- Custom fields
Inventory Export
Available fields:
- SKU information
- Warehouse
- Quantity by state (on hand, available, etc.)
- Health status
- Coverage days
Forecast Export
Available fields:
- SKU/channel
- Period dates
- Forecast quantities
- Actual quantities (historical)
- Adjustments
Transaction Export
Available fields:
- Transaction ID and name
- Type and status
- Source and destination
- Line items
- Dates and amounts
Sales History Export
Available fields:
- Date
- SKU
- Channel
- Quantity
- Revenue (if tracked)
Export Options
Scope Options
| Option | Description |
|---|---|
| Selected | Only selected rows |
| Filtered | All visible (filtered) rows |
| All | All data (ignore filters) |
Field Selection
Some exports allow choosing fields:Date Format Options
| Format | Example |
|---|---|
| ISO | 2024-01-15 |
| US | 01/15/2024 |
| EU | 15/01/2024 |
| Text | January 15, 2024 |
Large Exports
Handling Large Data Sets
For large exports:| Size | Approach |
|---|---|
| < 10,000 rows | Direct download |
| 10,000 - 100,000 | May take longer |
| > 100,000 | Consider filtering |
Tips for Large Exports
- Filter first - Export only what you need
- Choose CSV - Faster than Excel for large files
- Wait for completion - Don’t navigate away
- Check file - Verify all data exported
Scheduled Exports
Setting Up Automated Exports
If available, configure scheduled exports:Schedule Options
| Frequency | Use Case |
|---|---|
| Daily | Regular monitoring |
| Weekly | Weekly reports |
| Monthly | Period-end reporting |
Working with Exported Data
In Excel
| Task | How |
|---|---|
| Open CSV | File → Open, select CSV |
| Refresh Data | Re-export and replace |
| Create Pivot | Insert → PivotTable |
| Charts | Select data, Insert → Chart |
In Google Sheets
| Task | How |
|---|---|
| Import | File → Import → Upload |
| Query | Use QUERY function |
| Share | Click Share button |
In Other Tools
| Tool | Import Method |
|---|---|
| Tableau | Connect to CSV/Excel |
| Power BI | Get Data → File |
| Python/Pandas | pd.read_csv() |
Best Practices
Export What You Need
Export What You Need
Be selective with exports:
- Filter before exporting
- Choose relevant fields
- Smaller files are easier to work with
Document Your Exports
Document Your Exports
Keep track of exports:
- Note when exported
- Record filters used
- Save with meaningful names
Regular Backups
Regular Backups
Export key data regularly:
- Weekly or monthly
- Before major changes
- Store securely
Verify Accuracy
Verify Accuracy
Check exported data:
- Row counts match
- Sample data correct
- No truncation
Troubleshooting
Export Failed
Possible causes:- Too much data
- Network timeout
- Browser issue
- Try smaller export
- Use CSV instead of Excel
- Try different browser
- Check network connection
Missing Data in Export
Possible causes:- Filters excluding data
- Field not selected
- Permission restrictions
- Check active filters
- Verify field selection
- Confirm you have access
File Won’t Open
Possible causes:- Large file size
- Corrupted download
- Wrong application
- Re-download file
- Try different application
- Open as text to check format