Solutions for Handling Excel Files That Exceed Size Limitation of 1 MB, 1,000 Records, and 500 Columns

Try following solutions when the data in a Excel file exceeds the size limitation of 1 MB, 1,000 records, and 500 columns.

When the File Exceeds 1 MB

You have following three basic solutions:

  • Make the Excel file smaller
    You can copy the necessary data from the source (large) file and paste it to a new file, which might create a smaller file.
    Try, for example, to select only the actual data and copy them to a new file.
    Note that you cannot import functions and formulas in the cells to kintone. You can import only the resulted values. To make the amount of data smaller, you may want to consider pasting functions and formulas in the file as "values" to a new file.

    You can also try the following methods to make the file size smaller.

    • Delete the unused rows and columns.
    • Select hidden objects and comments together and delete them at a time.
    • Deselect "Share Workbook" option if it is selected.
  • Select only the target worksheet and save it to another Excel file
    You can only import single worksheet when creating an app from an Excel file.
    If the file contains multiple worksheets, causing it to be large, select and save only the target worksheet, and try to create an app.

  • Save the file as CSV
    By using a CSV file, you can import up to 100 MB of data to create an app.
    Save the Excel file as a CSV file, and then create an app from the CSV file.

When the File Has More Than 1,000 Records

You have following two basic solutions:

  • Create an app with the first 1,000 rows and then import the file containing remaining rows
    First, copy the 1,001st row and the rest to another worksheet or file.
    Then, in the original Excel file, delete the rows so that the resulting file contains less than or equal to 1,000 rows, and import the Excel file to create an app.
    You can then add remaining data copied to another worksheet or file to the app later, using Import from file function.

  • Save the file as CSV
    By using a CSV file, you can import up to 100,000 rows of data to create an app .
    Save the Excel file as a CSV file, and then create an app from the CSV file.

When the File Has More Than 500 Columns

If you can delete unnecessary columns, delete them from the file to reduce the number of rows to 500 or less.
You cannot import functions and formulas in the cells to kintone. You can import only the resulted values. You might want to consider deleting rows with functions and formulas.