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

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