Excel: Import CSV - these steps are necessary
Tables and other simple structures can be saved in CSV format. These are "comma-separated values", i.e. values separated by commas. The spreadsheet program Excel can also read this type of file. For this, you need to import the CSV.
How to import a CSV into ExcelHaving saved a table or list as a CSV, there are various programs that you can use to access this information. Microsoft's Excel spreadsheet program can also read this type of file. It is then possible to edit the table and save it in a different format. To do this, however, you must first import the file.
- Open the Excel program. Then go to the "Data" tab at the top of the bar.
- Now you will see the "From Text/CSV" button in the "Retrieve and Transform Data" area.
- Now you have the option to select the CSV file on your computer. Once you have selected it, click on "Import".
- After that, the "Import" wizard of Excel will open. Now you can make additional settings, such as the character set encoding. Here it is a good idea to select "UTF-8", since this recognizes most special characters. Make sure that you change the separator appropriately to improve readability.
- About "Edit" you can also make direct changes to the CSV file.
- Finally click on "Load" to import the file.