1000+ multiple gst rate in single invoice entries

Hello

My client raises invoice and one invoice contains multiple gst rate i.e. one invoice has 5%, 12%, or evem 18% also.

My problem is how do i import these monthly 1000+ sales transactions on tally.

For sales invoice he uses some software and he gives me extracted excel file.

Any format i can import excel to tally?

I tried tally tdls but it is not suitable.