Needing FTP Software with editing and hides system files? I am looking for FTP Client software for Mac that 


Doesn't show hidden system files on the server
Can edit files using MS Office and then save them back onto the FTP site automatically without the user having to download the file, edit the local copy and then upload the local copy and replace the remote copy.


I have tried various FTP software and only a handful don't show hidden system files on the server which is good, and some automatically open files when they are double clicked using the correct software (Word, Excel etc..) but then when you save it doesn't update the remote copy.
I believe that Transmit from Panic Software will meet all of your needs. 

There is a menu option that toggles the visibility of dot (.*) files. View menu (Hide/Show) Invisible Files.

To edit a remote file in Word, right click on the remote file and select "Open With..." and select Word from the context menu to edit the file. Edit and Save the file within Word and the file will be uploaded as soon as the save completes. There is nothing else to set up.

I usually use this method with BBEdit and Text files, but I tested and it works with Word files.