If your data upload is taking longer than expected, this article covers the most common causes and how to fix them.
What should I check if my upload is taking a long time?
If your upload has been processing for more than 20 minutes, work through these checks on your file:
- Keep all your data on one tab. Make sure there are no extra blank sheets in the file.
- Match your data to the field type. The data in each column needs to match the data type of the field it is being mapped to. For example, if a column is mapped to a Date field, every cell must contain a valid date using digits only, such as DD/MM/YYYY, with no letters. Check the Data Type Definitions article for more details.
- Keep column and sheet names simple. Names can only contain letters (a-z, A-Z), numbers (0-9), spaces and underscores (_). Punctuation such as &, @ or % will cause upload errors.
- Remove extra formatting. Avoid filters and cell colour fills in the file.
Still seeing long upload times?
If your file meets all of the above and the upload is still slow, get in touch through the live chat in the bottom right corner of your Force24 platform. Our team will be happy to help.