Import Data Files (xlsx, csv) into SQL Server using ASP.NET Core


The project aims to develop a robust and efficient web application using ASP.NET Core 7 technologies that allows user to import data files, such as XLSX and CSV into a SQL Server database. This application will provide a seamless and user-friendly experience for importing large volumes of data from various file formats (XLSX, CSV) using ASP.NET Core Web API, XML Bulk Insert, Dapper, CsvHelper, EPPlus and coding best practices.

Key Features:

» XLSX and CSV File Support
» File Validation and Error Handling
» Mapping and Transformation
» Data Import Performance Optimization

Tools and Technology Used:

» C#
» ASP.NET Core 7 Web API
» ASP.NET Core 7 Razor Pages
» Clean Architecture
» Dapper as ORM
» XML Bulk Insert
» CsvHelper
» EPPlus
» Bootstrap

Live Preview:
(Sample Excel File, Sample CSV File)


View Data File

Table with Imported Data


To use the solution, you will need the following:
» ASP.NET Core 7
» SQL Server Express 2019
» Visual Studio 2022


To get started with the solution, follow these steps:
» Make sure you have the required tools and technologies installed.
» The solution has two separate execuable projects; ImportDataFile.API and ImportDataFile.UI. Make sure to run API project first, then the UI project.
» Make sure to change the settings in appsettings files according to your UserRootPath, ConnectionStrings, BaseAPIAddress, SiteSettings etc.
» Start exploring the features and functionalities of the solution.

What You Will Get:

» Full Source Code with Visual Studio Solution
» Database Script in SQL Express 2019

Support Facility:

Have any questions, issues, or doubts? Feel free to reach out via the comments section or email for direct consultations:

Appreciate This
Thank You!

More items by NetBeeTech

by in