Convert CSV to Excel Format | Convert CSV to Excel | CSV to XLSX | CSV Import to Excel
In this Microsoft Excel video tutorial I explain how to convert a CSV file into Excel format. A CSV file uses a delimiter to separate data into columns. The delimiter is often a comma, but it might be a semi-colon. This video shows you how to set the default list separator in Windows, so if you always receive data separated by a semi-colon you can tell Windows to treat a semi-colon as a list separator. This setting is then applied to Excel.
If your CSV file imports into Excel in a single column, the data can be separated into columns by either using the Text to Columns feature or by using Power Query.
🕰️Timestamps
00:00 Introduction
00:55 Changing the default CSV delimiter used by windows
02:48 Method 1: Use Text to Columns
03:31 Method 2: Use Power Query
#exceltutorial #exceltips #exceltricks
Watch video Convert CSV to Excel Format | Convert CSV to Excel | CSV to XLSX | CSV Import to Excel online without registration, duration hours minute second in high quality. This video was added by user Chester Tugwell 13 December 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 3,621 once and liked it 61 people.