# Import excel - Glide table empty columns **URL:** \ **Category:** Ask for Help\ **Created:** [November 9, 2024, 11:30am UTC](https://community.glideapps.com/t/import-excel-glide-table-empty-columns/77780 "2024-11-09T11:30:27Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![Ganymed](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ganymed/32/27001_2.png) [@Ganymed](https://community.glideapps.com/u/Ganymed)\ **Post date:** [November 9, 2024, 11:30am UTC](https://community.glideapps.com/t/import-excel-glide-table-empty-columns/77780/1 "2024-11-09T11:30:27Z")
Importing data from excel into a glide table via “import” requires the column names to be identical to the glide fields. Everything works well except every now and than “glide” creates new empty columns. I am assuming that something, some “invisible content” in the excel sheet triggers this. Is there a minimum requirement how empty an excel column has to be in order to be ignored? ---
**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:** [November 9, 2024, 11:52am UTC](https://community.glideapps.com/t/import-excel-glide-table-empty-columns/77780/2 "2024-11-09T11:52:20Z")
My only suggestion would be to ensure you have removed any extra (unused) columns from the Excel sheet before importing. ---
**Author:** ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)\ **Post date:** [November 9, 2024, 12:14pm UTC](https://community.glideapps.com/t/import-excel-glide-table-empty-columns/77780/3 "2024-11-09T12:14:24Z")
I had the same issue and the solution was to convert the Excel Sheet range to a table. Watch the video embed on the Microsoft Documentation: > **[Create and format tables - Microsoft Support](https://support.microsoft.com/en-us/office/create-and-format-tables-e81aa349-b006-4f8a-9806-5af9df0ac664)** > > Learn about the many ways to create a table in an Excel worksheet, and how to clear data, formatting, or table functionality from a table in Excel. Discover more in this video. ---
**Author:** ![Ganymed](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ganymed/32/27001_2.png) [@Ganymed](https://community.glideapps.com/u/Ganymed)\ **Post date:** [November 9, 2024, 1:37pm UTC](https://community.glideapps.com/t/import-excel-glide-table-empty-columns/77780/4 "2024-11-09T13:37:06Z")
Tried, have created/ formated table…result 27 new empty columns… did not work… ---
**Author:** ![Ganymed](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ganymed/32/27001_2.png) [@Ganymed](https://community.glideapps.com/u/Ganymed)\ **Post date:** [November 9, 2024, 1:39pm UTC](https://community.glideapps.com/t/import-excel-glide-table-empty-columns/77780/5 "2024-11-09T13:39:43Z")
Not sure how to do this, Excel seems to always add empty columns to the right… ---
**Author:** ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)\ **Post date:** [November 9, 2024, 1:40pm UTC](https://community.glideapps.com/t/import-excel-glide-table-empty-columns/77780/6 "2024-11-09T13:40:08Z")
Even after converting? ---
**Author:** ![Ganymed](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ganymed/32/27001_2.png) [@Ganymed](https://community.glideapps.com/u/Ganymed)\ **Post date:** [November 9, 2024, 1:49pm UTC](https://community.glideapps.com/t/import-excel-glide-table-empty-columns/77780/7 "2024-11-09T13:49:49Z")
yes… ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/2/825b3d27b20086a4d1e984c0248839d1f11b4cfa.png) ---
**Author:** ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)\ **Post date:** [November 9, 2024, 1:55pm UTC](https://community.glideapps.com/t/import-excel-glide-table-empty-columns/77780/8 "2024-11-09T13:55:53Z")
You are talking about the “AF” to “AJ” ? If you do, these are not included in the table. ---
**Author:** ![Ganymed](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ganymed/32/27001_2.png) [@Ganymed](https://community.glideapps.com/u/Ganymed)\ **Post date:** [November 9, 2024, 2:34pm UTC](https://community.glideapps.com/t/import-excel-glide-table-empty-columns/77780/9 "2024-11-09T14:34:52Z")
No question - however Glide generates empty columns anyways so my problem still exists. Every import a new bunch ?!? - 37 to be exact… ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/5/0501f18b7f98280a41fa7e2f31badae7f4bb4c1d.png) ---
**Author:** ![Ganymed](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ganymed/32/27001_2.png) [@Ganymed](https://community.glideapps.com/u/Ganymed)\ **Post date:** [November 9, 2024, 2:36pm UTC](https://community.glideapps.com/t/import-excel-glide-table-empty-columns/77780/10 "2024-11-09T14:36:25Z")
Daren but than again the question why would Glide import unused columns? ---
**Author:** ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)\ **Post date:** [November 9, 2024, 2:49pm UTC](https://community.glideapps.com/t/import-excel-glide-table-empty-columns/77780/11 "2024-11-09T14:49:37Z")
It sometime happens when there are value in cells somewhere in a row. Check the 37 columns and verify if you see value in a row. ---
**Author:** ![Ganymed](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ganymed/32/27001_2.png) [@Ganymed](https://community.glideapps.com/u/Ganymed)\ **Post date:** [November 9, 2024, 4:16pm UTC](https://community.glideapps.com/t/import-excel-glide-table-empty-columns/77780/12 "2024-11-09T16:16:42Z")
Created a new excel, copied only values, formated table and it did work. Thx ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [November 16, 2024, 4:17pm UTC](https://community.glideapps.com/t/import-excel-glide-table-empty-columns/77780/13 "2024-11-16T16:17:25Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.