Export data

From Documentation
Jump to: navigation, search

Most of the lists in the software allow you to send the data to the external file.

At the moment, the following output file formats are supported:

  • Plain text file (.txt)
  • Microsoft Excel workbook (.xls)

We will take the list of E-mail accounts for example. Exporting from other lists is very similar. To start exporting, click on the "Export/import data" button on the toolbar of the list that you need to export, and select "Export data" there.

A new wizard window will open, asking for the file format:

Wizard export 1.png

Exporting to text file

Select Export to text file option on the first page of the wizard and click Next.

Wizard export 2.png

On this page, you can specify what fields you want to export and in which order/format. This article explains in great detail how to do that using Export templates

If you just need a simple file with E-mail account addresses and passwords separated by colon, then you can use the default export template, as shown on the screenshot above.

Click Next.

Wizard export 3.png

This is the last page of the wizard, it allows you to tell the software which rows to export, where to export them and what to do after the export is complete.

Here you can:

  • Select a particular output file. The data will be sent to this file. Click on "Select file" button to do that. By default, the software selects the file name and location automatically, using its working directory in your Windows user profile folder, and names the file after today's date and time.
  • Select rows to export. You have the following options:
    • All records. Every single line in the list will be exported. If your list is filtered or sorted, all of these settings will be applied. In other words, you will get in your export file exactly what you see in the list on your screen. So, for example, if you have the list sorted alphabetically by E-mail addresses, then in the output file they will also be sorted.
    • Selected records. The output file will contain only selected rows. They will be exported in the same order they appear in the list.
  • Have the software automatically open output file after the export is complete. The file will be opened using the default application registered for the corresponding file type in Windows. For example, Windows Notepad will oped for the text files, and Microsoft Excel - for Excel files.
  • Export field names. This option allows to send field names to the first line of the export file

Once you click Next, exporting will start.

Wizard export 4.png

If there problems during the export, you will see them in the log on the above page. Otherwise, the export is complete and your output file now contains the data you need. If you asked the software to open the file after export is complete, you should see your exported data right away

Exporting to Excel file

Select Export to Excel option on the first page of the wizard and click Next.

Exporting to Excel is very similar to text file exporting. The only difference is that instead of Export template page, you will get see this:

Wizard export 5.png

On this page, you can select the ordering of fields in the Excel worksheet, and de-select the fields that you do not need.

When finished here, click Next. The remaining steps are identical to those listed in the Exporting to text file section