GitHub user dosubot[bot] added a comment to the discussion: How to import dataset with extension .xlsx in Superset 5.0.0?
<!-- Answer --> Superset 5.0.0 supports importing datasets from .xlsx files directly. To do this, first make sure the target database connection has "Allow file uploads to database" enabled (in the database settings, under the Advanced tab, Security section) [docs](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/docs/docs/using-superset/exploring-data.mdx). Then, use the "Upload file to database" option in the UI, select your .xlsx file, pick the database, schema, and table name, and configure any Excel-specific options like sheet name, columns to parse as dates, decimal character, null values, index column, header row, rows to read, and rows to skip [code](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/superset-frontend/src/features/databases/UploadDataModel/index.tsx). The UI will validate that your file has a .xlsx extension and let you preview and configure the import. After uploading, the dataset will appear in the Datasets tab and is ready for exploration and visualization [docs](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/docs/docs/using-superset/exploring-data.mdx). Make sure your environment has the necessary dependencies for Excel parsing (like openpyxl). No workarounds are needed—.xlsx import is natively supported in this version. <!-- Dosu Comment Footer --> *To reply, just mention [@dosu](https://go.dosu.dev/dosubot).* --- <sup>How did I do? [Good](https://app.dosu.dev/response-feedback/3b677845-daf6-4189-9a1d-e705edbc3348?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/3b677845-daf6-4189-9a1d-e705edbc3348?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/3b677845-daf6-4189-9a1d-e705edbc3348?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/3b677845-daf6-4189-9a1d-e705edbc3348?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/3b677845-daf6-4189-9a1d-e705edbc3348?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/3b677845-daf6-4189-9a1d-e705edbc3348?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/3b677845-daf6-4189-9a1d-e705edbc3348?feedback_type=other)</sup> [](https://app.dosu.dev/a28d3c7e-a9d3-459e-9fb6-3a6f9ff4f357/ask?utm_source=github)& nbsp;[](https://go.dosu.dev/discord-bot) [](https://twitter.com/intent/tweet?text=%40dosu_ai%20helped%20me%20solve%20this%20issue!&url=https%3A//github.com/apache/superset/discussions/34770) GitHub link: https://github.com/apache/superset/discussions/34770#discussioncomment-14158852 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
