Skip to main content

Which FTP client is better: FileZilla, CuteFTP or TotalCommander?

Most people think that FTP speed depends on server and network speed. How about FTP client? Which FTP client should you prefer If you need high speed?

Which one is the best?

I tested three FTP clients:

  • FileZilla 3.5.3
  • CuteFTP 8.3.2
  • Total Commander 7.55

Here is test environment:

  • Operating system: Windows 7 Ultimate
  • FTP Server speed: 30 Mbps (download), 140 Mbps (upload)
  • Network speed: 32 Mbps (download), 2 Mbps (upload)

I have tried download/upload three times and calculated average. All clients have had the same conditions. The results:

FTP clients comparison
FTP clients comparison

* I used multi-part download and normal upload on CuteFTP. I used default settings on FileZilla and Total Commander.
* Passive mode was used for both download and upload (Find out more).

As a result

  • Don’t use Total Commander! Upload speed of Total Commander is terrible!
  • If you like open source programs choose FileZilla.
  • If you like programs that have user-friendly interface, choose CuteFTP.

Excel Macro which copies one column to another by matching specific unique column

This is a simple Excel Macro which copy one column to another by comparing specific unique column. There two sheets: Sheet1 and Sheet2. We copy column 2 and 3 at Sheet2 to column 2 and 3 at Sheet1 by matching column 1 at both.

There might be persentage data. You should use NumberFormat parameter in that situation.

Sub CopyCells()
    '*** Defining variables ***'
    Dim Value1, Value2
    Dim RowsCount1, RowsCount2

    '*** Find out rows count ***'
    RowsCount1 = Worksheets("Sheet1").Range("A1").CurrentRegion.Rows.Count
    RowsCount2 = Worksheets("Sheet2").Range("A1").CurrentRegion.Rows.Count

    '*** Copying data ***'
    For C1 = 2 To RowsCount2
Set Value1 = Worksheets("Sheet2").Cells(C1, 1)
For C2 = 3 To RowsCount1
Set Value2 = Worksheets("Sheet1").Cells(C2, 1)
If Value1 = Value2 Then
                Worksheets("Sheet1").Cells(C2, 2) = Worksheets("Sheet2").Cells(C1, 2)
                Worksheets("Sheet1").Cells(C2, 2).NumberFormat = "0.00%"
                Worksheets("Sheet1").Cells(C2, 3) = Worksheets("Sheet2").Cells(C1, 3)
                Worksheets("Sheet1").Cells(C2, 3).NumberFormat = ""
            End If
        Next C2
    Next C1
End Sub

C1 and C2 mean Counter1 and Counter2.