You can create a new app by importing an Excel file. In this way, you can create an app and import the file data into the app at the same time. This page guides you through the steps to create an app from an Excel file you use in your business.

To import data from a CSV file, refer to Creating Apps from CSV Files.
To import data from an Excel file into an existing app, refer to Importing Record Data from a File into an App.

(1) Make sure that the Excel file used in your business or a copy of the file is ready to use.
(2) Format the Excel file so that it can be imported to kintone, then save the file.
(3) Follow the instructions on the wizard to import the file.

1. Format data in the Excel file so that the data can be imported to kintone.
   Then, save the file on your PC.

2. On the kintone Portal, click the Create App icon (the plus sign-shaped icon) in the Apps section.

3. On the "kintone Marketplace" screen, click Create from Excel under Create New App.
   

4. On the "Create from Excel" screen, click Continue.
   

5. Confirm and select the checkbox for each file formatting requirement, then click Continue to the Upload screen.

   

6. Click Browse under Upload an Excel File, then select a file to import.
   

7. When the Import Range of the Excel File dialog box appears, specify a data range to import to kintone.
   The Import Range of the Excel File dialog box does not appear if the system automatically recognizes the imported data range.
   

8. Under Check the Preview, check that the first row of the preview displays the item names that will be used as field names.
   If the items you want to import are not displayed correctly or you want to change the data to import, click Change the data range to specify a different range.
   

   If the first row has any empty cells or merged cells, the system names the fields automatically.
   For example, if there is an empty cell in column B, its field will be named "field_B*".
   Or, if two cells are merged as "Address", the field of one of the merged cells will be named "Address(2)*".

9. Under Start Converting to an App, check that the automatically selected field types are correct.
   kintone automatically sets appropriate field types based on the data of the top 100 rows in the Excel file. Generally, you do not have to change the field types.
   For items that you do not want to import from the Excel file, set the Field Type to (Skip this row).
   

10. Click Convert on the bottom right side of the screen.
    If clicking Convert results in an error, refer to If Creating an App from an Excel or CSV File Fails.
    

11. When the import completes, check the created app.
    When you click the app name displayed on the Portal, the "View" screen appears.
    You can change the app's name, icon, field positions, and other settings as you see fit.

    • Changing an App Name
    • Changing an Icon and Setting the Description of an App
    • Configuring Forms

If you cannot solve your issues with the solutions described above, refer to If Creating an App from an Excel or CSV File Fails.

kintone can import files that have such settings. However, the display formats or conditional formats in Excel are not applied to apps on kintone.

You can import only the result values.

No.
Instead, you can import data that contains a table after creating an app.
Importing Record Data from a File into an App

When creating an app from a file, you cannot select a "Multi-choice" field or "Check box" field as a field type.
For details, refer to the following page.
Unavailable Field Types
Note that you cannot change field types after an app has been created.