To switch between a file browser and a connection panel, click
in the upper right of the file browser.
To switch back, click

in the same location.
By default, Transmit shows two file browsers side-by-side. You can make either browser display local or remote files by switching between these two modes.