Export CSV history to CSV file, generate reports, and analyze import patterns.
Export Overview
CSV History provides export functionality for detailed analysis:
- Summary Export: Export list of all import logs
- Detailed Export: Export detailed data from individual import logs
- Error Export: Export error details for failed imports
- Import Data Export: Export successfully imported items
- CSV Format: All exports in CSV format for spreadsheet analysis
Summary Export
Export list of all import logs:
- Table Export: Export the visible table of import logs to CSV
- Filtered Results: Export respects active filters (status, search, etc.)
- Columns Included: Filename, Type, Status, Success Count, Error Count, Date
- All Pages: May export all pages or just current page (check export options)
- Use Case: Generate reports on import activity over time
Detailed Export (Per Import)
Export detailed data for a specific import:
- Click the expand icon on the import log row you want to export
- Wait for detailed data to load
- Review the summary showing total processed, imported, and errors
- Use "Export Imported Items" button to export successful imports
- Use "Export Error Details" button to export error information
- CSV files download automatically with descriptive filenames
Exporting Imported Items
Export successfully imported items:
- Button Location: "Export Imported Items" button in expanded log details
- Data Included: All rows that were successfully imported
- Original Format: Exported data maintains original CSV structure
- All Columns: Includes all columns from original CSV file
- Filename Format: Downloads as filename_imported.csv (replaces filename with actual filename)
- Use Case: Verify what was actually imported, re-import specific items, backup successful imports
Exporting Error Details
Export detailed error information:
- Button Location: "Export Error Details" button in expanded log details
- Row Number First: CSV includes row number at the beginning for easy identification
- Original Data: Includes all original CSV data for failed rows
- Error Column: Error message added as last column
- Filename Format: Downloads as filename_errors.csv (replaces filename with actual filename)
- Use Case: Fix errors in spreadsheet, re-upload corrected file
- Error Analysis: Analyze error patterns to improve CSV format
Analyzing Exports
Use exported data for:
- Import Reports: Generate reports on import activity, success rates, trends
- Error Analysis: Identify common error patterns to improve CSV files
- Data Verification: Verify what was actually imported vs. what was intended
- Backup Records: Keep CSV backups of important imports
- Re-import Preparation: Export successful items to re-import into different account
- Compliance: Maintain records for audit or compliance purposes
- Pattern Recognition: Analyze import patterns to optimize workflow
Export Tips
Best practices for exporting:
- Filter First: Apply filters before exporting to get relevant data
- Error Review: Export error details before fixing CSV file
- Regular Exports: Export important imports regularly for backup
- Naming: Rename exported files with descriptive names for easier organization
- Archive: Keep archived copies of important imports
- Analysis Tools: Use Excel pivot tables or Sheets for advanced analysis
Tip: When fixing import errors, export error details first. Open in Excel, fix the errors in the CSV, then upload the corrected file. This workflow is more reliable than trying to fix errors manually in the interface.