Skip to page contentSkip to chat
ServiceNow support
    • Community
      Ask questions, give advice, and connect with fellow ServiceNow professionals.
      Developer
      Build, test, and deploy applications
      Documentation
      Find detailed information about ServiceNow products, apps, features, and releases.
      Impact
      Accelerate ROI and amplify your expertise.
      Learning
      Build skills with instructor-led and online training.
      Partner
      Grow your business with promotions, news, and marketing tools
      ServiceNow
      Learn about ServiceNow products & solutions.
      Store
      Download certified apps and integrations that complement ServiceNow.
      Support
      Manage your instances, access self-help, and get technical support.
Troubleshooting export - Determine if the version of Excel cannot handle the data set size - Support and Troubleshooting
  • >
  • Knowledge Base
  • >
  • Support and Troubleshooting (Knowledge Base)
  • >
  • Troubleshooting export - Determine if the version of Excel cannot handle the data set size
KB0538306

Troubleshooting export - Determine if the version of Excel cannot handle the data set size


1746 Views Last updated : May 1, 2024 public Copy Permalink
KB Summary by Now Assist

Issue

This issue is related to exporting data from the instance into an Excel file. When opening the Excel file, not all records are shown.

Symptoms

  • Not all data exported
  • Records are missing from export

Cause

The number of records exported is higher than the number of rows that Excel can show. So, even though all records have been exported successfully into the Excel file, Excel can only show a certain number of rows.

Note: Until Office 2007, Excel had a maximum of 65,000 rows. In Office 2007 and later, the limit is 1,048,576 rows.

Resolution

To solve the issue and display more than 65,000 records in Excel, upgrade to Excel version 2007 or higher.

Note: To export and view more than 1,048,576 rows, export into a different file type such as CSV or XML.


The world works with ServiceNow.

Sign in for more! There's more content available only to authenticated users Sign in for more!
Did this KB article help you?
Did this KB article help you?

How would you rate your Now Support digital experience?

*

Very unsatisfied

Unsatisfied

Neutral

Satisfied

Very satisfied

Very unsatisfied

Unsatisfied

Neutral

Satisfied

Very satisfied

What can we improve? Please select all that apply.

What are we doing well? Please select all that apply.

Tell us more

*

Do you expect a response from this feedback?

  • Terms and conditions
  • Privacy statement
  • GDPR
  • Cookie policy
  • © 2025 ServiceNow. All rights reserved.