Data Import and Ingestion
Getting data into Claro is a flexible and straightforward process. Choose the method that best fits your source and volume.
Method 1: Bulk Add (Best for: Quick lists and manual data)
When to use: You have a list of items from another document, website, or need to add data manually.
How it works:
- Copy your list from anywhere (spreadsheet, web page, document)
- Paste directly into your Claro table
- Claro automatically splits items by lines or delimiters
💡 Pro Tips:
- Works with any delimiter (commas, tabs, new lines)
- Copy entire columns from web tables—Claro handles the formatting
- Perfect for product URLs, SKU lists, or contact information
✅ Great for:
- Product URLs scraped from category pages
- LinkedIn profile links from research
- SKU lists from inventory systems
⚠️ Not ideal for:
- Large datasets (>1,000 rows) → Use CSV import
- Frequently changing data → Use API integration
Method 2: CSV/XML Import (Best for: Structured data files)
When to use: You have existing spreadsheets, database exports, or structured data files.
How it works:
- Upload your file (CSV, XML, Excel supported)
- Map columns to match your table structure
- Preview the import to verify formatting
- Import and start enriching
File Limits:
- Maximum 1,000 rows per file
- Upload multiple files to the same table
- Larger files: split into chunks or use the API
💡 Pro Tips:
- Ensure column headers are clean and consistent
- Test with a small sample first
- Date columns should match your target format
✅ Great for:
- Migrating legacy product catalogs
- Daily inventory exports
- Customer database dumps
- Supplier information files
⚠️ Not ideal for:
- Files with inconsistent headers (clean first)
- Multi-gigabyte files (split or use API)
- Real-time data feeds
Method 3: Geolocation Search (Best for: Location-based data)
When to use: You need businesses, points of interest, or location data around specific areas.
How it works:
- Enter a starting address
- Set your search radius (km or miles)
- Claro returns up to 5,000 POIs with coordinates and metadata
💡 Pro Tips:
- Use a smaller radius in dense areas to avoid hitting limits
- Chain with Classification to tag urban vs. rural locations
- Combine with Web Enrichment for hours, ratings, and contact info
✅ Great for:
- Building store locator datasets
- Finding competitors in target markets
- Enriching customer addresses with nearby amenities
- Market research for retail expansion
⚠️ Not ideal for:
- P.O. boxes or vague addresses
- Areas with poor mapping coverage
- Highly specific business types
Coming Soon: General Search
Web-based entity discovery using plain keywords. Enter terms like “Antler Startup based in Berlin” or “sustainable fashion brands” to discover relevant entities for further enrichment.