Product - Format
Excel
What is Excel?
Excel files can be used in many different ways. For 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.
Getting started with Babelway
1. Select Excel as the message type
2. Upload a sample file
3. Babelway will do the rest
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).
Why Babelway?
Set up with ease
Deploy your connection in seconds, making it ready for testing immediately.
Transform any format
Use simple drag & drop tools to map your message to any other format for easy import/export in or from your database.
Connect to anyone
Connect your Babelway environment using any EDI or non-EDI communication protocols.
Support
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
What have our clients said about X12 in Babelway?
“Babelway helps us innovate in B2B collaboration.”
Read case study >
“Their product and their experts ensure that we’ll have an innovative B2B integration solution, not just right now, but in the years to come.”
g2.com
GetApp
Try our free 30 day trial to see how easy it is work with X12
Learn about the other formats
IDocs
SAP's standard data structure (Intermediate Document) for exchanging business documents between SAP systems and external applications.
CSV
A plain-text format that stores tabular data as comma-separated values, commonly used for simple data exports and imports.
Excel
A spreadsheet file format (.xls/.xlsx) often used to manually structure and exchange business data such as orders, invoices, and inventory.
JSON
A lightweight, human-readable data format built on key-value pairs, widely used for exchanging data between modern web applications and APIs.
Tradacoms
A UK-specific EDI standard developed for the retail and grocery sector, commonly used to exchange orders and invoices with British trading partners.