Excel files can be used in many different ways. For the purpose of data integration, Excel files are used very similarly to CSV files. One row is designated the header file and the subsequent rows contain data related to each header column. The difference with Excel files to CSV is that they can have multiple pages within one file, so you can have differently defined headers and data.
For data integration purposes, it’s important for the excel file to look like this format. It presents any system with a structured way of organizing data so it can import/export properly. Excel files are not as commonly used as CSV files in data integration, but depending on the business requirements, they may be a valuable tool.
As you can see, this is a similar structure to CSV files in Babelway. The only difference is that there is support for multiple pages. Babelway allows you to take data from each page and transform it into one outbound file (or for exporting, take one file and export it in multiple pages).
Create your incoming or outgoing Excel structure from a sample file
Use simple drag & drop tools to map your Excel message to any other format for easy import/export in/from your database
Connect your Babelway environment using any EDI or non-EDI communication protocols
Babelway is not only a great self-service platform but also a team of pros ready to help you succeed.
IT Department, Vandeputte