Upload CSV, XLSX, XLS files to MindsDB

You can upload CSV, XLSX, and XLS files of any size to MindsDB that runs locally via Docker or pip.

CSV, XLSX, XLS files are stored in the form of a table inside MindsDB.

Upload files

Follow the steps below to upload a file:

1. Click on the Add dropdown and choose Upload file.

2. Upload a file and provide a name used to access it within MindsDB.

3. Alternatively, upload a file as a link and provide a name used to access it within MindsDB.

Query files

The CSV, XLSX, and XLS files may contain one or more sheets. Here is how to query data within MindsDB.

Query for the list of available sheets in the file uploaded under the name my_file.

SELECT *
FROM files.my_file;

Query for the content of one of the sheets listed with the command above.

SELECT *
FROM files.my_file.my_sheet;