Product - Format

CSV

What is a CSV file?

CSV stands for Comma Separated Value. This file format is frequently used for importing or exporting data from a system. It typically contains one line of ‘headers’ that defines each value in subsequent lines. The information below the headers contains the actual data for the document.

Example CSV document

Each value corresponds to the first header row, separated by commas. CSVs can also use characters other than commas to separate each value. For example, it’s common to see ‘|’ used as a separator. These subtle differences in format don’t change the structure of file and are dependent on the system creating the file.

CSV is a very common file format because it can be flexibly defined. A system can simply choose its header values and communicate the values for those headers. For this reason, you are almost guaranteed to encounter a CSV file format when dealing with data integration.

Getting started with Babelway

1. Select CSV as message type

2. Upload a sample file

3. Babelway will do the rest

Babelway uses the header row to identify each value. Babelway can map each field to another file format and apply additional data changes to each value if necessary. It’s very easy to control the data, regardless of the incoming CSV’s structure.

Why Babelway?

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

X12

A standard definition for EDI document exchanges, Most commonly used in the US.

Edifact

A widely accepted international EDI standard used by many organisations.

Flat Files

These are rows of text that convey pre-defined information.

IDocs

An integrated web API that gives access to information on Amazon Seller Central.

PDF

A file format created by Adobe to present documents.

UBL

A royalty-free library of standard XML business documents.

XML

Used for many data integration purposes.

CSV

A standard definition for EDI document exchanges, Most commonly used in the US.

Excel

A standard definition for EDI document exchanges, Most commonly used in the US.

JSON

A standard definition for EDI document exchanges, Most commonly used in the US.

Tradacoms

A standard definition for EDI document exchanges, Most commonly used in the US.