The Complete
Introduction to CSV
Learn the in's and out's of working with CSV, from the basics of defining what is CSV, to converting CSV files and troubleshooting common issues.
Know Your CSV Basics
What is CSV?
Defining CSV - what exactly is it and what does it do, in simple and practical terms. ▶︎▶︎▶︎▶︎
What we use CSV for
Answering not what, but why CSV - why do we use CSV to do things like view and move data, backup data and more. ▶︎▶︎▶︎▶︎
Understanding CSV and row limits
Know the limits of common programs used to open CSV files, so you can choose the right option for your size file. ▶︎▶︎▶︎▶︎
Why do apps use CSV format?
We'll look at why CSV format is so universally loved and used by most apps and software for moving data. ▶︎▶︎▶︎▶︎
Creating and Viewing CSV Files
How to create a CSV file
An overview of how to create a CSV file using various methods, such as spreadsheet programs, text editors and other apps. ▶︎▶︎▶︎▶︎
How to open a CSV file?
How to know which program is optimal for opening and viewing your CSV file. ▶︎▶︎▶︎▶︎
What is CSV encoding and what should I use?
Breakdown of what CSV encoding is and why it's used. We'll also cover UTF-8 and selecting the best encoding option for your file. ▶︎▶︎▶︎▶︎
What is a delimiter?
Learn what a delimiter is, and what it's function is within your CSV file. ▶︎▶︎▶︎▶︎
Converting CSV files
How to: Convert CSV to Excel
A step-by-step walkthrough on how to convert your CSV into an Excel file. ▶︎▶︎▶︎▶︎
How to: Convert CSV to PDF
Overview of how to convert your CSV file into PDF format. ▶︎▶︎▶︎▶︎
How to: Convert a text file to CSV format
A walkthrough for how to convert your text file to CSV. ▶︎▶︎▶︎▶︎
Working with CSV files
Can I format data in a CSV?
Looking at how data formatting and CSV interact, and why you may wish to avoid saving as CSV if you need to retain formatting in your file. ▶︎▶︎▶︎▶︎
Why quotation marks are used in CSV
Take a look at how to use quotation marks as text qualifiers in your CSV file. ▶︎▶︎▶︎▶︎
How to: Save leading zeros in CSV
Learn how to avoid losing leading zeroes when you open your CSV in a spreadsheet, like Excel. ▶︎▶︎▶︎▶︎
How to Solve Common CSV issues
What to do if your CSV is too large to open
Your guide on how to open and view large CSV files. ▶︎▶︎▶︎▶︎
How to stop Excel from formatting numbers in scientific notation
Learn why Excel converts some numbers to scientific notation, and the steps to fix it. ▶︎▶︎▶︎▶︎