# Do hidden Excel columns get imported? **URL:** \ **Category:** Ask for Help\ **Created:** [May 17, 2023, 3:50pm UTC](https://community.glideapps.com/t/do-hidden-excel-columns-get-imported/61854 "2023-05-17T15:50:53Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Simon\_Hill](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/simon_hill/32/94730_2.png) [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)\ **Post date:** [May 17, 2023, 3:50pm UTC](https://community.glideapps.com/t/do-hidden-excel-columns-get-imported/61854/1 "2023-05-17T15:50:53Z")
Any way to avoid hidden Excel columns from being imported into a glide table? (I should have checked, but I assume they are always automatically imported). ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [May 17, 2023, 5:27pm UTC](https://community.glideapps.com/t/do-hidden-excel-columns-get-imported/61854/2 "2023-05-17T17:27:18Z")
The Protected Column feature is designed specifically for this reason: to avoid displaying data from an external data source such as Google Sheets or Excel in Glide. Admittedly, I never use the feature. I know it’s available in Classic Apps, but I don’t know if it’s available in Apps. Please let us know! (I’m not in front of a computer.) ---
**Author:** ![Simon\_Hill](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/simon_hill/32/94730_2.png) [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)\ **Post date:** [May 17, 2023, 6:53pm UTC](https://community.glideapps.com/t/do-hidden-excel-columns-get-imported/61854/3 "2023-05-17T18:53:31Z")
Thanks I will check later. ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [May 17, 2023, 8:07pm UTC](https://community.glideapps.com/t/do-hidden-excel-columns-get-imported/61854/4 "2023-05-17T20:07:15Z")
The Protected Column is still there. - In the Data Editor, go to a table of an external data source (Google Sheets, Excel, Airtable) - Go to column whose data you would like to hide - In the drop down menu of the column, you can “Make protected” - If I recall correctly, you can write to Protected Columns, but the app cannot read the data from that column ever ( ~~and therefore neither edit nor delete data~~ ). - EDIT (see Darren’s comment below): “Actually, you can edit data in Protected Columns, both with Edit Forms and using Set Column Values actions.” ![CleanShot 2023-05-17 at 22.01.05@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/7/77ecb4345020a24eba05eb6ee520941ad88a0adc.png) > **[Glide • Protected Columns](https://www.glideapps.com/docs/reference/security-and-user-data/protected-columns)** > > Keep unused columns in your data source secure. ---
**Author:** ![Simon\_Hill](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/simon_hill/32/94730_2.png) [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)\ **Post date:** [May 18, 2023, 9:34am UTC](https://community.glideapps.com/t/do-hidden-excel-columns-get-imported/61854/5 "2023-05-18T09:34:34Z")
So the answer appears to be no. Glide overrides any visible/hidden settings in an Excel sheet and imports everything into a Glide table. After import, all columns are visible even if they were hidden in the Excel sheet. Pity. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [May 18, 2023, 9:57am UTC](https://community.glideapps.com/t/do-hidden-excel-columns-get-imported/61854/6 "2023-05-18T09:57:39Z")
> [@nathanaelb](#): > > If I recall correctly, you can write to Protected Columns, but the app cannot read the data from that column ever (and therefore neither edit nor delete data). Actually, you can edit data in Protected Columns, both with Edit Forms and using Set Column Values actions. It’s kind of weird, because if you open an Edit Form and add an input that points to a Protected Column, it will appear empty - even though it may have data in the source. I’m not exactly sure if that is intended or not. My gut feeling is that it might be a bug/oversight 🤷‍♂️ ---
**Author:** ![Simon\_Hill](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/simon_hill/32/94730_2.png) [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)\ **Post date:** [May 18, 2023, 10:00am UTC](https://community.glideapps.com/t/do-hidden-excel-columns-get-imported/61854/7 "2023-05-18T10:00:01Z")
I was not really talking about protected columns. Just hidden columns in Excel. I will try to see if Glide ignores protected columns on import. Thanks. ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [May 18, 2023, 10:20am UTC](https://community.glideapps.com/t/do-hidden-excel-columns-get-imported/61854/8 "2023-05-18T10:20:24Z")
Good to know. Write+edit it is then. Thanks for the correction. ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [May 18, 2023, 10:28am UTC](https://community.glideapps.com/t/do-hidden-excel-columns-get-imported/61854/9 "2023-05-18T10:28:34Z")
Do a test of course, but I don’t think Glide will ignore hidden columns. Basically, Glide displays the data that is there in the Excel / Google Sheets and doesn’t “see” any type of formatting: lines, colors, font types, filters, hidden columns, slicers … all these really are formatting. I know the term “formatting” is not the best when it comes to filters or hidden columns. What I mean is, in a filter or a hidden column, the data is definitely there, it just happens to be hidden from view in Excel / Google Sheets. But it’s there. So Glide will display it in the Data Editor. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [May 18, 2023, 11:24pm UTC](https://community.glideapps.com/t/do-hidden-excel-columns-get-imported/61854/10 "2023-05-18T23:24:34Z")
Yeah, maybe the API that Glide calls don’t have the ability to see whether the column is hidden or not, or in an extension of it, as you said, formatting.