Read CSV file from documents and create records

Please try the below example. Create a csv file on documents and use the below code to create records.

Document doc=[SELECT Body,ContentType,Description,DeveloperName,Name FROM Document WHERE Name = 'Csv File'];
String[] columns=doc.Body.toString().split('\n');
String[] columnNames=columns[0].split(',');
columns.remove(0);
List<Sobject> lstAccounts=new List<Sobject>();
for(String str:columns)
{
	Account acc=new Account();
	String[] fields=str.split(',');
	for(Integer i=0;i<fields.size();i++)
	{
		acc.put(columnNames[i].trim(),fields[i]);
	}
	lstAccounts.add(acc);
}
if(!lstAccounts.isEmpty())
{
	insert lstAccounts[0];
}

Download csv File using Visual force page

I tried downloading a csv file from a visualforce page.

In the code below i am querying contacts object and downloading the query result in csv

 {!a.FirstName},{!a.lastName}

Apex Class:

public class Sample
{   
    public List contacts {get;set;}
    public pageReference fetch()
    {
         contacts = [SELECT Id,firstname,lastname FROM Contact limit 20];
        return null;
    }    
}

Creating a CSV file from salesforce and sending through the Email

List<Account> lstAccount = [Select id,Name,CreatedDate from Account limit 10];

string header = 'Id, Name , Created Date \n';

string finalstr = header ;

for(Account acc: lstAccount)

{

       string recordString = '"'+acc.id+'","'+acc.Name+'","'+acc.CreatedDate+'"\n';

       finalstr = finalstr +recordString;

}



Messaging.EmailFileAttachment sendCsv = new Messaging.EmailFileAttachment();

blob csvBlob = Blob.valueOf(finalstr);

string fileName= 'Accounts.csv';

sendCsv.setFileName(fileName);

sendCsv.setBody(csvBlob);

Messaging.SingleEmailMessage email =new Messaging.SingleEmailMessage();

String[] toAddresses = new list<string> {'test@gmail.com'};

email.setSubject('Accounts');

email.setToAddresses( toAddresses );

email.setPlainTextBody('Accounts');

email.setFileAttachments(new Messaging.EmailFileAttachment[]{sendCsv});

Messaging.SendEmailResult [] r = Messaging.sendEmail(new Messaging.SingleEmailMessage[] {email});