What is CSV?

CSV stands for Comma Separated Value and it is a file format that can contain much information useful for importing or exporting data from a system. A CSV typically contains one line of ‘headers’ that define what each value means in subsequent lines. The data in the subsequent lines contain the actual data for the document you are sending. For example, a CSV might look like this:

Invoice Number, Invoice Date, PO Number, Quantity, Unit, Unit Price, Item Description
INV123, 20160101, 4500091749, 3, EA, 3.99, Signs
INV123, 20160101, 4500091749, 5, EA, 7.99, Materials

Example CSV document

Each value corresponds to the first header row, separated by commas. CSVs can also use different characters other than commas, for example it’s common to see ‘|’ to separate each value. The structure of the file is no different, it’s just different settings of the file depending on the system that is creating the file.

CSV is a very common file format because it can be defined in any way necessary. A system can choose its header values and communicate the values for those headers. For this reason, it is almost guaranteed that one would encounter a CSV file format when dealing with data integration.

Here is how the document looks in Babelway

This is what a CSV file looks like in Babelway. We use the header row to identify each value. You can use Babelway to map each field to another file format and apply additional data changes to each value if necessary. This makes it very easy to control the data regardless of what structure the inbound CSV looks like.

Build from sample file

Create your incoming or outgoing CSV structure from a sample file

  • Upload your sample and get it parsed immediately
  • Remove, add, edit segments to customize settings for the CSV
  • Add custom validations on certain fields

Transform any format

Use simple drag & drop tools to map your CSV message to any other format for easy import/export in/from your database

  • 12+ formats to choose from: X12, multi-record text file, UBL, Excel, XML, EDIFACT, etc
  • Hundreds of transformation functions available or build your custom functions
  • Use lookup tables tables to replace data sets
  • Change your CSV 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 BabelAcademy – 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