Downloading multiple excel files at once from repo

[DH_Fable]

I have a notebook that produces lots of excel files which I want downloading on my local machine.

I can only currently download one by one which takes a long time when there are a lot of them.

Is there a way without using Azure CLI to download all of these excel files at once?

[Kaniz_Fatma]

Hi @DH_Fable, Yes, there are a few ways to download multiple files from Databricks FileStore to your local machine without using Azure CLI:

Databricks Portal GUI: You can download full results (max 1 million rows) using the Databricks porta....

DBFS Explorer: DBFS Explorer is a third-party tool that allows you to upload and download files to the Databricks filesystem (DBFS). This tool works with both AWS and Azure instances of Databricks. You will need to create a bearer token in the web interface in order to connect.

S3 Bucket: If you have access to an S3 bucket, you can write your data to the S3 bucket using the df.write.format command. Then, you can retrieve it using the aws s3 cp command.

[Kaniz_Fatma]

Thank you for posting your question in our community! We are happy to assist you.

To help us provide you with the most accurate information, could you please take a moment to review the responses and select the one that best answers your question?

This will also help other community members who may have similar questions in the future. Thank you for your participation and let us know if you need any further assistance!