GitHub user dosubot[bot] added a comment to the discussion: How to import dataset with extension .xlsx in Superset 5.0.0?
<!-- Answer --> Superset relies on the Shillelagh library to read Google Sheets, and it uses the first row of your sheet as column headers. If a column isn't being read, it's usually because the header row has issues—like blank cells, duplicate names, special characters, or merged cells. Superset doesn't filter or modify columns itself; it just trusts what Shillelagh detects from your sheet structure [reference](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/superset/db_engine_specs/gsheets.py). Check your Google Sheet and make sure every column you want is present in the first row, has a unique and non-empty header, and avoids merged cells or formatting quirks. After fixing, try refreshing or re-syncing the dataset in Superset. <!-- 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/3d362d12-380d-4c07-acb7-1a6c5188ad96?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/3d362d12-380d-4c07-acb7-1a6c5188ad96?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/3d362d12-380d-4c07-acb7-1a6c5188ad96?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/3d362d12-380d-4c07-acb7-1a6c5188ad96?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/3d362d12-380d-4c07-acb7-1a6c5188ad96?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/3d362d12-380d-4c07-acb7-1a6c5188ad96?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/3d362d12-380d-4c07-acb7-1a6c5188ad96?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-14159976 ---- 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]
