Exporting your survey responses through SFTP

The Secure File Transfer Protocol (SFTP) is a network protocol that enables secure 1-1 file transfer and access, at large volumes. With inbuilt data encryption, SFTP safeguards sensitive information against unauthorized access. It’s a go-to solution for highly regulated industries that deal with huge amounts of sensitive information, like healthcare and finance.

SurveySparrow has native support for SFTP, allowing users to import contacts and export responses. In this article, we’ll explain how you can export your survey responses to an SFTP server, on a one-time or recurring basis.

Open the survey whose responses you wish to export. The Results section appears by default. Then click on the Responses tab.

Click the Share button in the upper right part of the page.

When the Share Options panel opens from the right, click on SFTP under More ways to export responses at the bottom.

The Create new export page opens, where you’ll have to configure the export conditions. Let’s start with Export Frequency. If you want to export responses just once, stick to the default One-time option. If you want to set up a repeating export, click on Recurring.

Then, select the export cadence (daily/weekly/monthly), and fix the time and timezone.

If you wish to have someone in your organization notified about the export, click the toggle next to Notify when export is scheduled. Then type in their email address.

By default, all of your responses will be exported. However, if you wish to set criteria to export a specific set of responses, click on Add Filters. You can choose from 3 types of filters: Status, Share Channel and Questions. Let’s explore each filter briefly.

In the status filter, you can choose either Completed or Partially Completed responses.

In the share channel filter, you can choose between 9 options.

Note: The supported channels are:

• Link share
• Embed share
• System share
• Slack share
• Facebook share
• Email share
• SMS share
• Twitter share

Note: There’s no limit to the number of versions of a share channel that can be added as filters.

In the question filter, you can choose 1 or more of the survey questions.

After setting up your filters, you have to set up the SFTP Connection. Click on Choose under SFTP Connection. If you have already created a connection, it will appear in the drop-down menu. If not, click Create a new connection.

Add the details of the connection, then click on Save connection.

After the connection is authenticated, you need a folder in the server to store the response export. You can choose an existing folder or create a new folder. Let’s learn how to use an existing folder. Start by clicking on Choose folder.

You will see a master folder. If you wish to see the inner folders and sub-folders, click on the plus icon to the left of its name. You can also use type in the search box to find the required folder.

Once you’ve chosen the folder to export responses to, click on it, then click on Select.

If you would like to create a new folder instead, click on Add folder.

You will see a master folder. To create a folder within it, click on it, then select Add folder.

Note: If you want to create a folder within one of the inner folders or sub-folders, click on the plus icon to the left of the master folder’s name to see them all.

Then type in the name of the new folder and click on Save. The new folder is ready!

The default naming convention of an export is date_survey name, where the date follows the order dd-mm-yyyy. If you would like to change the date format, click on the date variable under File name and choose from the options in the drop-down.

Tip: The File name field is an editable text box, allowing you to completely change the name as per your liking. However, we recommend that you keep the date variable, since it will allow you to distinguish between different export files.

The final configuration step is to choose your file format, either CSV or JSON. Once confirmed, click on Schedule Export.

You will enter the Manage Exports page, where you can see your export scheduled. 

To pause it, turn off the toggle at the left end.

If you wish to edit it or delete it altogether, click on the 3-dot icon at the right end.

If you wish to repeat the process, click on New Export in the top right corner.

To view previous exports, you can click on the Completed tab.

Using SFTP, you can store your survey responses with complete safety and efficiency. Automate exports and keep your data fresh and accessible, without compromising on security.

Feel free to reach out to our community, if you have any questions.