Is there way to create automatic case records in salesforce? We have requirement where user has to manually create case by looking at the spreadsheet date and they are very identical records. As there are so many records needs to be created its lot time consuming. Is there any auto process that fetch data from spreadsheet or salesforce report and create case ?
You can use any of data loader tools.
There is the Apex Data Loader:
The Data Import Wizard(in browser):
And a number of 3rd party tools that are maybe a little more complicated then your use case.