GoAnywhere MFT can create Microsoft Excel spreadsheets to share detail and summary information with employees and trading partners. Additionally, data can be extracted from Excel spreadsheets and converted to other file formats or loaded into a database for further processing. GoAnywhere MFT supports Microsoft Excel 2003, 2007, 2010, and 2013.
The data read from Excel spreadsheets can be imported into database tables or translated into other formats including fixed-width text, delimited text, and XML. The following user-specified options are available when reading Excel spreadsheets:
Microsoft Excel .xlsx and .xls spreadsheets can be created from database values or from data extracted in other files such as delimited text, fixed-width, flat files and XML documents. When defining an Excel conversion, you can choose to use an Excel Template which may contain predefined headings, fonts, formulas, etc. The following user-specified options are available when creating Excel spreadsheets in GoAnywhere MFT:
After an Excel spreadsheet is generated, GoAnywhere MFT can then compress or encrypt the file and store it on the network or distribute the file to a remote server. You can also password protect your Excel spreadsheets with AES encryption.