Tip: If you're looking to export data from Snitcher into another Tool, Platform or CRM system, please have a look at our Integrations instead. You might also want to check out the API (please get in touch with support for more details and your key).
Snitcher allows you to export leads-data in a CSV, Excel and LinkedIn campaigns formats.
First up, select the Segment containing the leads you want to export (this includes 'All Companies'.
Next, select your desired export format. You’ll then see a pop-up in the dashboard. You can export data in two ways:
Export selected columns – Select or add the specific columns you want to include.
Export all columns – All available columns will be included in the export.
💡 Exporting may take a few minutes, but you’ll receive an email once the file is ready to download.
What's in your export?
The four export formats
The export menu gives you four options, and they don't all produce the same file.
Menu item | File you get | Columns |
Export as CSV | A | The columns you chose, see below |
Export as Excel file | An | Identical to the CSV. Same columns, same values, only the file type differs |
Export as LinkedIn campaign | A | A fixed 10-column layout built for LinkedIn Matched Audiences |
Export for Sales navigator | A | A fixed 5-column layout for Sales Navigator account lists |
The two LinkedIn formats ignore your column selection and use their own layouts, because both tools expect a specific set of headings.
Export as LinkedIn campaign gives you these columns, in this order: companyname, companywebsite, companyemaildomain, linkedincompanypageurl, stocksymbol, industry, city, state, companycountry, zipcode.
A few things about that file:
stocksymbolandzipcodeare always empty. They're there because LinkedIn's upload template expects the columns, and Snitcher doesn't hold those values.companywebsiteandcompanyemaildomainhold the same value, one with thehttp://orhttps://prefix removed.linkedincompanypageurlis the company's LinkedIn page, and is empty where we don't have a LinkedIn handle for that company.
💡 For what to do with that file once you have it, see How to send Snitcher leads to LinkedIn for retargeting.
Export for Sales navigator gives you five columns, in this order: Account Name, Linkedin Company URL, Website URL, Country, City.
Export selected columns vs Export all columns
The export dialog opens on two tabs, and the difference between them catches people out.
Export selected columns starts from the columns currently visible in your companies table and matches them one for one. From there you can add or remove any of the 43 available fields using Add another column. This is the only way to reach 16 of those fields.
Export all columns does not use your selection. It produces a fixed layout of 27 columns, or 26 if your plan doesn't include contact reveals. That has been the standard export layout for a long time, and it is not all 43 fields.
So if a field you want is missing from your file, the usual reason is that you used Export all columns and the field is one of the 16 that only appears on the other path.
Those 16 are ICP Fit, Tags, Technologies, Founded, Funding, Funding Stage, Revenue, Instagram, and the UTM fields: First UTM Source, Medium, Campaign, Term and Content, plus All UTM Sources, Mediums and Campaigns.
The two paths also use different headings for some of the same fields, which is the usual reason a column name looks different from your last export. Company name is Company on one path and Name on the other, domain is Domain or Website, employee count is Employees or Company Size.
For every field, both of its headings, and what each one contains, see [What's in your Snitcher export? What Every Column Contains](\[LINK - add once the reference article is published\]).
Why your file can have fewer rows than the screen showed
This comes up often and it isn't data loss. Three things cause it, and they can stack.
The counts next to your segments aren't live.
👉 All Companies and Trash are recalculated every 15 minutes, and your own saved segments every 6 hours.
Anything identified since the last recalculation is already in the export but not yet in the number beside the segment name.
The total above the list is only partly filtered.
👉 When you open a segment, Snitcher screens out deleted and merged companies from the first 350 results, for speed. The export screens the whole result set.
On any segment with more than 350 companies, the export can legitimately hold fewer rows than the number on screen.
👉 Companies with no company record are skipped.
If a company was identified but has no company profile attached, it isn't included.
The net effect is that the exported row count is normally the same as, or lower than, the number on screen, and the gap grows with the size of the segment.
Limits, and when to use the API instead
There's no row limit. Large exports are processed in slices that pick up where they left off, which is why a big export takes a few minutes. The email arrives once the whole file is ready.
Multi-value columns are capped at 100 entries per company. That applies to Unique Pages Visited, All Referrers, Unique Campaigns, All UTM Sources, All UTM Mediums, All UTM Campaigns and Unique Visitor Locations. Anything beyond 100 is left out without a marker.
You can run 5 exports per minute.
The Exports page in your settings keeps your 10 most recent exports. Each one has a retry option, so if you need a file again, use retry to generate a fresh copy rather than relying on an old download link.
Downloading requires being signed in to a workspace you have access to. The link in the email isn't public.
The REST API is usually the better answer when:
You need the data on a schedule, or inside your own system, rather than as a one-off file.
You need more than 100 pages, referrers or campaigns per company.
You're building an ongoing sync, though in that case a direct integration is usually better than either.
The API returns companies from /v1/workspaces/{workspaceUuid}/organisations, paginated up to 1000 per page, with a default limit of 600 requests per minute, and it accepts the same advanced filters you use for segments.
As always, please drop us a message to say hello, talk through ideas or get some help. Team Snitcher signing off 👋