Import data

From Documentation
Jump to: navigation, search

Many lists in the software allow you to import data from external sources, such as text file or Excel worksheet.

This may be useful if you want to upload the data from another software, or just have a list of existing accounts/proxies/E-mails etc. that you do not feel like inputting manually.

We will explain Import feature step by step using proxies as an example. If you need to import E-mails or other data - the procedure is almost identical, the only difference is the list of fields that your input file contains. Therefore, it makes sense to study the examples below even if you need to import E-mails and not proxies.

Importing from the text file

Assuming that you have a plain text file that looks like this:

11.22.33.44:3128
22.33.44.55:3128
33.44.55.66:3128

It is important to check that you have a plain text file, and not a Microsoft Word, PDF, HTML or any other complex formats. The easiest way is to open Windows Notepad (you can find it under All programs -> Accessories in your Windows OS) and try to load your file. If you see nice looking list with each item appearing on a separate line - then you can be sure that you have a plain text file. Otherwise, you need to find a way to copy your information to the text file. With Microsoft Word, you can select "Save as" as choose "Text file" as a file type, for other formats you may be able to copy the contents to the clipboard and then paste it into the Notepad.

Now you can go to the list of proxies in the software, click the "Export/Import data" button on the toolbar, select "Import data" from the drop down, and you should see this:

Wizard import 1.png

Select "Import from text file" and click Next:


Wizard import 2.png

On this page, you can either load your text file using the Select file button (if you have the file on disk), or just paste the contents in the box. On the picture above we pasted the data. Again, click Next.


Wizard import 3.png

Here you may adjust Import template if needed. You can read more about the templates here. The one on the screenshot is OK for our sample text file, so we just click Next


Wizard import 4.png

This screen lets you specify additional options. These options are specific to proxies, other lists may show different options. If you are not sure what these are for - just leave them as is and hit Next, the software will use the default values that work in most cases.


Wizard import 5.png

Finally, the last page! It shows that the import was successful and 3 proxies we have on the list were imported. If you check the list of proxies in the software - you should see 3 new items!


Importing from the Microsoft Excel worksheet

The process is very similar to text file import, so we will just focus on the differences:

<cl> 1. The main difference, of course, is that you need to have an Excel file. The only Excel format supported at the moment is MS Excel 97-2003 (filenames with .xls extension). If your file is in the newer .xlsx format - you can easily convert it using the Save As... feature of Microsoft Excel. Select MS Excel 97-2003 in the File type drop down to do that.

  • It is advised to have your Excel worksheet formatted in such a way that first row contains the names of the fields, and the next rows contain field values, below is the example:
ip port
11.22.33.44 3128
22.33.44.55 3128
33.44.55.66 3128
  • When importing, instead of Import Template page in the wizard, you will get field mapping page, that will allow you to select which column contains which field. If you have the fields named like advised above, then the wizard will select columns automatically and you would not need to worry about it

</cl>