CSV
CSV is a way to store tables as plain text: each record is on a line, and fields are separated by a character (usually a comma). It is commonly used to transfer information between spreadsheets, databases, and automations.
On this page
Source content checked . English translation published 2026-10-27.
In business automation
CSV is suitable for transferring simple tables, but it does not always preserve data types or business meaning. Before importing, define the delimiter, encoding, and required fields before working with production data.
Examples
These examples illustrate a possible workflow. Adapt the connections and rules to your own systems.
Business process example
A team imports an old customer list. First, they check a sample with Hebrew text, a comma in an address, and a leading zero in a phone number; then they separate invalid records and match valid ones using a clear identifier.
Relevant tools
- Google Sheets
- Work with tabular data and import files; define and check how fields are interpreted.
What to check
- Opening and saving in a spreadsheet may change dates and numbers. Keep a source file and check the data after import.