However, according to your Excel version, the data might be unreadable.Here we explain how you can segment the data to get a nice Excel.
How to convert a .csv file in excel
If the display isn't good, as below, you'll have to segment data:
1. Open your file
2. Segment data into columns
- Click on the
- And then on
Limited(first choice of the list)
- Then press
- Then click
- And then
Your data is now segmented in various columns!
My excel display special symbols instead of letters with accents...
- Open an empty sheet by clicking on
csvthen import your csv file
- Modify the character encoding and select
- Tick the first 3 options
- Then click on
- Choose the first cell to display you data in the sheet