Insert data from user uploaded spreadsheets in your MySQL database

How to get started

In order to insert the data from user uploaded files in your database, create an APISpreadsheets account. You will need a Business plan to use this feature. However, you can email us at sales@apispreadsheets.com to request a 7 day free trial!

  1. Create a spreadsheet importer
  2. Connect to your database
  3. Map columns in the settings

Create a Spreadsheet Importer

Go to the ‘Import’ page. Then simply click the ‘Create a Customized Importer’ button.

Connect to database

Connect your database to API Spreadsheets by providing the necessary details of the database such as the name, username, host/IP address, etc.

Map columns in the settings

In the spreadsheet importer settings we need to align spreadsheet columns with fields in the database.

Upload files

Once the column mapping is set up, the file upload process will be a little different.

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Love Spreadsheets

Love Spreadsheets

Life is too short to work on spreadsheets. Let us do your spreadsheet work for you at lovespreadsheets.com