> ## Documentation Index
> Fetch the complete documentation index at: https://bavlio.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Preview CSV or Excel file before upload

> Upload a CSV or Excel file to preview its structure, columns, and sample data



## OpenAPI

````yaml https://api.bavlio.com/openapi.json post /api/v1/upload/preview
openapi: 3.1.0
info:
  title: Bavlio API
  description: >-
    Outreach automation API — lead enrichment, email campaigns, LinkedIn
    automation, and AI agent. Full docs at https://docs.bavlio.com.
  version: 1.0.0
servers: []
security: []
tags:
  - name: API Keys
    description: >-
      Create, list, and revoke API keys for programmatic access. JWT
      authentication required.
  - name: credits
    description: Credit balance, cost estimates, and transaction history.
  - name: campaigns
    description: Create, manage, launch, and monitor email campaigns.
  - name: campaign-personalization
    description: AI-powered email subject and body personalization for campaigns.
  - name: email-finder
    description: Find and verify email addresses for prospects.
  - name: email-verification
    description: Validate email addresses and prune invalid entries from datasets.
  - name: sender-profiles
    description: Manage sender identity profiles for outreach.
  - name: sender-profile-chat
    description: Interactive chat for building sender profiles.
  - name: templates
    description: Email template CRUD.
  - name: suppression
    description: Do-not-contact suppression list management.
  - name: datasets
    description: Lead dataset listing, download, and updates.
  - name: user-extractions
    description: Uploaded lead file management and processing.
  - name: enrichment-chat
    description: Interactive chat for data enrichment sessions.
  - name: enrichment-processing
    description: Batch lead enrichment processing.
  - name: File Upload (CSV/Excel)
    description: Upload and preview CSV/Excel lead files.
  - name: connected-accounts
    description: LinkedIn account connections via Unipile.
  - name: linkedin-content
    description: LinkedIn post creation, scheduling, and management.
  - name: linkedin-playground
    description: Direct LinkedIn actions (profile lookup, messaging, engagement).
  - name: bavimail-proxy
    description: BaviMail domain, alias, and email management.
  - name: agent
    description: Bavi AI agent chat with SSE streaming.
  - name: notifications
    description: Notification preferences and delivery.
  - name: referral
    description: Referral code management and stats.
  - name: feedback
    description: User feedback submission.
  - name: authentication
    description: JWT token verification and user info.
  - name: Google OAuth
    description: Google OAuth login flow and access tokens.
  - name: Google Sheets OAuth
    description: Google Sheets import and access management.
  - name: stripe
    description: Stripe checkout, billing portal, and subscription status. JWT only.
  - name: users
    description: User quota and usage information.
  - name: Health
    description: Health checks and system status.
  - name: Personalization
    description: Core lead personalization engine.
  - name: Session Management
    description: Enrichment session lifecycle.
  - name: Session Processing
    description: Session data processing.
  - name: webhooks
    description: Inbound webhook handlers (Stripe, BaviMail, Unipile).
paths:
  /api/v1/upload/preview:
    post:
      tags:
        - File Upload (CSV/Excel)
      summary: Preview CSV or Excel file before upload
      description: >-
        Upload a CSV or Excel file to preview its structure, columns, and sample
        data
      operationId: preview_file_api_v1_upload_preview_post
      requestBody:
        content:
          multipart/form-data:
            schema:
              $ref: >-
                #/components/schemas/Body_preview_file_api_v1_upload_preview_post
        required: true
      responses:
        '200':
          description: Successful Response
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/UnifiedPreviewResponse'
        '422':
          description: Validation Error
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/HTTPValidationError'
      security:
        - HTTPBearer: []
components:
  schemas:
    Body_preview_file_api_v1_upload_preview_post:
      properties:
        file:
          type: string
          format: binary
          title: File
          description: CSV or Excel file to preview
      type: object
      required:
        - file
      title: Body_preview_file_api_v1_upload_preview_post
    UnifiedPreviewResponse:
      properties:
        filename:
          type: string
          title: Filename
          description: Name of the uploaded file
        file_type:
          type: string
          enum:
            - csv
            - excel
          title: File Type
          description: Type of file uploaded
        csv_info:
          anyOf:
            - $ref: '#/components/schemas/CSVInfo'
            - type: 'null'
          description: CSV file information (only populated for CSV files)
        sheets:
          anyOf:
            - additionalProperties: true
              type: object
            - type: 'null'
          title: Sheets
          description: >-
            Information about each sheet in the Excel file (only populated for
            Excel files)
        total_sheets:
          anyOf:
            - type: integer
            - type: 'null'
          title: Total Sheets
          description: >-
            Total number of sheets in the Excel file (only populated for Excel
            files)
        message:
          type: string
          title: Message
          description: Success or informational message
      type: object
      required:
        - filename
        - file_type
        - message
      title: UnifiedPreviewResponse
      description: >-
        Unified preview response for CSV and Excel files.


        This model supports both CSV and Excel file previews through a single
        endpoint.

        The file_type field determines which optional fields are populated.
    HTTPValidationError:
      properties:
        detail:
          items:
            $ref: '#/components/schemas/ValidationError'
          type: array
          title: Detail
      type: object
      title: HTTPValidationError
    CSVInfo:
      properties:
        row_count:
          type: integer
          title: Row Count
          description: Total number of rows in the CSV file
        column_count:
          type: integer
          title: Column Count
          description: Number of columns in the CSV file
        columns:
          items:
            type: string
          type: array
          title: Columns
          description: List of column names/headers
        sample_data:
          items:
            additionalProperties: true
            type: object
          type: array
          title: Sample Data
          description: First 5 rows of data for preview
      type: object
      required:
        - row_count
        - column_count
        - columns
        - sample_data
      title: CSVInfo
      description: CSV file preview information.
    ValidationError:
      properties:
        loc:
          items:
            anyOf:
              - type: string
              - type: integer
          type: array
          title: Location
        msg:
          type: string
          title: Message
        type:
          type: string
          title: Error Type
      type: object
      required:
        - loc
        - msg
        - type
      title: ValidationError
  securitySchemes:
    HTTPBearer:
      type: http
      scheme: bearer

````