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 detect columns from Google Sheets, using the first row as headers. If the 'no_ps' column isn't being read, it's almost always due to a formatting issue in the sheet—like a blank or merged header cell, duplicate column names, or special characters in the header. 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 that the 'no_ps' header is present, unique, and not blank in the first row of your sheet. Avoid merged cells or formatting quirks. After fixing, refresh or re-sync the dataset in Superset. If you use custom SQL or Jinja templating, make sure your query always returns results, as empty queries can cause columns to disappear during sync. <!-- 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/03dd8e07-f90d-4c11-8683-5d22ffba8e4a?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/03dd8e07-f90d-4c11-8683-5d22ffba8e4a?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/03dd8e07-f90d-4c11-8683-5d22ffba8e4a?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/03dd8e07-f90d-4c11-8683-5d22ffba8e4a?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/03dd8e07-f90d-4c11-8683-5d22ffba8e4a?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/03dd8e07-f90d-4c11-8683-5d22ffba8e4a?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/03dd8e07-f90d-4c11-8683-5d22ffba8e4a?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-14160351 ---- 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]
