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 Excel 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, it’s a team of expert individuals to make you succeed

  • Spot the ‘reuse and save time’ zone on the right of the screen? Import messages and maps from our catalog
  • Access on-demand, online training material through Babelway Academy – check out the program here.
  • Access our support helpdesk anytime and ask your questions

“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

Free for 30 days