NocoDB: 🚀 🚀 0.83.0 - Import Spreadsheets

# 🚀 [NocoDB](https://nocodb.com) : Feature release <img width="1146" alt="Screen Shot 2021-11-23 at 13 10 39" src="https://user-images.githubusercontent.com/5435402/143030652-45b844f7-db0b-4ec9-863c-7af95db816d9.png"> ### Features - You can import an Excel spreadsheet as a NocoDB project with just 1-Click. - We auto-identify schema and data type for you. - Then automatically import data. - Supported file formats: xls, xlsx, xlsm - Supports importing to new or to an existing NocoDB project. - Supports importing from your computer or a downloadable URL. ### How to use - Click on `New Project` - Select `Create project from excel` option, - Select file to Upload (OR) drag & drop file - Or you can also simply drag & drop to NocoDB home screen ;) https://user-images.githubusercontent.com/5435402/143030857-daa34db5-0ed2-46fa-8696-255ed266f9a3.mov ------------------------------------------------ ### Deriving Table & Column name - By default, the individual workbook sheet name will be marked as Table name. - By default, details present in the first row will be used to create a Column name. If empty, NocoDB adds `field <column-number>` as column name. - If two columns have the same name, NocoDB adds a numerical suffix to make the column name's unique - Default names can be re-configured in the `Customize` page during project import (OR) using the `Rename` option after project creation - Additional column's if needed can be added from the `Customize` page during project creation (OR) by using `Add Table` after project creation ## Deriving Spreadsheet Data & Data type NocoDB identifies Column data type on the best effort basis; falls back to `SingleLineText` if it fails to find suitable mapping datatype. - By default, the first 500 rows are used to identify column datatype. This number is configurable during project import time using the Advanced menu option - Empty columns to the left are ignored. Empty columns appearing in between are added to the table as `SingleLineText` column with default column name - Empty rows are *always* ignored #### Datatype (Numbers) - **Number**: If every column data is a whole number (signed integer) - **Decimal**: If some column data contain decimal numbers - **Currency**: If every column data contains '$' prefix to the number associated (any other special characters not allowed) - **Percentage**: If every column data contains '%' suffix to the number associated (any other special characters not allowed) #### Datatype (Date/Time) - **Date**: Supported format> YYYY-MM-DD - **Time**: Converted to `SingleLineText` - **Date & Time**: Supported format> YYYY-MM-DD HH:MM:SS #### Datatype (Selects, Formula) - **Formula**: Data type identified based on computed result of the formula. - **Checkbox**: If column data represent boolean (true/false) state - **Multi-select**: If column data contains comma seperated values. Each value will be treated as a selection token - **Single-select**: If all values in the column are same #### Datatype (Text) - **Long text**: If some column data text length is greater than 255 characters (OR) contains newline character (\n or \r) - **Single line text**: Default/fallback datatype The datatypes identified by NocoDB can be overridden during project creation. Note that, NocoDB uses SQLITE3 database; and hence you will not be able to change column datatype after the project is created #### Misc notes - Merge cells: pre-merge values in the cell are considered for datatype identification & the same are populated into associated cells/fields - Rich text formatting in excel is ignored (font size/ color/ bold/ italics, and such) --- ## Closed issues - [**closed**] Fails to load on safari [#799](https://github.com/nocodb/nocodb/issues/799) - [**closed**] Table create fails after table rename operation [#795](https://github.com/nocodb/nocodb/issues/795) - [**bug**] Unable to use handlebar syntax in mobile number field of Twilio plugin? [#792](https://github.com/nocodb/nocodb/issues/792) - [**closed**] Is there an undo and redo? [#790](https://github.com/nocodb/nocodb/issues/790) - [**closed**] External IP addresses during installation and use [#786](https://github.com/nocodb/nocodb/issues/786) - [**closed**] The other version [#784](https://github.com/nocodb/nocodb/issues/784) - [**closed**] CSV Import same file name [#778](https://github.com/nocodb/nocodb/issues/778) - [**closed**] Deploy on Plesk Server [#776](https://github.com/nocodb/nocodb/issues/776) - [**closed**] Nocodb always open registration [#773](https://github.com/nocodb/nocodb/issues/773) - [**enhancement**] Auto update data on table opening (when clicking the tab) [#767](https://github.com/nocodb/nocodb/issues/767) - [**bug**] Blank page after filtering; need to click page in pagination to see results [#766](https://github.com/nocodb/nocodb/issues/766) - [**bug**] CSV export of jsonb column does not work [#758](https://github.com/nocodb/nocodb/issues/758) - [**bug**] Incorrect offset in pagination when increased number of shown records [#755](https://github.com/nocodb/nocodb/issues/755) - [**bug**] create-nocodb-app fail when used from a path containing a space [#747](https://github.com/nocodb/nocodb/issues/747) - [**bug**] Component visibility to some specific roles [#738](https://github.com/nocodb/nocodb/issues/738) - [**community**] wrong nav drawer toggle button position after adjusting the nav drawer weight [#735](https://github.com/nocodb/nocodb/issues/735) - [**bug**] Some buttons should be limited to creator / owner role [#732](https://github.com/nocodb/nocodb/issues/732) - [**bug**] Bug: Rename Table does not work [#205](https://github.com/nocodb/nocodb/issues/205) **Full Changelog**: https://github.com/nocodb/nocodb/compare/0.82.0...0.83.0