

It is often used for the development of graphs and charts. They can contain formulas, mathematical equations associated with the information in other cells, and fixed information. It includes document data that is located in cells that have a specific address. 🔵 XLS – is a spreadsheet created by a popular Microsoft Excel application. The use of different delimiters allows the availability of unequal encoding.

In this case, the text strings are clearly organized, so all values are separated by commas or double quotes (if there are reserved symbols). 🔵 On personal computers, the CSV extension includes many values represented as ASCII tables. They can be opened by most editors able to work with tables and texts, including both authentic Excel and open source utilities like Apache Open Office and Libre Office.

CSV, in some cases, are сalled flat files. This allows you to transfer information between different programs freely. If there are reserved symbols (for example, a semicolon or a new line), double quotes play the separator role. Commas separate the parameters of each column. Using the spreadsheet application, CSV files can be organized into cells and added to the appropriate database. Each line of the file acts as one row of the database. The data inside of which are separated by commas-developed in the early 70-ies of the XX century to import various table information and transfer bulk information between databases in text format.
