Importing and Exporting
Learn how to move data in and out of Raycaster AI Workspace
Moving Data Into and Out of Raycaster
Raycaster provides powerful tools for importing external data into your workspace and exporting your enriched data for use in other systems, making it easy to integrate with your existing workflows.
Importing Data
CSV Import
The most common way to bring data into Raycaster is through CSV (Comma-Separated Values) files:
Access Import Function
Open the sheet where you want to import data and click the “Import” button in the toolbar
Upload CSV
Upload File: Click “Select File” to select a CSV file from your device Choose if duplicate rows should be removed
Map Columns
In the column mapping screen:
- Match columns from your CSV to columns in your sheet
- Use the dropdowns to select the appropriate destination column
- Use “Skip Column” for data you don’t want to import in the drop down
- Add new columns if needed from the drop down
Review and Confirm
Check the preview of how your data will be imported
- Verify column mappings are correct
- Ensure data appears as expected
- Check for any errors or warnings
Start Import
Click “Import Data” to begin the process
- A progress indicator will show the status
- When complete, you’ll see a summary of rows imported
CSV File Requirements
For best results, ensure your CSV files meet these requirements:
- The first row must contain column headers
- For Company sheets: Include domain or URL in standard format (e.g., “company.com” or “company.org”)
- For People sheets: Include LinkedIn URLs in standard format (“linkedin.com/in/username”)
- Use UTF-8 encoding to support special characters
- Avoid merged cells, formulas, or other spreadsheet-specific features
Enrichment processes run in the background, so you can continue working with your data while research completes. New information will appear as it becomes available.
Import Troubleshooting
If you encounter issues during import:
Problem | Solution |
---|---|
Missing required columns | Ensure your CSV includes all columns marked as required in the mapping phase |
Data format issues | Check that dates, numbers, and other special formats match what Raycaster expects |
Import fails or times out | Try breaking larger files into smaller batches for import |
Column mapping confusion | Use the preview feature to verify mappings before confirming the import |
Character encoding problems | Save your CSV with UTF-8 encoding before importing |
Exporting Data
CSV Export
The standard way to export data from Raycaster:
Access Export Function
Click the “Export” button in the toolbar of the sheet you want to export
Start Export
Click “Export” to generate and download the file
- Large exports may take a few moments to prepare
- Your browser will automatically download the file when ready
Exporting Selected Rows
To export a specific subset of data:
- Use filters to show only the data you want to export
- Click “Export” to download only the selected data
Handling Large Datasets
Raycaster is optimized for handling large amounts of data:
Import Strategies for Large Files
For very large datasets (thousands of rows):
- Split into batches: Import 500-1000 rows at a time for better performance
- Staged enrichment: Import all data first, then run research in batches
- Prioritize columns: Select only the most important columns for initial research
Export Strategies for Large Files
When exporting large datasets:
- Filter before export: Narrow down to just the data you need
- Select essential columns: Export only the columns you require
- Consider summary-only exports: Skip detailed research data if not needed
- Use the background export option: For very large exports (automatic for large sheets)
Data Integration Best Practices
Preparing Data for Import
Before importing data:
- Clean your spreadsheet by removing duplicate entries
- Standardize formats (dates, numbers, URLs, etc.)
- Split complex columns into simpler ones if needed
- Ensure company domains and LinkedIn URLs follow standard formats
- Create a backup of your original data
Workflow Integration
Integrate Raycaster with your existing workflows:
- CRM Integration: Export enriched data for import into your CRM system
- Regular Updates: Schedule routine imports to keep data fresh
- Collaborative Analysis: Share exports with team members who don’t have Raycaster access
- Data Verification Loop: Export, verify with stakeholders, then re-import corrections
For enterprise customers, Raycaster offers additional integration options including API access and automated workflows. Contact enterprise@raycaster.ai to learn more.