Excel Multi-Sheet Support: Upload Workbooks, Pick Your Sheet

Beyond CSV: work with Excel files directly

Many teams keep their data in Excel workbooks, not plain CSV files. csv-api now supports uploading .xlsx and .xls files directly — including workbooks with multiple sheets.

No need to open Excel first, export to CSV, and then upload. Just drag and drop your workbook and pick the sheet you want.

Uploading an Excel file

1. 1 Go to Dashboard and click New Dataset.
2. 2 Select your .xlsx or .xls file. The upload accepts files up to your plan's size limit.
3. 3 If the workbook contains multiple sheets, you'll see a sheet selector on the preview page. Choose which sheet to import.
4. 4 Review the column names, detected types, and data preview, then click Confirm.

That's it — your API endpoint is live. The rest of the workflow is identical to CSV uploads: query, filter, sort, paginate, and share.

Multi-sheet selection

When you upload an Excel file with more than one sheet, csv-api detects all available sheets and presents them in a dropdown on the preview page. Key details:

• The first sheet is selected by default
• Switching sheets updates the preview instantly so you can verify you're importing the right data
• Each sheet becomes its own dataset with its own API endpoint
• To import multiple sheets, upload the same file again and select a different sheet each time

Automatic type detection

csv-api automatically detects column data types from your Excel data, just like with CSV files. Supported types include:

• Integer — whole numbers (1, 42, -7)
• Float — decimal numbers (3.14, 99.99)
• Boolean — true/false values
• Date — date and datetime values
• Text — everything else

Type detection ensures your API filters work correctly — numeric comparisons on number columns, date range queries on date columns, and so on.

Common use cases

• Financial reports — Upload a workbook with separate sheets for revenue, expenses, and projections. Create three datasets, each with its own API endpoint.
• Survey results — Import multi-tab survey exports directly without converting to CSV first.
• Inventory management — Keep products, suppliers, and warehouses in one workbook but query them independently through separate APIs.

Supported Excel formats