I have an Excel sheet in .xls file. I want to merge it with a .csv file, so that the data in the .csv file will be added starting from the first empty row in .xls.
I want to be able to do it automatically.
You'll need to create a macro.
The basic steps of the macro will be: 1) Open the xls file and find the last row with data. Add 1 to this and you get the first row without data. 2) Open the csv file, find the last row of data, and select and copy all the data rows. 3) Paste the data from the csv file into the xls file beginning with the first row without data.
You can find the macro code for the individual steps of this process by Recording a macro for each of the different steps and then put the steps together to make it all work the way you need.
In importing the CSV you'll want to make sure you have set each column to it's appropriate data type, otherwise, pasting into the xls may cause data corruption issues.