Convert XLSX to CSV

XLSX files are Excel files that use the Office Open XML format, introduced with Microsoft Excel 2007.

XLSX files can contain multiple sheets, and each sheet can contain multiple rows and columns of data. They offer several advantages over the older XLS format.

Key features of XLSX files include:

• Improved compression, resulting in smaller file sizes
• Enhanced security features, including password protection and digital signatures
• Better recovery from file corruption
• Support for more rows (1,048,576) and columns (16,384) per sheet
• Compatibility with a wide range of applications and programming languages

XLSX files are based on XML and ZIP technologies, making them more accessible for third-party software to read and write.

Comma-separated values (CSV) is a simple and widely used format for storing tabular data. It is human-readable and easy to generate and parse.

Row delimiter

The row delimiter is the character used to separate each row in the CSV data. This is usually a new line character (LF), or a carriage return plus a new line character (CRLF).

We will automatically detect this and parse the rows correctly.

Value separator

The value separator is the character used to separate each value inside a row.

For CSV files, as the name implies it is usually a comma, but it can be different depending on the software used to generate the CSV file, we support the following separators:

• Comma ,
• Tab \t
• Pipe |
• Hash #
• Semicolon ;

Character encoding

Depending on what software you used to generate the CSV file, it might have a different character encoding

If no character encoding is specified we will automatically try to guess it, so you don't have to worry about it if you're unsure.