topic Re: Import excel spreadsheet to a database table in Data Engineering

Import excel spreadsheet to a database table

MGraham — Thu, 24 Jul 2025 22:42:16 GMT

How to Import excel spreadsheet to a database table.

Re: Import excel spreadsheet to a database table

jerrygen78 — Fri, 25 Jul 2025 06:07:22 GMT

Hi MGraham,

To import an Excel spreadsheet into a database table in Databricks, you can first upload the Excel file to DBFS (Databricks File System), then use libraries like pandas to read the Excel file (e.g., pd.read_excel("/dbfs/path/to/file.xlsx")) and convert it to a Spark DataFrame. Once in a DataFrame, you can write it to a database table using .write.format("jdbc") for external databases or .write.saveAsTable("table_name") for internal Databricks tables. Let me know if you'd like a quick code example!

Regards

Re: Import excel spreadsheet to a database table

FedeRaimondi — Fri, 25 Jul 2025 06:41:59 GMT

An alternative is also to store the flat file into a Volume in Unity Catalog. You can then access it in a similar way:

import pandas as pd volume_path= "/Volumes/<catalog>/<schema>/<volume_folder>/your_file.xlsx" pd.read_excel(volume_path, sheet_name="your_sheet")