What is Excel?
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.
Example Excel Document
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.
Here is how the document looks in Babelway
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).
Build from sample file
Create your incoming or outgoing Excel structure from a sample file
- Upload your sample and get it parsed immediately
- Remove, add, edit segments to customize settings for the Excel
- Use data from multiple pages within the file
- Add custom validations on certain fields
Transform any format
Use simple drag & drop tools to map your Excel message to any other format for easy import/export in/from your database
- 12+ formats to choose from: X12, multi-record text file, UBL, CSV, XML, EDIFACT, etc
- Hundreds of transformation functions available or build your custom functions
- Use lookup tables tables to replace data sets
- Change your Excel structure without loosing your transformation maps
Connect to anyone
Connect your Babelway environment using any EDI or non-EDI communication protocols
- 12+ communication protocols supported including X400, VAN, AS2, SFTP, VPN, etc.
- Define retry strategies for maximum robustness
- Get notified and intervene immediately in case of processing or delivery issues
And last but not least:
Get extended support from the experts
Babelway is not only a great self-service platform but also a team of pros ready to help you succeed.
- Access our support helpdesk anytime and ask your questions. You will be answered as soon as max 60 minutes
- Spot the ‘reuse and save time’ zone on the right of the screen? Import messages and maps from our catalog
- Access online training material through Babelway Academy
“I have to say how helpful Babelway support is. It was amazing how quickly I was getting answers to my questions. Sometimes even at all hours of day and night.”
IT Department, Vandeputte