Skip to main content
Upload one or more CSV files to create a data layer with AstroBee. Each CSV becomes a source table that you can query and analyze using natural language.

​
Uploading CSVs

1

Create new data layer

Click the dropdown in the top left corner and select ” Create Data Layer”
2

Select Upload card and add CSV files

Click the “Upload” card, name your data layer, then drag and drop your CSV files or click “Browse” to select them
CSV upload interface with file selection
  • Supports CSV files up to 100MB each
  • Upload multiple CSVs - each becomes a separate source table
  • Remove accidentally uploaded files using the delete button
3

Data Layer preview

AstroBee analyzes your CSV structure and suggests the entities AstroBee will use to generate the data layer and organize your data. Click “Generate Data Layer” to begin the data layer generation process.
CSV Data Layer Preview
4

Generate data layer

After selecting datasets, AstroBee will start building your data layer. This may take a few seconds to minutes depending on your data size.
Success screen after ontology creation

​
Viewing source data

For CSV data, the Sources page shows:
  • Search bar - Find specific data sources quickly
  • Data source list - All raw tables from your connected systems
  • Add Data button - Connect new data sources (coming soon)
Click any data source to see its actual content. For example, clicking “HubSpot Contacts” shows the company records with columns like HS CONTACT ID, LIFECYCLE STAGE, INDUSTRY, and COMPANY SIZE.
Raw data table showing company information
Each data view includes:
  • Column headers with data types (Text, Integer, Timestamp, etc.)
  • Actual data from your source system
  • Download CSV option for further analysis
  • Row count upto 200 rows. To view the full data, please download as CSV

​
Adding new data

Click the button to see options for connecting additional data sources:
Add Data modal showing current limitations
Currently, adding new data creates a new data layer. In the future, you’ll be able to add data sources to existing data layers. Until this feature is available, you can create a new data layer with additional data included.

​
What happens next

Once uploaded, you can explore your data layer. You can then: Refine your data layer - Use AstroBee to edit and improve your business model with natural language requests Ask questions immediately - Query your raw data using natural language View raw data anytime - Visit the Sources page to see your original CSV data behind the data layer
Sources view showing uploaded CSV tables

​
Troubleshooting

If you encounter errors during CSV upload, here are common issues and solutions:
Issue: Quote characters (”) within your data aren’t properly escaped or closed.
CSV parsing error message

Example error message of malformed quoted field

Solution:
  • Ensure quoted fields are properly closed with matching quotes
  • Escape quotes within text by doubling them ("") or using a different quote character
  • Check that your CSV follows consistent quoting rules
Issue: A quoted field starts with a quote but never closes it.Solution:
  • Find the row mentioned in the error and ensure all quoted fields have closing quotes
  • Remove line breaks within quoted fields or properly escape them
  • Check for stray quote characters in your data
Issue: Rows have inconsistent numbers of columns compared to the header row.
CSV parsing error for too many or too few fields

Example error message of inconsistent field count

Solution:
  • Ensure all rows have the same number of columns as your header
  • Check for extra commas or missing commas in the data
  • Remove or fill empty columns to maintain consistent structure
  • Look for line breaks within data fields that might split a single row
Issue: The parser cannot automatically determine what character separates your columns (comma, semicolon, tab, etc.).Solution:
  • Ensure your CSV uses standard comma separators (,)
  • If using semicolons or tabs, convert to comma-separated format
  • Check that delimiter usage is consistent throughout the file
  • Avoid mixing different separators in the same file
Issue: CSV file appears to be empty or contains only headers with no actual data.
CSV parsing error for empty file

Example error message for empty CSV file

Solution:
  • Ensure your CSV file contains actual data rows below the header row
  • Check that the file wasn’t corrupted during export or transfer
  • Verify the file has content beyond just column headers
  • If exporting from another system, make sure to include the actual data records
Issue: CSV files larger than 100MB or in unsupported formats.Solution:
  • Split large files into smaller chunks under 100MB each
  • Ensure your file has a .csv extension
  • Save Excel files as CSV format before uploading
  • Use UTF-8 encoding for files with special characters

​
Next steps

Ask Questions

Start querying your CSV data with natural language

Refine Your Data Layer

Improve how AstroBee understands your business model