Using PHP to convert CSV to XLSX
Use the sample PHP code below to easily and quickly convert CSV files to the XLSX format. Allowing the transformation of structured data into a native format for direct use with Microsoft Excel, get started converting CSV files in minutes and integrate directly into your PHP application to save time and effort. We provide a free Test account to try the service out, comprehensive documentation and support from developers.
PHP Code Sample
1. Install the Zamzar SDK
composer require zamzar/zamzar-php2. Convert a file
<?php
// Signup for a Zamzar API Account or retrieve your existing API Key from https://developers.zamzar.com
$zamzar = new \Zamzar\ZamzarClient('YOUR_API_KEY_GOES_HERE');
// Converts /tmp/example.csv to /tmp/example.xlsx
$zamzar
->jobs->create([
'source_file' => '/tmp/example.csv',
'target_format' => 'xlsx'
])
->waitForCompletion();
->downloadTargetFiles('/tmp/');
->deleteAllFiles();Why Use Zamzar?
Highly Reliable
Our conversion service is there when you need it. Converting since 2006, our API had >99.99% uptime over the last 12 months.
Cloud API
Our cloud based platform scales to meet your demands, whether it's 1 file or 100,000. We manage everything so you don't have to.
All the formats
We support a huge range of conversions - over 1,100 in all. Including documents, videos, images, audio, eBooks, CAD files and more.
Secure & compliant
Our API uses strong encryption of data in transit (and at rest), firewalls, process isolation and state of the art data centers. We are fully GDPR compliant.
One simple API for all your file conversions. Supported on any platform.
Get Started NowCustomer Reviews
We have found our experience with Zamzar over the years we have used it to be fantastic.
They were receptive to a tiered pricing structure as our requirements changed, have a friendly support team that is always helpful and their API that we use daily to send documents to for conversion has always been available and had no issues.
Robin L
The service just works. We've tried other file conversion services in the past, and the results were very disappointing.
With Zamzar, the results are consistently good. Also, their support is friendly and responsive.
Bruno D
We needed a product to upload HTML content, convert and download as a PDF. Zamzar's API provided not only the service required but easy to understand stepped-process to implement.
This business process was critical - but I don't believe we ever had a failure over years of daily use.
Davd M
As Used By
Security and Compliance
Security
Physical access to Zamzar infrastructure is strictly controlled at perimeter and building ingress points by professional security staff utilising video surveillance.
Data Transfer
All traffic to and from Zamzar servers is secured by TLS/SSL. No third-party is able to read or tamper with data exchanged in connections to our servers.
Data at Rest
We encrypt files stored on disk with a unique key and multi-factor encryption so that data is unreadable if hardware is physically compromised.
Passwords
Zamzar API user passwords are stored in our database after being salted and hashed using the secure Bcrypt encryption algorithm.
Firewalls
Zamzar uses multiple different firewall technologies to ensure that different components of its systems are logically isolated from one another.
Using CSV with PHP
You have a number of different options with regards manipulating, reading and writing CSV files. You could use fgetcsv if you wanted to parse a CSV file through PHP. This function parses the CSV file into separate arrays based on the line endings, you can then manipulate the array to suit what you need to do with it. It should be noted that it does not work too well with quote characters and this will not be fixed.
Another option open to you is to use this CSV PHP library. It has the ability to read in CSV files, append entries to CSV files, more advanced manipulation of CSV files and some limited conversion capabilities. It is maintained under Github here and licensed under The MIT Licence.
A third alternative is using the Zamzar API. The API will allow you to manipulate your CSV file easily. There's no need to worry about hosting, and with S3 Integration you can automatically import and export to S3 with just two lines of code. There's a dedicated support team in place who can provide assistance at any stage of the process plus there's an extensive documentation library that should cover any issues/FAQ's.
Resources:
- CSV PHP Library a PHP library used to manipulate CSV Files
- Sprout Read, write and manipulate spreadsheet files (including CSV)
Related StackOverflow Questions:
Using XLSX with PHP
Reading Excel files with PHP is not straight-forward but there's an excellent open source solution (licensed under LGPL version 3) known as PHP Spreadsheet. Perhaps unlike other libraries the best way to use this is to convert the excel sheets into PHP arrays and then use the data in PHP. There are three easy to follow steps that need to be followed - from loading the file in, to defining the reader options to then being able to load and display the data.
Another option is to use the open source, community driven PEAR package for generating Excel Spreadsheets.
A third alternative is using the Zamzar API. The API will allow you to manipulate your Excel file seamlessly and with the same quality as the native Microsoft Office toolset. There's no need to worry about hosting, and with S3 Integration you can automatically import and export to S3 with just two lines of code. There's a dedicated support team in place who can provide assistance at any stage of the process plus there's an extensive documentation library that should cover any issues/FAQ's.
Resources:
- PHPSpreadsheet a PHP library used to manipulate Microsoft Excel Documents
- Spreadsheet_Excel_Writer by PEAR is used to create Excel files.