How to Open a CSV File with OpenOffice
What is a CSV file?
CSV files are tabular files whose values are split by a separator character, which according to English standards is the comma “,“, while Italian standards use the semicolon “;“.
Other separators can also be used as needed.
What does a CSV file look like?
This is an example of a CSV file: "test","test",2,3
How can I open a CSV file with OpenOffice without the content getting scrambled?
Once we choose to open our CSV file with OpenOffice, we get this screen, where we need to set the various parameters so that the file opens correctly:

In our case, for the first two fields (Character set and Language) we leave the defaults, as in the screenshot.
“From row” indicates which row we want to start importing from and will vary according to our needs; here we want to start from row 1.
Separator options: we have 2 choices:
- Fixed width: to be used for files whose columns have a fixed number of characters, so we will have n characters filled in and then n spaces until the fixed number of characters the column must have is reached
- Separated by: to be used for files that do have a separator, which we then need to choose; in our example the separator is the comma, so we remove the one selected (Other) and select Comma.
- Text delimiter: to be used when some texts contain the same separator that is being used, to avoid columns being added incorrectly; the single text of that specific column must be enclosed by delimiters that you choose at this stage, usually quotation marks.

Other options: used to identify text enclosed in quotation marks, or to detect special numbers. Personally I usually don’t select anything at this stage, also because in the next screenshot we can see that we can choose how to interpret each column individually.
I usually import everything as text and then, if needed, change the column format at a later stage

To finish, click OK at the top right and