Skip to main content

Quick Overview

In this software demonstration, a presenter from Skill Leap AI walks through a data workflow using the ChatGPT desktop client. The video illustrates how to grant the tool direct folder access to consolidate multiple spreadsheet files into a single summary document.

Key Points

  • 1.ChatGPT can take twelve separate spreadsheets and consolidate them into a single clean Excel workbook.
  • 2.The ChatGPT desktop application enables project folders that give the model direct access to local files stored on a computer.
  • 3.The demonstration uses a prompt instructing ChatGPT to create a summary tab comparing six-month ordering periods and flagging accounts ordering less.
  • 4.ChatGPT completed the data consolidation and wrote the resulting Excel file directly back to the local desktop folder in two minutes.
  • 5.The generated workbook includes dedicated tabs for a summary overview, order details, and source file tracking.

Summary

The video opens with the presenter explaining how twelve separate and disorganized spreadsheet files were cleaned and combined into a single structured document using ChatGPT. He displays the prompt entered into the interface, which instructs the model to combine twelve order files into one clean spreadsheet, build a summary tab comparing each account's last six months to the six months prior, flag any accounts that are ordering less, show which account grew the most, and generate a chart.

To facilitate this task, the presenter uses the desktop application version of ChatGPT rather than the web browser version. Inside the desktop interface, navigating to the Work section allows users to create a dedicated project. When setting up a project, users can grant the software direct access to a folder on their computer where the target data files are stored. The presenter notes that while a files tab exists to reuse previously uploaded files, linking an active local folder directly via the desktop app is his preferred method because it is exclusive to the desktop client.

The presenter then shows that the entire process took approximately two minutes to complete. The resulting Excel document was automatically saved directly into the linked desktop folder. Opening the generated workbook, he examines its structure, which features a formatted summary tab with account order trends and color-coded status tags, a tab detailing raw order records, and a sources tab indexing the exact spreadsheets the data was extracted from.

Connecting local folders with ChatGPT Work

The presenter highlights the Work feature within the ChatGPT desktop application, explaining that it allows the model to access files directly from local storage. By creating a new project in the desktop app and linking it to a specific folder on the computer, users can bypass uploading files manually one by one. While previously uploaded files can still be pulled in through the files tab, pointing a project directly to a local directory provides a streamlined workflow.

Prompting for multi-file data consolidation

To combine twelve separate order spreadsheets, the presenter enters a prompt instructing ChatGPT to clean the files into one workbook. The instruction asks the system to build a summary tab comparing each account's last six months against the preceding six months, identify who grew the most, flag any accounts ordering less, and produce a chart using Excel functions.

Reviewing the generated Excel workbook

In approximately two minutes, ChatGPT processes the data and places the finished workbook into the local desktop folder. The output contains a clean summary page highlighting growth metrics and flagged declines, a dedicated orders tab, and a source file reference page showing which spreadsheets supplied each piece of information.

The Bottom Line

The video establishes that ChatGPT's desktop application can automate the consolidation and comparative analysis of multiple local spreadsheets into a single structured workbook within minutes. It confirms that the system can write output files directly back to a user's computer folder while organizing the output into structured tabs. It leaves open the question of how this setup performs with significantly larger datasets or file formats beyond standard spreadsheets.

FAQ

What is ChatGPT Work and how does it process data from local folders?

ChatGPT Work is a feature demonstrated within the ChatGPT desktop application that enables users to create projects linked directly to local computer directories, allowing the AI to read and process files stored inside those folders.

Why does the presenter prefer using the ChatGPT desktop application instead of the website for project folders?

The presenter prefers the desktop app because granting ChatGPT access to a local folder on the user's computer is only supported through the desktop client, unlike the web interface.

How long did it take ChatGPT to combine the twelve messy spreadsheet files into a single document?

ChatGPT completed the entire consolidation process and generated the final Excel sheet in approximately two minutes.

What specific tabs were created inside the combined Excel spreadsheet generated by ChatGPT?

The resulting workbook contained a summary tab comparing six-month order periods, an order details tab, and a source files tab showing where the data originated.

Worth watching for

Professionals and analysts who manage repetitive data aggregation tasks across multiple spreadsheets and want to automate file cleaning using the ChatGPT desktop application.

  • chatgpt
  • excel
  • automation
  • data-analysis
  • productivity