import pandas as pd  
import os  
import glob  
  
# Replace the folder_url with the SharePoint URL of the document folder  
folder_url = 'https://company.sharepoint.com/:f:/s/Source/ErzWHfGHqWxAt_G0F09schwBN8Heo9khieMVLKbG0jbLzQ'  
  
# Get a list of all XLS files in the folder  
xls_files = glob.glob(f'{folder_url}/*.xls')  
  
# Iterate over each XLS file and convert it to CSV  
for xls_file in xls_files:  
    # Read the XLS file using pandas  
    df = pd.read_excel(xls_file)  
  
    # Get the filename without the extension  
    filename = os.path.splitext(os.path.basename(xls_file))[0]  
  
    # Replace the output_folder_path with the desired path for the CSV files  
    output_folder_path = 'https://company.sharepoint.com/:f:/s/Source/ErzWHfGHqWxAt_G0F09schwBN8Heo9khieMVLKbG0jbLzQ

'  
  
    # Create the output folder if it doesn't exist  
    os.makedirs(output_folder_path, exist_ok=True)  
  
    # Convert the DataFrame to CSV  
    csv_file_path = f'{output_folder_path}/{filename}.csv'  
    df.to_csv(csv_file_path, index=False)  
  
    print(f'File converted and saved as {csv_file_path}')  

(Aug-29-2024, 06:27 PM)deanhystad Wrote: Please describe what you mean by "not working". Are you getting any files in xls_files? Can you read the excel file? Can you make the directories for the output?