For Developers

Automate your conversions using the RebaseData API

Read Excel with Ubuntu

Open a terminal. Run the following command to make sure you have the packages curl and libreoffice-calc installed:

apt-get install curl libreoffice-calc

Then you can use CURL to convert the Excel file to CSV. You have to replace example.xlsx with the file you want to convert.

curl -F 'files[]=@example.xlsx' https ://www.rebasedata.com/api/v1/convert?outputFormat=csv -o output.zip

Now try to open the file output.zip. It will contain CSV files. You can open these CSV files with LibreOffice Calc. Make sure you specify "comma" as column separator.

If you cannot open the file output.zip, there was probably an error and the file contains the error message. Open it with gedit to see the error.

That's it! You successfully read your Microsoft Excel file.

How does it work?

The RebaseData PHP-Client internally uses our API to convert the Microsoft Excel file to a standardized format. Then you can read the data using PHP as shown above.

Why use RebaseData?

  • Strong security.
  • Works with Windows, Mac and Linux.
  • Use an API to convert your databases.
  • Professional support.

Terms

  • We don't guarantee for the success or correctness of the conversion
  • You are only allowed to convert your own database files
  • By using RebaseData, you agree to our general terms