GoHighLevel to Excel, CSV and JSON: every export and its limits

GoHighLevel to Excel works through CSV files. HighLevel has a built-in export for contacts, companies, opportunities, transactions, orders, form and survey submissions, email statistics and call reporting, and each one produces a CSV that Excel opens. Some download in the app; payments and submission exports arrive as an emailed link that expires after 7 days. For JSON, use HighLevel's API 2.0 or a webhook workflow action. No export button produces JSON.

By the ยท first published

Updated

GoHighLevel export facts

From HighLevel's help center, changelog and Microsoft support, checked November 8, 2026
FactDetailSource
File formatCSV for every export in HighLevel's help center; no .xlsx export is documentedhelp.gohighlevel.com
Contacts columnsOnly the columns visible in the table (set them in Manage Fields first)help.gohighlevel.com
Contacts notesOnly the latest note, cut at 255 characters; automation history is not exportedhelp.gohighlevel.com
Payments exportsEmailed as a download link that works for 7 dayshelp.gohighlevel.com
Form and survey exportsEmailed CSV, downloadable for 7 days; chat widgets and lead forms not supportedideas.gohighlevel.com
JSONComes from API 2.0 responses or webhook workflow actions, not from an export buttonhelp.gohighlevel.com
Excel sheet size1,048,576 rows by 16,384 columnssupport.microsoft.com

Every built-in GoHighLevel export

CSV exports documented in HighLevel's help center and changelog (checked November 8, 2026)
DataWhere to exportHow the file arrivesWho can export
ContactsContacts > Smart Lists, select, then More > ExportDownload from Contacts > Bulk Actions; kept 30 daysAdmin users export; agency and location admins download
CompaniesContacts > Companies, three-dot menu > Export (or select rows > Export)Download from the progress windowUsers whose role has company export access
OpportunitiesOpen an opportunity Smart List, Menu (three dots) > ExportCSV download of the records in that Smart ListNot stated
TransactionsPayments > Transactions, filter, Download iconEmailed link, valid 7 days, only for the user who askedView transactions plus export permission
OrdersPayments > Orders, filter, DownloadEmailed link, valid 7 daysView Orders and Export Orders
Form and survey submissionsSubmissions view, Export button (one form or all forms)Emailed link, about 5 minutes; file lasts 7 daysNot stated
Email statisticsMarketing > Emails > Statistics, pick type and dates, ExportEmailed link, valid 30 daysNot stated
Call reportingCall Reporting tab, choose the columns to includeCSVNeeds the Agency Pro plan
Sub-accounts list (agency)Agency view > Sub-Accounts, filter, Export ReportEmailed to chosen recipients, usually 7 to 10 minutes; link lasts 7 daysNot stated

A changelog entry on enhanced CSV exports also covers subscriptions under Payments, with tax breakdowns, product line items and separate columns for amount due and amount paid. No help article for exporting conversations, tasks or custom dashboard reports turned up as of November 8, 2026.

What each export includes, and what it leaves out

None of these exports can be scheduled. For a sheet that fills itself, see GoHighLevel to Google Sheets. For dashboards, see GoHighLevel to Power BI, GoHighLevel with Looker Studio and GoHighLevel to BigQuery.

Opening a GoHighLevel CSV in Excel

Double-clicking a CSV makes Excel guess each column's format. Microsoft warns that this can strip leading zeros from numbers and misread date order. Importing gives more control:

  1. In Excel, open the Data tab and click From Text/CSV in the Get & Transform Data group.
  2. Pick the exported file and click Import.
  3. Check the delimiter in the preview, then click Transform Data to set columns such as phone numbers or ZIP codes to text.
  4. Click Load to put the data on a new sheet.

An Excel sheet holds 1,048,576 rows and 16,384 columns, and a cell holds up to 32,767 characters, per Microsoft's limits page. A larger contacts export has to be split or loaded into Power Query or Power BI instead.

Getting GoHighLevel data as JSON

From the API. HighLevel's API 2.0 returns JSON. Create a Private Integration token with read-only scopes and send it as Authorization: Bearer plus a Version header. Contact search returns up to 500 contacts per request; page numbers stop at 10,000 records, after which the searchAfter cursor takes over. The rate limits are 100 requests per 10 seconds and 200,000 per day for each sub-account, and going over returns HTTP 429.

Into Excel without code. Excel's Data > From Web uses the same Power Query Web connector as Power BI. Its Advanced option takes extra request headers, and Power Query turns the JSON into a table.

From workflows, as events happen. The Webhook action sends a POST by default with the contact's fields, tags and custom fields, location data, and the appointment, opportunity or task when the trigger supplies one. The Custom Webhook action supports GET, POST, PUT and DELETE, and can send an application/json body built from workflow values. Both show their results in the workflow's Execution Logs.

Exports and the API also matter when leaving HighLevel: it deletes account data 90 days after cancelling (see how to cancel GoHighLevel). For help moving records between systems, compare GoHighLevel migration agencies. Accounting records can sync instead through the GHL QuickBooks integration.

Frequently asked questions

How do I export GoHighLevel data to Excel?

Use the export in the part of HighLevel that holds the data, such as Contacts, Opportunities or Payments. Every export HighLevel documents is a CSV file. In Excel, open it with Data > From Text/CSV so columns such as phone numbers keep their format.

Can GoHighLevel export directly to an .xlsx file?

HighLevel's help center only documents CSV exports, for contacts, companies, opportunities, transactions, orders, form and survey submissions, email statistics, call reporting and the agency sub-accounts list. Excel opens CSV files, and they can be saved as .xlsx from there.

Why is my GoHighLevel contacts export missing columns?

The contacts CSV only includes the columns shown in the Contacts table. Add the missing fields in Manage Fields before exporting. Notes are limited to the latest note, cut at 255 characters, and message history is not included.

Why does one GoHighLevel transaction show up on several rows?

The transactions export writes one row per product and per tax on that product, plus rows for fees and tips. Full transaction details appear on only one row, so totals should not count each row as a separate transaction. Orders work the same way and share an internal order ID.

How do I get GoHighLevel data as JSON?

Call HighLevel's API 2.0 with a Private Integration token; its responses are JSON. To push data out as events happen, use the Webhook or Custom Webhook workflow action, which can send a JSON body to any URL.

How long do GoHighLevel export files stay available?

It depends on the export. Contacts exports stay in Bulk Actions for 30 days. Transactions, orders, form submissions and the sub-accounts list use emailed links that last 7 days. Email statistics links last 30 days. After that, run the export again.

Sources

All checked November 8, 2026.