How to save an Excel sheet as a CSV file
You have an Excel sheet that you want to import into another app, shop, or database, but they only accept CSV files. To solve this problem, you can convert your Excel sheet into a CSV file that can be easily imported into any platform that supports CSV files.
Converting an Excel sheet to a CSV file is a straightforward process that can be done using online tools, and the resulting CSV file can be used with online shops, email tools, banks, and databases that usually import CSV files, not Excel files.
Why convert to CSV
Online shops, email tools, banks, and databases usually import CSV, not Excel, so converting your Excel sheet to a CSV file is necessary if you want to import your data into these platforms. CSV files are widely supported and can be easily imported into most apps, shops, and databases.
The converter writes each cell as you see it in Excel, so you don't have to worry about losing any data or formatting during the conversion process. Postcodes and phone numbers keep their leading zeros, dates keep their format, and formulas are saved as their calculated result.
Accents and other alphabets are stored in UTF-8, the encoding nearly every import tool expects, so you can be sure that your data will be correctly interpreted by the platform you are importing it into. This makes it easy to share your data with others or import it into different systems.
Conversion options
A workbook with several sheets can be converted one sheet at a time or all at once, one CSV per sheet in a ZIP, and named after each sheet. This gives you flexibility in how you want to handle your data and makes it easy to organize your CSV files.
You can choose the separator that you want to use in your CSV file, such as a comma or semicolon, depending on the requirements of the platform you are importing into. Use a comma separator for most websites and apps, and a semicolon if the CSV will be opened in Excel in a country that writes decimals with a comma, such as Spain, France, or Germany.
Older XLS and LibreOffice ODS files work the same way as XLSX files, so you can convert any of these file types to CSV using the same process. This makes it easy to work with different file types and ensures that you can convert your data regardless of the file format.
Steps to follow
To convert your Excel sheet to a CSV file, you can follow these simple steps:
- Select your Excel file (XLSX, XLS, or ODS), or drop it on the box on the Excel to CSV converter page.
- Choose the sheet that you want to convert and the separator that you want to use in your CSV file.
- Click Convert to CSV and download the file. The CSV downloads straight away, so you can quickly and easily access your converted data.
Once you have converted your Excel sheet to a CSV file, you can import it into any platform that supports CSV files. This makes it easy to share your data with others or import it into different systems.
Security and privacy
The file is read and converted inside your browser on your own device, so customer lists, prices, and payroll data are never sent to us or stored anywhere. This ensures that your data is secure and private, and you can be sure that it will not be shared with anyone else.
Once the page has loaded, it works even offline, so you can convert your Excel sheet to a CSV file even without an internet connection. This makes it easy to work with your data anywhere, at any time, and ensures that you can access your converted data even when you are not connected to the internet.
To get started with converting your Excel sheet to a CSV file, simply visit the Excel to CSV converter page and follow the steps outlined above. With this easy-to-use tool, you can quickly and easily convert your Excel sheet to a CSV file that can be imported into any platform that supports CSV files.
FAQ
How do I convert XLSX to CSV?
Select the XLSX file, choose the sheet and the separator, and click Convert to CSV. The CSV downloads straight away. Older XLS and LibreOffice ODS files work the same way.
Will leading zeros be kept?
Yes. Each cell is written as it is displayed, so a postcode shown as 01234 or a code shown as 000123 stays exactly like that in the CSV instead of turning into a plain number. This ensures data accuracy and integrity.
Is my spreadsheet uploaded to a server?
No. The file is read and converted inside your browser on your own device, so customer lists, prices and payroll data are never sent to us or stored anywhere. Once the page has loaded it works even offline.