This Python converts Excel worksheets to CSV comma delimited format and combine all worksheets into a single file with worksheet name as the section name.
# pip install pandas openpyxl
import pandas as pd
# Path to your Excel file
excel_file = "your excel file.xlsx"
# Output text file
output_file = "combined_output.csv"
# Read the Excel file
xls = pd.ExcelFile(excel_file)
with open(output_file, "w", encoding="utf-8") as f:
for sheet_name in xls.sheet_names:
f.write(f"{sheet_name}\n") # Sheet name as heading
# Read sheet into DataFrame
df = pd.read_excel(xls, sheet_name=sheet_name)
# Replace NaN/NaT with Python None
# and force object type so None is allowed
df = df.astype(object).where(pd.notnull(df), None)
# Replace NaN with ''
# df = df.fillna("")
# Write column headers
f.write(",".join(df.columns.astype(str)) + "\n")
# Write data rows
for row in df.itertuples(index=False):
f.write(",".join(map(str, row)) + "\n")
# Add a blank line between sheets
f.write("\n")
print(f"All worksheets have been combined into '{output_file}'.")
FEATURED TAGS
ai
api
automation
availability
availability-sets
availability-zones
aws-vm
azure
azure-automation-runbook
azure-blob
azure-cosmos-db
azure-data-lake
azure-deployment
azure-function-app
azure-functions
azure-openai
azure-sign-in
azure-site-recovery
azure-sql-database
azure-subscription
azure-vm
base64
certificate
change-data-capture
change-tracking
chrome
clr
container
cte
data-api-builder
data-conversion
data-gateway
database-mail
database-role
database-size
date-table
dax
db-config
derived-table
diagram
direct-query
disk-management
disk-space
docker
downtime
dtc
dynamic-m-parameter
embedding
encrypted-connection
excel
excel-online
excel-online-for-business
execution-plan
extended-events
external-data
fabric
fabric-capacity
failover-cluster
fk
geometry
hierarchy
httpwebrequest
hugo
hyper-v
incognito-mode
index
infrastructure
inline-tvf
json
kql
lakehouse
linked-server
live-query-statistics
locking
m
machine-learning
machine-learning-model
machine-learning-services
master-key
mcp
mdx
memory
memory-grant
mermaid
mirrored-sql-server
network
network-card
network-category
office-script
onedrive
onnx-runtime
openrowset
p2v
parquet
performance
polybase
power-automate
power-bi
power-bi-report-tricks
power-platform
power-query
powershell
printer
public-ip-address
pyspark
python
qgis
qt-designer
query-performance
query-plan
query-troubleshooting
r
regex
replication
route
s3
schema-design
scripting
self-signed-certificate
server-role
sharepoint
snowflake
software-development
sofware-development
spark
sql
sql-2025
sql-agent
sql-availability-group
sql-error
sql-failover-cluster-instance
sql-index
sql-openjson
sql-permission
sql-recovery
sql-script
sql-security
sql-server
sql-server-admin
sql-server-config
sql-statistics
ssis
ssisdb
ssl
ssl/tls-error
ssms
table-expression
tempdb
terraform
tips
troubleshooting
unicode
view
visual-studio
visual-studio-code
vmware
wait-statistics
wi-fi-connection-issue
windows-settings