# Dat Extraction csv format for all tables

**URL:** <https://forums.toadworld.com/t/dat-extraction-csv-format-for-all-tables/58824>\
**Category:** Toad for SQL Server\
**Created:** [January 19, 2024, 8:55pm UTC](https://forums.toadworld.com/t/dat-extraction-csv-format-for-all-tables/58824 "2024-01-19T20:55:21Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![gopal.r.pinnamareddy](https://avatars.discourse-cdn.com/v4/letter/g/4da419/32.png) [@gopal.r.pinnamareddy](https://forums.toadworld.com/u/gopal.r.pinnamareddy)\
**Post date:** [January 19, 2024, 8:55pm UTC](https://forums.toadworld.com/t/dat-extraction-csv-format-for-all-tables/58824/1 "2024-01-19T20:55:21Z")

</div>

Hello,  
Looking to extract the csv format for all tables in the sql server. I got the python but not much user friendly .But how do i write power shell or python and debug in side the toad.  
Or  
any innovative ideas to extract the CSV format from the database daily jobs etc helpful

---

<div class="post-metadata">

**Author:** ![Gary.Jerep](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gary.jerep/32/205_2.png) [@Gary.Jerep](https://forums.toadworld.com/u/Gary.Jerep)\
**Post date:** [January 22, 2024, 6:35pm UTC](https://forums.toadworld.com/t/dat-extraction-csv-format-for-all-tables/58824/2 "2024-01-22T18:35:15Z")

</div>

Welcome to the Toad for SQL Server forum.

There's a far easier way within Toad to extract data from SQL Server tables than using Python or PowerShell (unless you're doing something very advanced).

Simply use Toad's Export wizard, which gives you the ability to export to many popular formats, and even export some/all of the tables in some/all of the databases on a SQL Server instance. See quick gif below... Hope this helps.

![TSS_Export_forAllTables3](https://global.discourse-cdn.com/quest/original/3X/9/9/99e18b9e3c97ad7a789c748ab730b49629db8360.gif)

---

<div class="post-metadata">

**Author:** ![gopal.r.pinnamareddy](https://avatars.discourse-cdn.com/v4/letter/g/4da419/32.png) [@gopal.r.pinnamareddy](https://forums.toadworld.com/u/gopal.r.pinnamareddy)\
**Post date:** [January 22, 2024, 6:59pm UTC](https://forums.toadworld.com/t/dat-extraction-csv-format-for-all-tables/58824/3 "2024-01-22T18:59:49Z")

</div>

This is scheduled job and replace old files daily run. Also The table header info ang count (\*) trailer info count for csv