Exporting Flows' content to a CSV from the Project Home

You can export all the content collected by your Flows to a CSV File. 

This report is downloaded as a compressed file (.gz format) that you need to decompress and then import to an Excel sheet, Google Spreadsheet, or Numbers (Mac), among others.

Exporting content to CSV

From the Project Home go to the Flows list and select the one you want to export to CSV.

(1) Specify a time range to narrow your search. It is possible to export posts with a time range equal to a single day.

(2) Choose between the following two export types: 

  • All Content (Including the text posts. Imported archives do not include media content)
  • Audience (You will get unique users and not repeated users)

(3) Select the content status to export only the content that is:

  • Pending
  • Accepted
  • Rejected

You can select all of them or any combination.

(4) Click on Export.


Decompressing a CSV file

  • To decompress a CSV file, you can use 7-Zip (for Windows). Download it free here.  
  • After downloading and decompressing the CSV, check out the Importing a CSV file into an Excel sheet article to avoid having weird characters on your worksheet.

What kind of content will I get?

If you choose to export All Content, you will get the following:

Id Post Id
Publisher Twitter / Instagram / Facebook / YouTube / WhatsApp
Date Date and time the post was made. Time in UTC
Text Post text
Device Web / iOS / Android
Is Retweet True / False
Retweeted Count Number of times the post was rt-ed
Time Zone Is the browser's day
Location Post's latitude and longitude if it comes geolocalized
Author Name Author's full name
Account @handle
Reference Post URL
Action Post Status:  Accept / Pending / Reject


If you choose to export Audience, you will get the following:

Id User Id
Publisher Twitter / Instagram / Facebook / YouTube / WhatsApp
Date Date and time the post was made
Text Post text
Device Web / iOS / Android
Is Retweet True / False
Retweeted Count Number of times the post was rt-ed
Time Zone Is the browser's day
Location Post's latitude and longitude if it comes geolocalized
Author Name Author's full name
Account @handle
Reference Post URL
Action
Post Status:  Accept / Pending / Reject

 

Was this article helpful?