How to make a table in databricks using excel file

[senkii]

I want to upload excel file to make a table by using UI in databricks.

since databricks doesn't accept excel files. So I tried to change the datatype of  all the data in excel to string first.

Then transform it to csv uft-8, and click the [create ]button in the UI. upload the csv.

But it failed. I found many error in it.

Does someone can help me?

[Raman_Unifeye]

Latest blog about Read Excel feature of Databricks, however, its in beta.

https://docs.databricks.com/aws/en/query/formats/excel

Until then, pls follow this thread for excel processing - https://community.databricks.com/t5/community-articles/reading-excel-files-folder/td-p/77116