Working with a CSV file in Excel

preview_player
Показать описание
In this video, you will learn how to work with CSV files in Microsoft Excel.

In this video you’re going to see:
✓ How to open a CSV file in Excel
✓ What are the most common issues that can happen when opening a CSV file in Excel and how to fix them?
✓ What are the Excel limits when opening a large CSV file
✓ How to add a header to your CSV
✓ How to sort CSV data in Excel
✓ How to convert an Excel file back to a CSV, and save it as UTF-8 encoded.

#csv #icsvloader

In this video, you will learn:
00:00 - Intro
00:24 - Using Text to Column tool in Excel to fix the most common issue
00:58 - Using Import Wizard in Excel to open a CSV file
01:24 - Excel limitations on the file size
02:00 - Sort CSV data in Excel
02:24 - Convert data from Excel to a CSV file with UTF-8 encoding
Рекомендации по теме
Комментарии
Автор

A bit more of what is inside:
00:01 - Intro
00:24 - Using Text to Column tool in Excel to fix the most common issue
00:58 - Using Import Wizard in Excel to open a CSV file
01:24 - Excel limitations on the file size
02:00 - Sort CSV data in Excel
02:24 - Convert data from Excel to a CSV file with UTF-8 encoding

CSVLoader