Weekly pipeline export checks for 4 vendors

Before you file this week’s pipeline review, check the specific export constraints for your sales tool. HubSpot, Pipedrive, and Close set different download windows, and Microsoft caps a dynamic worksheet at 100,000 rows at a time.

• HubSpot: Download links to export files will expire after 30 days, according to HubSpot. You can complete up to 300 exports within a rolling 24 hour window, and up to three exports simultaneously, according to HubSpot.
• Pipedrive: Exported files are available for 28 days, according to Pipedrive.
• Microsoft: You can export up to 100,000 rows at a time, according to Microsoft.
• Close: For your privacy, the link will expire automatically after 7 days, according to Close.

Use these time windows to decide when to save your local copy.

Check your export permissions and the specific record types included before you start. Some exports include associations, while others require separate actions for activities or files. Check HubSpot’s multiple-file row thresholds and Microsoft’s limit of 100,000 rows at a time before you export.

Your weekly pipeline review requires a file that matches the exact records and columns you discussed. If you use a dynamic worksheet, the file updates when you refresh it in Excel after changes occur in the app, according to Microsoft. This behavior means the file you reviewed last week may show different numbers if you refresh it today. To preserve the specific state of the pipeline for your records, you need to distinguish between a file that pulls live data and a static copy you keep for reference.

The core risk is mistaking a refreshed file for an unchanged snapshot. If you refresh an Excel dynamic worksheet after you change data in the app, you get the latest information from the app, according to Microsoft. Therefore, matching the export scope to the review involves selecting the correct records and fields before you generate the file. You must verify that the columns in your export align with the metrics you track, such as stage, amount, and close date. See Open, won, and lost stage rules in 4 sales tools and Close date change log: why the date moved.

Saving the dated file is the final step in protecting your historical accuracy. If you need a record of what the pipeline looked like on a specific Tuesday, you must save a copy that does not update automatically. This editorial recommendation is to treat any refreshable file as a live view and any saved, non-refreshable file as a historical snapshot.

The table below lists the specific export rules for HubSpot, Pipedrive, and Close. Each row covers permissions, included records and associations, file limits, and download expiry where documented.

Microsoft’s dynamic worksheet export is limited to 100,000 rows at a time. The table reflects only the documented rules. For HubSpot, the association limit of one thousand ID values in each association column is a specific constraint to note when reviewing linked records. Pipedrive’s requirement for global admin permissions for data-type exports is a distinct access rule compared to the other publishers listed. Close’s designation of JSON for large-scale and activity exports highlights a format-specific capability not mentioned for the other vendors.

Check your user role against Pipedrive’s admin requirement before attempting a data-type export. Verify your column count against HubSpot’s 256-column XLS limit if using that format. Confirm you are using JSON for Close if you need to include all activity types. These checks ensure the export scope matches your review needs.

Before downloading, define exactly which records and fields belong in the weekly review. In "Export your records," the system downloads the current property values and associations for the selected items according to HubSpot. This includes the linked data present at the moment of export. Verify that your filter captures the specific deals and contacts needed for the forecast meeting (Weekly deal review filters across 4 sales systems). If a record is missing from the file, check whether the filter excluded it or if the association was not yet established in the system.

In "Exporting data from Pipedrive," apply your filter first, then click the gear icon to choose which columns to include according to Pipedrive. This step lets you trim the file to the fields relevant to the review. However, note that activities, notes, and files linked to deals and contacts must be exported separately according to Pipedrive. If your review requires activity history or attached documents, plan for a second export file. Do not assume the main deal export contains these linked items.

For "Exporting data," the built-in exporter covers leads, contacts, opportunities, and activities according to Close. This means the main export can include activity records alongside the core objects. However, exporting opportunities from the leads page will return opportunities that belong to leads matching the given search criteria according to Close. If you need opportunities independent of lead search criteria, verify the export source.

Write down the exact filter and columns for this week’s pipeline review, then compare them with the header row of a file you already have. This check confirms that the export scope matches the review needs before you rely on the file for the forecast discussion.

When you select a file format for your weekly pipeline review, specific numerical boundaries determine whether your data remains intact or gets split. These constraints vary significantly between vendors and file types, so you must verify them against your current record count before initiating the download.

For HubSpot, the "Export your records" documentation outlines specific thresholds where the system generates multiple files instead of a single document. According to HubSpot, multiple files are expected when exporting CSV or XLSX files with more than 1,000,000 rows. The same source notes that this multi-file behavior also applies to XLS files when they contain more than 65,535 rows. If you exceed them, you must account for multiple files in your filing process.

Column limits also differ by format within HubSpot. According to HubSpot, there is a limit to the number of columns that can be exported, specifically 256 for XLS files and 16,384 for XLSX files. If your selected column set exceeds the 256-column limit for XLS, the export will not include all requested fields in that format. Choosing XLSX allows for a much wider column range, which may be necessary if your review includes numerous custom fields or associated data points.

Microsoft’s "Export to an Excel dynamic worksheet in model-driven Power Apps" documentation provides a different constraint for its dynamic worksheet feature. According to Microsoft, you can export up to 100,000 rows at a time. This limit applies specifically to the dynamic worksheet export method. If your pipeline view contains more than 100,000 records, you cannot export them all in a single dynamic worksheet action. You must either filter the view to reduce the row count below this threshold or use a different export method if available in your specific setup.

When you export data to an Excel dynamic worksheet and then make changes to your data in the app, you can use the refresh feature in Excel to get the latest information from the app, according to Microsoft. This behavior means the file you opened last week is not a static record of that week’s numbers; it is a live view that updates when you tell it to. If your goal is to preserve the exact state of the pipeline as it existed during a specific review meeting, a dynamic worksheet is the wrong tool for that purpose. The refresh feature is designed for keeping a working file current, not for archiving a point-in-time view.

To distinguish between a working file and a historical record, treat the dynamic worksheet as a temporary workspace. It reflects the app’s data at the moment you last refreshed it, not at the moment you first exported it. If you need to compare this week’s pipeline against last week’s, you cannot rely on the dynamic worksheet to hold last week’s values once you refresh it.

For this reason, create a separate, dated saved snapshot for each weekly review. Save a static copy of the export—such as a CSV or a non-dynamic Excel file—immediately after you generate it. Name the file with the date of the review. This file will not change when the app data changes. It remains a fixed record of the data as it appeared at the time of export.

The date and time values that you see in the app show up only as Date when you export the file to Excel, but the cell actually shows both the date and time, according to Microsoft. This means that if your review depends on precise timing, the visual representation in the spreadsheet may not match what you see in the app interface. Check the underlying cell value if you need to verify the exact timestamp, rather than relying solely on the displayed format.

You export 10 columns and 50 rows, save a dated copy, and keep a second file for refreshes. After 4 amounts change, you refresh only the working file. The dated copy still shows the 50 rows from the review.

The time you have to retrieve an export file varies significantly by vendor, so verify the expiration window immediately after generating the file. In HubSpot’s "Export your records" feature, download links to export files will expire after 30 days, according to HubSpot. While the file link remains valid for that duration, the historical record of the export itself persists longer; historical exports remain visible in your export log for 3 years then they will be automatically removed, according to HubSpot. If you are managing multiple data pulls, note that you can complete up to 300 exports within a rolling 24 hour window, and up to three exports simultaneously, according to HubSpot.

Pipedrive operates on a shorter timeline for file availability. In its "Exporting data from Pipedrive - Knowledge Base | Pipedrive" documentation, exported files are available for 28 days, according to Pipedrive. This means you must download and archive the file within that four-week window to retain a local copy.

Close has the most restrictive expiration period for the download link itself. In the "Exporting data | Close Help Center" guide, the link will expire automatically after 7 days for privacy reasons, according to Close. Because this window is the shortest of the three vendors, you should treat the download as an immediate task rather than a deferred one.

Write down the exact date the export was generated and the vendor’s expiration limit. Set a reminder for the day before the link expires to confirm the file has been saved to your local archive. This prevents the scenario where a link appears in your history but no longer functions, leaving you without the specific snapshot you need for the weekly review.

Does an export contain activities and notes?

Pipedrive requires you to export activities, notes, and files linked to deals and contacts separately from the main data, as noted in their "Exporting data from Pipedrive" documentation Pipedrive. In contrast, Close includes all Activities, such as emails, calls, SMS messages, notes, and custom activities, when you use the JSON format for large-scale exports Close. Check your specific vendor’s documentation to determine if these items are bundled or require separate actions.

Which fields are included by default?

HubSpot includes only the properties and associations present in the selected view by default, according to their "Export your records" guide HubSpot. For associations, this includes up to one thousand associated record ID values in each association column along with the associated record name HubSpot. Verify your view settings before exporting to ensure the necessary columns are visible.

When does the export download link expire?

Pipedrive states that exported files are available for 28 days, according to their "Exporting data from Pipedrive" knowledge base article Pipedrive. Download your file within this window to avoid losing access to the specific snapshot you generated. Confirm the retention period for your specific platform if it differs from Pipedrive’s stated timeframe.

Can an Excel refresh change the numbers I reviewed last week?

Yes. Microsoft explains that when you export data to an Excel dynamic worksheet, you can use the refresh feature to get the latest information from the app after making changes Microsoft. Save a separate dated copy if you need to preserve the exact figures from a previous review.

What happens when an export exceeds the file format’s limits?

HubSpot expects multiple files for CSV or XLSX exports with more than 1,000,000 rows and for XLS files with more than 65,535 rows, according to HubSpot. Column limits are 256 for XLS and 16,384 for XLSX, according to HubSpot.