# New! Import from Excel **URL:** \ **Category:** Announcements\ **Created:** [August 16, 2023, 4:49pm UTC](https://forums.knack.com/t/new-import-from-excel/14743 "2023-08-16T16:49:30Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Kara](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/kara/32/2717_2.png) [@Kara](https://forums.knack.com/u/Kara)\ **Post date:** [August 16, 2023, 4:49pm UTC](https://forums.knack.com/t/new-import-from-excel/14743/1 "2023-08-16T16:49:30Z")
We’re excited to announce a powerful new feature for Knack - importing Excel files directly into apps alongside .CSV files! This update provides expanded data flexibility and enables new use cases for building apps, while avoiding the time-consuming conversions to CSV first. By supporting both modern (.xlsx) and classic (.xls) Excel formats, we ensure broad compatibility with files you already rely on everyday. [Notes](https://learn.knack.com/article/kog337vbvc-new-importing-xlsx-or-xls-files): - In a workbook with multiple tabs, we will import the first (left-most) tab - Values in cells are imported. Cell formatting, such as bold, colors, and font formats are not imported. - Due to the differences between Excel and Knack formulas and syntax, formulas are not preserved on import, but the values are. - Images in an Excel file will not import. - Classic .xls formats are supported alongside modern .xlsx. - If your imported sheet does not contain the data you were expecting, there may be hidden worksheets in your Excel workbook. To import the correct data, un-hide all hidden worksheets and move your desired worksheet to the first position. Cheers! Kara ---
**Author:** ![MichaelG](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/michaelg/32/758_2.png) [@MichaelG](https://forums.knack.com/u/MichaelG)\ **Post date:** [August 16, 2023, 8:00pm UTC](https://forums.knack.com/t/new-import-from-excel/14743/2 "2023-08-16T20:00:46Z")
Great!! At one time I did go through this time-consuming conversion to CSV first. “expanded data flexibility and enables new use cases for building apps” very much indeed!! Go Knack! ---
**Author:** ![Markal](https://avatars.discourse-cdn.com/v4/letter/m/49beb7/32.png) [@Markal](https://forums.knack.com/u/Markal)\ **Post date:** [August 18, 2023, 10:05am UTC](https://forums.knack.com/t/new-import-from-excel/14743/3 "2023-08-18T10:05:43Z")
👍 Excellente nouvelle, je suis ravie de voir les nouvelles évolutions et fonctionnalités sur Knack ! Continuez comme ça. Translation: Great news, I’m delighted to see the new developments and features on Knack! Keep it up. ---
**Author:** ![IAmAKnacker](https://avatars.discourse-cdn.com/v4/letter/i/5f9b8f/32.png) [@IAmAKnacker](https://forums.knack.com/u/IAmAKnacker)\ **Post date:** [August 22, 2023, 2:15am UTC](https://forums.knack.com/t/new-import-from-excel/14743/4 "2023-08-22T02:15:22Z")
This is great. Now we just need to be able to do it from the app. ---
**Author:** ![Kara](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/kara/32/2717_2.png) [@Kara](https://forums.knack.com/u/Kara)\ **Post date:** [August 22, 2023, 5:58pm UTC](https://forums.knack.com/t/new-import-from-excel/14743/5 "2023-08-22T17:58:37Z")
Hi Anand! You can import an Excel file directly in the app to create a new table, or into an existing table ✅ ---
**Author:** ![IAmAKnacker](https://avatars.discourse-cdn.com/v4/letter/i/5f9b8f/32.png) [@IAmAKnacker](https://forums.knack.com/u/IAmAKnacker)\ **Post date:** [August 22, 2023, 7:36pm UTC](https://forums.knack.com/t/new-import-from-excel/14743/6 "2023-08-22T19:36:10Z")
Sorry, i should have been more clear. It would be nice if it could be done from the Live App (not database side) ---
**Author:** ![MichaelG](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/michaelg/32/758_2.png) [@MichaelG](https://forums.knack.com/u/MichaelG)\ **Post date:** [August 29, 2023, 8:17pm UTC](https://forums.knack.com/t/new-import-from-excel/14743/7 "2023-08-29T20:17:08Z")
On the same line, it would be very useful to add the Excel format to export the data. ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/f/f6f613ae77a9c39bee2ca158889710f4c01623f5.png) ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/0/0e9857b09a5bf0e769aac1efa77628bb2a4254ed.png) ---
**Author:** ![carolyn.nardi](https://avatars.discourse-cdn.com/v4/letter/c/7cd45c/32.png) [@carolyn.nardi](https://forums.knack.com/u/carolyn.nardi)\ **Post date:** [September 12, 2023, 5:12pm UTC](https://forums.knack.com/t/new-import-from-excel/14743/8 "2023-09-12T17:12:46Z")
> [@Kara](#): > > We’re excited to announce a powerful new feature for Knack - importing Excel files directly into apps alongside .CSV files! > > This update provides expanded data flexibility and enables new use cases for building apps, while avoiding the time-consuming conversions to CSV first. > > By supporting both modern (.xlsx) and classic (.xls) Excel formats, we ensure broad compatibility with files you already rely on everyday. > > [Notes](https://learn.knack.com/article/kog337vbvc-new-importing-xlsx-or-xls-files): > > - In a workbook with multiple tabs, we will import the first (left-most) tab > - Values in cells are imported. Cell formatting, such as bold, colors, and font formats are not imported. > - Due to the differences between Excel and Knack formulas and syntax, formulas are not preserved on import, but the values are. > - Images in an Excel file will not import. > - Classic .xls formats are supported alongside modern .xlsx. > - If your imported sheet does not contain the data you were expecting, there may be hidden worksheets in your Excel workbook. To import the correct data, un-hide all hidden worksheets and move your desired worksheet to the first position. When importing a workbook with multiple tabs, Knack will import the first (left-most) tab. Values in cells are imported, but cell formatting (bold, colors, font formats) is not imported. \* Excel formulas are not preserved on import, but the values are imported. Images in an Excel file will not be imported.