import os
import pandas as pd

# 📁 Folder where all your text files are saved
folder = r"C:\Users\YourUserName\Desktop\SysInfoFiles"   # 🔁 change this path

data = []

# Loop through all .txt files
for file in os.listdir(folder):
    if file.endswith(".txt"):
        file_path = os.path.join(folder, file)
        info = {"FileName": file}
        
        with open(file_path, "r", encoding="utf-8") as f:
            for line in f:
                if ":" in line:
                    key, value = line.split(":", 1)
                    info[key.strip()] = value.strip()
        
        data.append(info)

# Convert to DataFrame
df = pd.DataFrame(data)

# Save as Excel & CSV
output_excel = os.path.join(folder, "System_Summary.xlsx")
output_csv = os.path.join(folder, "System_Summary.csv")

df.to_excel(output_excel, index=False)
df.to_csv(output_csv, index=False)

print(f"✅ System info extracted successfully!")
print(f"📄 Excel file saved at: {output_excel}")