Product documentation Docs
    • English
    • Deutsch
    • 日本語
    • 한국어
    • Français
  • More Sites
    • Now Community
    • Developer Site
    • Knowledge Base
    • Product Information
    • ServiceNow.com
    • Training
    • Customer Success Center
    • ServiceNow Support Videos
  • Log in

Product documentation

  • Home
How search works:
  • Punctuation and capital letters are ignored
  • Special characters like underscores (_) are removed
  • Known synonyms are applied
  • The most relevant topics (based on weighting and matching to search terms) are listed first in search results
Topics are ranked in search results by how closely they match your search terms
  • A match on the entire phrase you typed
  • A match on part of the phrase you typed
  • A match on ALL of the terms in the phrase you typed
  • A match on ANY of the terms in the phrase you typed

Note: Matches in titles are always highly ranked.

  • Release version
    Table of Contents
    • Now Platform administration
Table of Contents
Choose your release version
    Home London Platform Administration Now Platform administration Data management Export and import XML files Exporting data Export limits

    Export limits

    • Save as PDF Selected topic Topic & subtopics All topics in contents
    • Unsubscribe Log in to subscribe to topics and get notified when content changes.
    • Share this page

    Export limits

    The platform provides a default upper limit for data exports.

    The purpose of the upper limit is to avoid creating performance issues when a table is excessively large. If you need to export more records than the threshold permits, Break up a large export into separate manageable chunks.

    Export limit properties

    You can set the number of records to return during an export using the sysparm_record_count URL parameter.

    However, the system analyzes the following settings to determine whether an export limit should be applied.
    1. First, the platform checks the property that defines the format-specific export limit (see table below). Each format can have a different limit. Although this property can be set to any value, exceeding the default export limit can impact system performance. You may want to set the property at or below the default limit and have users Break up a large export to export large amounts of data.
    2. If the format-specific property is not set, the system checks the property for the general export limit (see table below). This property can also be set to any value, but exceeding the default export limit can impact system performance.
    3. If neither the format-specific export limit nor the general export limit property is set, the system enforces the default export limit (see table below).
    Important: To set these properties, navigate to System Properties > Import Export.
    Table 1. Default export limit
    Format Format-specific export limit General export limit Default export limit
    XML glide.xml.export.limit glide.ui.export.limit 10,000
    CSV glide.csv.export.limit glide.ui.export.limit 10,000
    EXCEL (XLSX) glide.xlsx.export.limit glide.ui.export.limit 10,000
    EXCEL (XLS) glide.excel.export.limit glide.ui.export.limit 10,000
    EXCEL (XLSX) glide.xlsx.max_cells N/A 500,000
    EXCEL (XLS) glide.excel.max_cells N/A 500,000
    PDF glide.pdf.max_rows
    Note: The number of rows can be set from 0 to 5,000. If no value is specified, the default is 1,000. If a value greater than 5,000 is specified, the default value of 1,000 is used.
    N/A 1,000
    PDF glide.pdf.max_columns
    Note: Although the number of columns can be set higher than 25, this is not advisable,since only 25 header labels fit on a page.
    N/A 25
    JSON glide.json.export.limit glide.ui.export.limit 10,000

    A warning threshold property called glide.ui.export.warn.threshold controls how the records are exported. If a user attempts to export a number of records from a List export that exceeds the warning threshold, a dialog box offers the choice of waiting for the export to complete or having the exported records emailed as an attachment. The warning threshold can be changed in the system property. The email attachment must not exceed the maximum allowed Email size limits.

    Table 2. Export limit examples
    Example Property Table Note
    Exporting to CSV
    • glide.csv.export.limit = 20,000
    • glide.ui.export.limit = 10,000
    • com.glide.processors.XMLProcessor.max_record_count = 20,000
    • Default export limit for CSV = 10,000
    Table 3. Exporting to CSV
    Records to be Exported Records Returned
    15,000 15,000
    30,000 20,000
    In the second export, the number of records returned from the database is limited because the number of records specified for export exceeds the value set in the glide.csv.export.limit property.
    Exporting to Excel (XLSX)
    • glide.xlsx.export.limit = no entry
    • glide.ui.export.limit = no entry
    • Default export limit for Excel (XLSX) = 10,000
    Table 4. Exporting to Excel
    Records to be Exported Records Returned
    10,000 10,000
    30,000 10,000
    In the second export, the number of records returned from the database is limited because the number of records specified for export exceeds the default export limit for Excel, 10,000 records.
    Exporting to PDF
    • glide.pdf.max_rows = 1,000
    • Default export limit for PDF = 1,000
    • Maximum export limit for PDF = 5,000
    Table 5. Exporting to PDF
    Records to be Exported Records Returned
    1,000 1,000
    5,000 1,000
    In the first export, all records are returned because the number of records specified for export does not exceed the glide.pdf.max_rows property. In the second export, the number of records returned is limited because the number of records specified for export exceeds the default value in the glide.pdf.max_rows property.

    Excel export threshold

    Excel exports are intended for relatively small exports, fewer than 500,000 cells, while CSV can handle larger exports.

    Whenever you export to Excel and the resultant spreadsheet has more than 500,000 cells (by default), the export process stops and you are given the Excel file at that point. In the bottom row, there will be the following message: Export stopped due to excessive size. Use CSV for a complete export:
    Figure 1. Excel export threshold
    Excel export threshold
    The Excel export cell threshold is customizable using the glide.xlsx.max_cells integer property (or glide.excel.max_cells if using XLS).
    Note: Increasing this threshold may cause a memory issue in your instance. The threshold is set at an appropriate level to prevent resource issues.

    The export will put the information into the Excel document with 32,000 rows per spreadsheet.

    Tags:

    Feedback
    On this page

    Previous topic

    Next topic

    • Contact Us
    • Careers
    • Terms of Use
    • Privacy Statement
    • Sitemap
    • © ServiceNow. All rights reserved.

    Release version
    Choose your release version

      Export limits

      • Save as PDF Selected topic Topic & subtopics All topics in contents
      • Unsubscribe Log in to subscribe to topics and get notified when content changes.
      • Share this page

      Export limits

      The platform provides a default upper limit for data exports.

      The purpose of the upper limit is to avoid creating performance issues when a table is excessively large. If you need to export more records than the threshold permits, Break up a large export into separate manageable chunks.

      Export limit properties

      You can set the number of records to return during an export using the sysparm_record_count URL parameter.

      However, the system analyzes the following settings to determine whether an export limit should be applied.
      1. First, the platform checks the property that defines the format-specific export limit (see table below). Each format can have a different limit. Although this property can be set to any value, exceeding the default export limit can impact system performance. You may want to set the property at or below the default limit and have users Break up a large export to export large amounts of data.
      2. If the format-specific property is not set, the system checks the property for the general export limit (see table below). This property can also be set to any value, but exceeding the default export limit can impact system performance.
      3. If neither the format-specific export limit nor the general export limit property is set, the system enforces the default export limit (see table below).
      Important: To set these properties, navigate to System Properties > Import Export.
      Table 1. Default export limit
      Format Format-specific export limit General export limit Default export limit
      XML glide.xml.export.limit glide.ui.export.limit 10,000
      CSV glide.csv.export.limit glide.ui.export.limit 10,000
      EXCEL (XLSX) glide.xlsx.export.limit glide.ui.export.limit 10,000
      EXCEL (XLS) glide.excel.export.limit glide.ui.export.limit 10,000
      EXCEL (XLSX) glide.xlsx.max_cells N/A 500,000
      EXCEL (XLS) glide.excel.max_cells N/A 500,000
      PDF glide.pdf.max_rows
      Note: The number of rows can be set from 0 to 5,000. If no value is specified, the default is 1,000. If a value greater than 5,000 is specified, the default value of 1,000 is used.
      N/A 1,000
      PDF glide.pdf.max_columns
      Note: Although the number of columns can be set higher than 25, this is not advisable,since only 25 header labels fit on a page.
      N/A 25
      JSON glide.json.export.limit glide.ui.export.limit 10,000

      A warning threshold property called glide.ui.export.warn.threshold controls how the records are exported. If a user attempts to export a number of records from a List export that exceeds the warning threshold, a dialog box offers the choice of waiting for the export to complete or having the exported records emailed as an attachment. The warning threshold can be changed in the system property. The email attachment must not exceed the maximum allowed Email size limits.

      Table 2. Export limit examples
      Example Property Table Note
      Exporting to CSV
      • glide.csv.export.limit = 20,000
      • glide.ui.export.limit = 10,000
      • com.glide.processors.XMLProcessor.max_record_count = 20,000
      • Default export limit for CSV = 10,000
      Table 3. Exporting to CSV
      Records to be Exported Records Returned
      15,000 15,000
      30,000 20,000
      In the second export, the number of records returned from the database is limited because the number of records specified for export exceeds the value set in the glide.csv.export.limit property.
      Exporting to Excel (XLSX)
      • glide.xlsx.export.limit = no entry
      • glide.ui.export.limit = no entry
      • Default export limit for Excel (XLSX) = 10,000
      Table 4. Exporting to Excel
      Records to be Exported Records Returned
      10,000 10,000
      30,000 10,000
      In the second export, the number of records returned from the database is limited because the number of records specified for export exceeds the default export limit for Excel, 10,000 records.
      Exporting to PDF
      • glide.pdf.max_rows = 1,000
      • Default export limit for PDF = 1,000
      • Maximum export limit for PDF = 5,000
      Table 5. Exporting to PDF
      Records to be Exported Records Returned
      1,000 1,000
      5,000 1,000
      In the first export, all records are returned because the number of records specified for export does not exceed the glide.pdf.max_rows property. In the second export, the number of records returned is limited because the number of records specified for export exceeds the default value in the glide.pdf.max_rows property.

      Excel export threshold

      Excel exports are intended for relatively small exports, fewer than 500,000 cells, while CSV can handle larger exports.

      Whenever you export to Excel and the resultant spreadsheet has more than 500,000 cells (by default), the export process stops and you are given the Excel file at that point. In the bottom row, there will be the following message: Export stopped due to excessive size. Use CSV for a complete export:
      Figure 1. Excel export threshold
      Excel export threshold
      The Excel export cell threshold is customizable using the glide.xlsx.max_cells integer property (or glide.excel.max_cells if using XLS).
      Note: Increasing this threshold may cause a memory issue in your instance. The threshold is set at an appropriate level to prevent resource issues.

      The export will put the information into the Excel document with 32,000 rows per spreadsheet.

      Tags:

      Feedback

          Share this page

          Got it! Feel free to add a comment
          To share your product suggestions, visit the Idea Portal.
          Please let us know how to improve this content

          Check any that apply

          To share your product suggestions, visit the Idea Portal.
          Confirm

          We were unable to find "Coaching" in Jakarta. Would you like to search instead?

          No Yes
          • Contact Us
          • Careers
          • Terms of Use
          • Privacy Statement
          • Sitemap
          • © ServiceNow. All rights reserved.

          Subscribe Subscribed Unsubscribe Last updated: Tags: January February March April May June July August September October November December No Results Found Versions Search preferences successfully updated My release version successfully updated My release version successfully deleted An error has occurred. Please try again later. You have been unsubscribed from all topics. You are now subscribed to and will receive notifications if any changes are made to this page. You have been unsubscribed from this content Thank you for your feedback. Form temporarily unavailable. Please try again or contact  docfeedback@servicenow.com  to submit your comments. The topic you requested does not exist in the release. You were redirected to a related topic instead. The available release versions for this topic are listed There is no specific version for this documentation. Explore products Click to go to the page. Release notes and upgrades Click to open the dropdown menu. Delete Remove No selected version Reset This field is required You are already subscribed to this topic Attach screenshot The file you uploaded exceeds the allowed file size of 20MB. Please try again with a smaller file. Please complete the reCAPTCHA step to attach a screenshot
          Log in to personalize your search results and subscribe to topics
          No, thanks Login