CSV

How to change Excel CSV delimiter to comma or semicolon

Imagine this: you want to export your Excel data to another application. Whatever CSV option you use, the result is a semicolon-separated file instead of comma-separated you really wanted. The setting is default, and you have no idea how to change it. Continue reading

Converting CSV to Excel: problems and solutions

The name CSV (comma separated values) implies the use of comma to separate data fields. But that is in theory. In practice, many so-called CSV files separate data using other characters such as semicolon or tabs. The lack of standard spawns various problems with CSV to Excel conversions. Continue reading

How to merge multiple CSV files into one Excel workbook

If you often export files in the CSV format from different applications, you may end up having a bunch of individual files relating to the same subject matter. The question is - is there a simple way to import them all into a single Excel workbook? Continue reading

How to convert (open or import) CSV file to Excel

Generally, there are two ways to convert a CSV file to Excel: by opening it in Excel or importing as external data. This article provides the detailed guidance on both methods and points out the strengths and limitations of each. We will also red-flag possible pitfalls and suggest the most effective solutions. Continue reading

How to convert Excel files to CSV (comma delimited) and CSV UTF-8

Comma separated values (CSV) is a widely used format that stores tabular data (numbers and text) as plain text. Its popularity and viability are due to the fact that CSV files are supported by many different applications and systems at least as an alternative import/export format. Continue reading

How to remove carriage returns (line breaks) from cells in Excel

In this tip you'll find 3 ways to remove carriage returns from Excel cells. You'll also learn how to replace line breaks with other symbols. All solutions work for Excel 2013, 2010 – 2003 Continue reading

How to avoid automatic data formatting in Excel

Excel is a helpful program when you have standard tasks and standard data. Once you want to go your non-standard-Excel way, some frustration is involved. Especially when we have large data sets. I came across one of such formatting issues when I dealt with our customers' tasks in Excel. Continue reading

Ukraine flag War in Ukraine. Here's what Ablebits is doing to make sure our team and projects are safe.