Hi, I have a data of 3500 records in my data table how can i paste at a time in excel. The activity "Write from data table" is taking long time as it is writing line by line.

Hi @Ramcharan B​ 

You can do either from Keystroke or connect that excel as Database and use sql query.

Hi I have a similar problem but the difference is that my data source is excel and i have to do insert operation on a RedShift DB. The performance is extremely bad and it takes almost 3.5 hours.

That’s an interesting question, Charan07 !

I think the following community members may be able to help 

@Marc Mueller 

@Vatsy 

@Zaid Chougle 

@Tamil Arasu10 

@madhu subbegowda 

@jackson 

@HARUN KUMAR 

@NewTushitha 

@Azhar Hossain 

@kdil 

@Padmakumar 

​@Charan07 

Option 1: Use Excel Advanced → "Write to Excel" (Optimized Way)

If you're using the Excel Advanced package, make sure you’re using:

• Write to Worksheet action
• Targeting a clean worksheet
• Headers included (only once)

This action is the most optimized when:

• The sheet is empty
• No filters, formatting, or formulas interfere

Still slower than ideal for 1000+ rows. Read below for better alternatives.

Option 2: Use CSV Intermediate — Fastest Method

If speed is a priority, convert your Data Table to a CSV and then open it in Excel:

1. Use "Write to File" (CSV format)
   • Convert your Data Table to CSV (comma-separated)
   • Save it using File → Write or Log to File
2. Open CSV in Excel
   • Use Excel Advanced → Open to load the CSV file
   • Save it as .xlsx if needed

• Fastest method for 3,000+ records
• Writes entire data at once
• No formatting overhead