Best Way To Display A "Live" Excel Spreadsheet Remotely On A Display

Certainly! Transitioning from a whiteboard to a digital display for frequently updated information can significantly streamline your operations. Here are some options to consider for displaying a frequently updated Excel spreadsheet on screens in your warehouse and office:

1. Google Sheets
   • Pros: Easy to share and update; real-time collaboration; accessible from any device with internet access.
   • How to Implement:
     1. Convert Excel to Google Sheets: Upload your Excel file to Google Drive and open it with Google Sheets.
     2. Publish to the Web: In Google Sheets, go to File > Publish to the web. Choose the sheet or entire document and publish it.
     3. Share the Link: Get the link or embed code provided and use it to display the sheet on your screens via a browser or embedded frame.
2. Microsoft OneDrive and Excel Online

• Pros: Integrates with Office 365; good for users already in the Microsoft ecosystem.
• How to Implement:
  1. Upload Excel to OneDrive: Save your Excel file to OneDrive.
  2. Share and Get a Link: Open the file in Excel Online, go to File > Share, and get the sharing link.
  3. Display: Use the link to display the sheet on your screens via a browser.

3. Digital Signage Solutions
   • Pros: Designed for high-quality, real-time display; often comes with additional features for managing multiple screens.
   • How to Implement:
     1. Choose a Digital Signage Platform: Platforms like ScreenCloud, Xibo, or Rise Vision allow you to display and manage content on screens.
     2. Upload and Configure: Upload your Excel or Google Sheets file to the platform and set up the display configurations.
     3. Deploy: Connect the screens to the digital signage system.
4. Custom Dashboard with Web Technologies
   • Pros: Tailored solution; can integrate various data sources; highly customizable.
   • How to Implement:
     1. Develop a Dashboard: Use web technologies (like HTML, CSS, JavaScript) to create a custom dashboard.
     2. Use APIs: Integrate with Google Sheets API or Microsoft Graph API to pull data from your spreadsheet.
     3. Host and Display: Host the dashboard on a web server and display it on your screens.
5. Using a Raspberry Pi or Similar Device
   • Pros: Cost-effective; good for static, low-complexity displays.
   • How to Implement:
     1. Set Up Raspberry Pi: Install a lightweight operating system and browser.
     2. Display Your Spreadsheet: Use the browser to open and display your Google Sheets or OneDrive link.
     3. **Connect to Screens**: Attach the Raspberry Pi to your displays in the warehouse and office.

Steps to Follow:

1. Choose Your Method: Decide based on your team’s preferences, existing tools, and budget.
2. Set Up: Implement the chosen method, whether it’s using cloud-based tools, digital signage, or custom solutions.
3. Test: Ensure updates are reflected in real-time and that the displays are working as expected.
4. Train Your Team: Make sure everyone knows how to update and manage the spreadsheet.

Each method has its benefits, so select the one that best fits your technical comfort level and operational needs. https://docs.google.com/spreadsheets/d/1hZlKs3F2etnVbhSaAnkcAolQU2FqlC01xXhM6xF7fzM/edit?usp=sharing

When a workbook is co-authoring, all the data is update to date.

Thanks for that.

However, I don't presume the spreadsheet will automatically update on the warehouse & office monitors...?

I basically need to be able to update the excel spreadsheet and have it automatically update on the warehouse and office monitors.

So if something is added, changed or removed, that is seen on those monitors.

Thanks

One way is to use Excel co-authoring. It will show newest changes in your workbook.

Collaborate on Excel workbooks at the same time with co-authoring - Microsoft Support

You may also try embed Excel workbook in web page.

Share it: Embed an Excel workbook on your web page or blog from OneDrive - Microsoft Support