- Clone the repository
- Fillout the database configuration inputs
- Click Connect to database button
- To validate the database connection
- Select the table from select box
- Import your excel file
- Click Draw Flow button
- Match your column by values
- After complete matching your columns :
- Click Export JSON data
- Optional
- Choose the start and end row
- Click on delete old data checkbox if you want to delete the old rows in the table
- Click Export JSON data
- Finally Click Sync button
-
Notifications
You must be signed in to change notification settings - Fork 0
iSemary/sync-excel
This commit does not belong to any branch on this repository, and may belong to a fork outside of the repository.
Folders and files
Name | Name | Last commit message | Last commit date | |
---|---|---|---|---|
Repository files navigation
About
Syncing excel file sheet to any table by matching sheet columns to database table columns with an easy user interface, build with Javascript, PHP, MySQL.