All Collections
How do I break up and import a large spreadsheet?
How do I break up and import a large spreadsheet?

Importing a huge Excel sheet can lag or fail. If so, split it into smaller segments

Ciara Scott avatar
Written by Ciara Scott
Updated over a week ago

If you are importing a very large Excel sheet it may take some time where the app is spinning, maybe up to 15 minutes. If the upload should fail after that length of time, here's how you can split it up.

The workaround is to divide the large Excel spreadsheet into smaller, more manageable segments. Here's a step-by-step guide to doing this:

  1. Break down your Excel sheet into several workbooks with fewer columns.

  2. Label each new Excel workbook clearly to keep track of the data segments: "Part1", "Part2", etc.,

  3. Once split, upload each workbook sequentially. When uploading ensure the Delete existing turnsheet columns toggle is turned OFF, and the imported columns will be appended to the end of the turnsheet.

Did this answer your question?