@extends('layouts.app') @section('title', 'Import Excel') @section('content')

Import Excel Data

Upload an Excel file and select the columns you want to import.

How to Use

Using Column Letters

You can directly specify column letters (A, B, C) to import specific columns by their position:

  1. Enter column letters like A, B, or C in the column fields
  2. All data from those columns will be imported
  3. Perfect when you know the exact columns you need
Example: B, D, F (imports second, fourth, and sixth columns)

Using Column Headers

You can use the header names from your Excel file's first row:

  1. Enter the exact header names from the first row of your Excel file
  2. Case-sensitive and must match exactly
  3. Perfect when your Excel file has clear headers
Example: First Name, Email, Phone Number
Note: You can preview the data before confirming the import to ensure you've selected the correct columns.
@csrf

or drag and drop

XLSX, XLS, or CSV up to 2MB

@error('excel_file')

{{ $message }}

@enderror

Column Selection Options

  • Column Letters: Enter column letters (A, B, C, etc.) to select specific columns by position
  • Column Names: Enter the header names that match your Excel file's first row
@error('columns')

{{ $message }}

@enderror
@endsection @section('scripts') @endsection