Export to CSV

Export data out of Lexer to use in other tools, cut it up your own way, and find new insights

The export feature allows you to get your hands on the data behind the charts, streams of content, and tables. Using export will prepare a file specific to your search, and return it to you as a CSV file, which is a common format for importing into other programs such as Microsoft Excel, or Google Sheets.

Search Using Your Deep Dive, and find Mentions using the Live Stream, then export your results to CSV.

Exports appear on most charts, providing different data for each. Exports are made apparent with the presence of the down arrow in the top right corner of each chart. Charts will generate an export for the data they represent.

Some examples of different exports are:

Data to Export

Location of Export

Social media content

Export from the 'Mentions' table in Listen.

Influencer lists

Export from the 'Top Authors' chart in Listen.

Geolocation of customers

Export from the heat map in the 'Location' page in Listen.

Every interaction your team have had

Export from the 'SLA' report in Activity.

Every start to finish conversation your agents have had

Export from the 'Cases' report in Activity.

Why are the dates wrong on my export?

Lexer’s native timezone is UTC. UTC is generally in sync with GMT, so it’s good to use this as a guide.

Any exported data is automatically converted to UTC. So if you’re based in Melbourne, for example, the time will appear to be out by +10 hours.

Simply adjust the time accordingly with a formula, and you’ll have the time and dates converted to your local time.

To apply this, create a new column in your spreadsheet alongside that which contains the current timestamps. Then apply the below formula (assuming cell A2 on your spreadsheet is the date/time) to the first cell, and drag down to apply to the whole column:

=A2+TIME(10,0,0)

This formula doesn’t account for Daylight Savings Time, so it’s best to look up the current difference between UTC/GMT and your local time.

Powered by HelpDocs (opens in a new tab)