All you need to know how to work with CSV files and keep your precious data safe

Your CSV Guide

Basics

Discover which delimiters exist and what they do in your CSV file

Are there any data limits in a CSV file?

What is CSV encoding?

Understand the limitations of popular spreadsheets used to open CSV files

An explanation of CSV encoding and why it is used. We'll also talk about UTF-8 and how to choose the best encoding option for your file

Converting text files into CSV

Step-by-step instructions for converting a text file to CSV, and why it's not as straightforward as it appears

How to open CSV data in Excel properly

Using the Text Import Wizard and avoiding the most common problems.

Create and Open

Edit

Merging CSV files

Examine your options and steps for merging (or combining) data from multiple CSV files

How to deal with special characters in CSV files

Is it possible to encrypt a CSV file?

Why you may need quotation marks in a CSV?

Some (not ideal) solutions for adding password encryption to your CSV file

Examine how to use quotation marks as text qualifiers

Understanding special characters and how to deal with them

Troubleshoot

How to Open Large CSV Files

Some methods for opening and viewing large CSV files

Dealing with the common problems with CSV files

Take a look at the most common problems that occur when attempting to open (import) a CSV file

Fixing corrupted CSV file: Checklist

Your check list for repairing a corrupted CSV file

Save leading zeroes when opening a CSV file in a spreadsheet

Step-by-step instruction

Preventing Excel from showing long numbers as a scientific notation when opening a CSV file

A possible solution for dealing with the problem when opening or importing a CSV file

Cookies managing

Cookie Settings

Cookies necessary for the correct operation of the site are always enabled.
Other cookies are configurable.

Essential cookies

Always On. These cookies are essential so that you can use the website and use its functions. They cannot be turned off. They're set in response to requests made by you, such as setting your privacy preferences, logging in or filling in forms.

Analytics cookies

Disabled

These cookies collect information to help us understand how our Websites are being used or how effective our marketing campaigns are, or to help us customise our Websites for you. See a list of the analytics cookies we use here.

Advertising cookies

Disabled

These cookies provide advertising companies with information about your online activity to help them deliver more relevant online advertising to you or to limit how many times you see an ad. This information may be shared with other advertising companies. See a list of the advertising cookies we use here.