Data Formatting Guidelines for camelAI Spreadsheets and CSVs

CamelAI does not perform data cleaning of your spreadsheet. When uploading Excel, Google Sheets, or CSV files to camelAI, follow these formatting guidelines to ensure accuracy of our AI chat agent.

Required Format

• Data must be structured as a standard table with column headers in the first row
• Each column must have a unique, descriptive header name
• Each row represents a single record

Common Mistakes

These are the most common issues we see:

• Rows with totals or sums mixed into the data
• Formulas in random cells
• Blank columns within the data range
• Notes in unused cells
• Grouping within tables
• Headers on the y-axis rather than the x-axis
• Blank rows within data
• Stray notes in cells

File Structure Requirements

Headers: Single header row at the top is required.

Format: Traditional tabular format only.

Prohibited Elements:

• No merged cells
• No grouped rows/columns
• No color-coding or visual formatting
• No embedded images or charts
• No hidden rows, columns, or sheets
• No stacked or multi-level headers

Multi-Sheet Support

Multiple sheets/tabs are supported. Each sheet must independently follow all requirements. Cross-sheet queries are supported.

Data Requirements

• Data must be clean with consistent formatting
• No empty rows or columns in the middle of data
• No stray special characters (quotation marks, apostrophes)

Technical Specifications

CamelAI uses DuckDB to process uploaded files. SQL queries run directly on your spreadsheet data. CamelAI does not perform automatic data cleaning.

Before Uploading Checklist

1. Ensure all sheets have clear column headers
2. Remove any special formatting
3. Use "Paste Values" to strip formatting when copying
4. Verify no empty rows or columns exist within data ranges

Ready to upload your data?

Try Free | Book Demo