Skip to content

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.

Notifications You must be signed in to change notification settings

iSemary/sync-excel

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

10 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Sync Excel

Preview





How to use

  • 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
  • Finally Click Sync button

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.

Topics

Resources

Stars

Watchers

Forks