File Uploads

Use file uploads when the source data is not already sitting in a database and you want to start from spreadsheets or JSON exports.

Supported file types

You can mix and match multiple files in a single project:

• CSV (.csv)
• Excel (.xlsx, .xls)
• JSON (.json)

How it works

When you upload files, AnalytAI automatically:

1. analyzes the structure of the files
2. creates a table for each file
3. detects basic column types
4. makes the data available for setup, onboarding, and chat

Step-by-step guide

1. Create a file-based project

1. Start a new project for a file-based source.
2. Select the file upload option.
3. Choose the organization and give the project a clear name.

2. Upload the files

• drag and drop your files or click to browse
• upload multiple files together when they belong to the same project
• prefer clear header rows so the resulting tables are easier to understand

3. Validate and edit

• review the preview for each file
• rename the table if the default name is unclear
• fix any file errors and re-upload if needed

4. Finish setup

1. Click Upload to Database.
2. Wait for the upload and import to finish.
3. Continue into project setup or onboarding.

Best practices

• use clean header names instead of generic names like Col1
• keep date formats consistent across files
• structure JSON as an array of objects where possible

Troubleshooting

• File too large: large datasets are usually better handled through a SQL connector
• Unsupported format: password-protected spreadsheets may not import correctly
• Wrong data types: remove mixed values like text inside numeric columns before re-uploading

Return to SQL Connectors