Quick Start Guide
Get started with our AI-powered CSV Import API in minutes. Transform and validate your data with ease.
1. Get Your API Key
First, obtain your API key from the dashboard. You'll need this to authenticate your requests.
Authorization: Bearer your_api_key_here
2. Prepare Your CSV Data
Ensure your CSV file contains the data you want to process. The API will automatically clean and standardize your data.
Product Name,Units Sold,Price
Product A,100,29.99
Product B,50,19.99
3. Define Your Canonical Fields
Specify the target field names that your CSV columns should map to. These will be used to standardize your data structure.
X-Canonical-Fields: product_name,quantity_sold,unit_price
4. Send Your Request
Make a POST request to our API endpoint. You can either send raw CSV data or wrap it in JSON.
curl -X POST https://api.sheetsheep.com/csv-import \
-H "Authorization: Bearer your_api_key_here" \
-H "Content-Type: text/csv" \
-H "X-Canonical-Fields: product_name,quantity_sold,unit_price" \
-H "X-Return-Transformed: true" \
--data-binary @data.csv
5. Handle the Response
The API will return either a field mapping or the transformed CSV, depending on your request headers.
Field Mapping Response
{
"mappedFields": {
"Product Name": "product_name",
"Units Sold": "quantity_sold",
"Price": "unit_price"
}
}
Transformed CSV Response
product_name,quantity_sold,unit_price
Product A,100,29.99
Product B,50,19.99
Next Steps
- Learn about advanced API features
- Explore our code examples in different languages
- Read about rate limits and pricing
- Join our Discord community for support
Pro Tips
- Use raw CSV upload for better performance with large files
- Test with a small dataset first to verify your field mappings
- Set X-Return-Transformed: true to get the processed CSV directly
- Check our rate limits to ensure your usage stays within plan limits