How pull Master Data in installments (Customer and Supplier)

The RM00101(Customer) table as well PM00200 (Vendor) has large volume of data how to query like first 1000 records and next 1000 records so on so that the query will executed in time and the same can pulled in excel sheet.

At present the remote server where the tables are there it does not have excel so at present I saving in "Result to File" and saving into .sql and then opening in excel and while opening excel further data conversion is required. Is there another way? 

Guidance would be appreciated.