.csv file format is a simple text-based format for storing and exchanging data in plain text, which makes it easy to read and write
Easy CSV is a tool that is built to enable the users to easily upload a csv and map it to a specified database structure.
-
Once the user uploads the csv the contents of the csv is displayed in tabular format for the user to verify the contents of the csv.
-
Below the table we display the columns of the database with a list of csv fields to map to each column.
Note: We can select multiple fields to be added to one column and they will be concatenated and added to the db
- Once the user has selected all the fields they can press the Submit button and the CSV data will be mapped to the database in accordance to the selections made.
It also enables the user to download the mapped and the uploaded data in a csv format.
- Clone the repository
- Open terminal in the root directory
- Run
npm install
to install all the necessary dependencies. - Run
npm start
to run the application - Visit
localhost:3000
in the browser.
- To provide guidance and interaction to user.
- For handling Errors and user queries to ease the CSV upload process.
- Suggesting mapping options, like all csv fields with name can be listed under the name column to start with and an auto mapping feature for future.