How to exclude data from a text file which is already imported

Hi Bhanu,

If you use legacy Text Import Wizard on the first step you see an option from which row to start the import - put here one next to already imported.

Other words, if you import into one worksheet 1,048,576 rows (which is the size limit, see https://support.office.com/en-us/article/Power-Query-specifications-and-limits-5fb2807c-1b16-4257-aa5b-6793f051a9f4), on next import start from 1,048,577

Alternatively you may load entire file to data model using PowerPivot/PowerQuery connectors (not into the sheet, into the data model). They also have some formal limits, but actually that's limited only by your PC memory size.