How to Quickly Copy Data from Excel to Data Loader Sheet
If you have to copy data from Excel to FDL sheet. You can make use of
useful feature "Paste Skipping Key Columns". This option will copy and
paste the data only in Data columns.
For Example if you have FDL sheet like this as shown below
And if you have data in Excel like this as show below
Then you can select and copy all the data in Excel as shown below
And then Select FDL window and right click in the first column and Select
"Paste Skipping Key Columns" menu option as shown below
FDL will paste the data only in Data columns as show below
Now you can fill the all the key columns by clicking "Key Columns" menu
and selecting "Auto Fill Key Columns" menu option. as shown below
Then FDL will automatically fill the key columns as shown below.