Technical FAQs

Question

When licensing my PrizmDoc server, I get the error “Unable to write licensing information to the properties file.” Why is this happening?

enter image description here

Answer

To resolve this issue, please try the following:

  1. Re-run the Prizm Licensing Utility as an administrator.

  2. The Prizm Licensing Utility is writing to Prizm/prizm-services-config.yml. See whether you have permissions to edit this file.

  3. Check whether Prizm/prizm-services-config.yml is locked by another process. If you have it open in some text editing software, PrizmDoc may not be able to write to it.

Additionally, if you have an OEM key, you can just manually enter this key into the file by placing the following at the top:

license.solutionName: ENTER_YOUR_SOLUTION_NAME_HERE

license.key: 2.0…rest_of_the_key_goes_here

Question

How accurate is PrizmDoc Viewer’s auto-redaction process? Is there any estimate of the percentage of matches that it will fail to redact?

Answer

If you’re performing auto-redaction as described in our documentation, then all matches for the input regular expression will be redacted in the final document. However, it’s difficult to express that confidence in the form of a percentage. PrizmDoc is subjected to a suite of automatic testing to ensure that its services are behaving as intended, including redactions. We never release a new version unless it passes 100% of those tests.

That being said, the primary way that inaccuracy could enter the system is if you’re attempting to redact scanned documents that have been OCRed. In this case, it’s a matter of your OCR software’s accuracy, rather than the accuracy of PrizmDoc’s redaction process. If the searchable text of the document doesn’t accurately reflect the visible text on the page (for example, if a smudged “discovery” is incorrectly recognized as “disccvery”), then the auto-redaction will be unable to recognize it due to the incorrect input it has been given. This isn’t a problem if the documents were not OCRed.

 

In the finance industry, managing and securing Personally Identifiable Information (PII) is a task of paramount importance, given the stringent regulatory landscape and the vast volumes of sensitive customer data handled daily. The introduction of Artificial Intelligence (AI) in financial content management systems is a game-changer, offering a more efficient, secure, and compliant way of handling PII.

By utilizing AI-powered integrations, Independent Software Vendors (ISVs) and large financial institutions developing in-house solutions can transform the way their applications protect private information in the finance sector.

Tackling Regulatory Compliance with AI

The finance sector operates under a complex regulatory framework with compliance standards specifically tailored to the protection of PII. Traditional manual approaches to adhering to these regulations are not only time-consuming but also fraught with the potential for human error.

AI steps in as a crucial tool for ensuring compliance. By automating the process of compliance checks, AI reduces manual workload and minimizes the risk of non-compliance, thereby safeguarding financial institutions against potential legal and financial penalties.

Managing Massive Data Volumes

Financial institutions are custodians of enormous volumes of customer data. Manually identifying and securing every piece of PII in this vast data ocean is an uphill task.

Here, AI becomes indispensable. With its capacity to process and analyze large datasets efficiently, AI, through machine learning algorithms, can swiftly identify and categorize PII. This provides a scalable and accurate solution to manage and protect large volumes of financial data.

Securing PII in Complex Ecosystems

The finance industry relies on intricate, interconnected systems, with PII often being shared among various entities. Ensuring the security of this data across such a multifaceted ecosystem is challenging.

AI technologies offer a unified approach to PII protection. By implementing consistent security protocols across various financial systems, AI ensures a holistic and integrated strategy to safeguard sensitive information.

Introducing PrizmDoc’s AI Capabilities in Finance

As the finance industry evolves, it’s crucial to introduce innovative solutions like PrizmDoc’s new AI capabilities. Combined with PrizmDoc’s industry-leading redaction features, these tools stand at the forefront for identifying and flagging sensitive PII within financial documents allowing for streamlined reviewing and redaction before sharing documents with other departments.

User-Friendly Functionality

PrizmDoc’s AI functionalities are accessible via APIs, allowing for the creation of workflow automations that are both efficient and secure. Additionally, user interface tools extend AI functionality to end users, making it a practical tool in everyday financial operations.

Streamlined Workflows

Incorporating PrizmDoc’s AI into financial content management systems transforms the landscape of financial operations. This technology streamlines workflows, significantly reducing operational bottlenecks and paving the way for faster and more effective decision-making processes. Additionally, it significantly improves the efficiency of handling and managing financial documents.

Enhanced Security

A key aspect of PrizmDoc’s AI is its enhancement of data security, a critical factor in protecting sensitive customer information. This integration plays a pivotal role in ensuring improved compliance with regulatory standards, a vital requirement in the finance sector. Above all, it elevates the overall quality and reliability of financial services.

PrizmDoc AI Redaction Keeps PII Secure for Financial Applications 

The integration of AI in financial content management systems, especially with advanced tools like PrizmDoc, marks a substantial stride towards more efficient, secure, and compliant financial practices. As technological advancements continue at a rapid pace, the role of AI in reshaping the future of financial data management is becoming increasingly prominent and indispensable. By incorporating PrizmDoc’s AI capabilities into their FinTech applications, developers can offer end users the ability to manage documents more efficiently without putting PII at risk.

Redacting documents is critically important for legal departments and government agencies. By removing sensitive information from a digital file before sharing it publicly, it’s possible to protect private data or classified materials from being exposed. 

In the days before digital documents, redaction involved a simple, if crude, process of covering text with a black marker. Since redactions were done by hand, it was easy for mistakes to be made, which could range from using insufficiently dark ink to leaving portions of text exposed. The development of high-powered photo enhancement has rendered this approach all but useless, as even inexpensive image processing technology can distinguish blacked-out text.

With the transition to digital documents, organizations finally have access to true redaction capabilities. Unfortunately, they still tend to make mistakes when it comes to flattened PDFs that could leave redacted context exposed and vulnerable.

What Is a Flattened PDF?

A modern PDF file consists of multiple layers, each of which can contain separate elements. One layer might feature text, another image, and yet another a fillable form. The flattening process removes all interactive elements from form fields and combines all of the document’s elements into a single layer. 

Organizations frequently used this process to “lock in” form content to prevent anyone from altering the information after a user completes the forms. It also removes elements like dropdown selections within form fields and can burn in other annotations or markups, making them a permanently visible element of the document.

Flattened PDF Redactions

Unfortunately, simply flattening a PDF is usually not sufficient to securely redact a document. That’s because obscured elements are still present in the document; they’re just not visible when the file is viewed and printed. 

Recovering improperly redacted content is actually quite trivial in many cases. Two of the most infamous recent examples include information released during the investigation of political campaign chairman Paul Manafort in 2019 and court documents related to Facebook’s use of personal data in 2017. In both cases, journalists were able to copy redacted text from PDF files and paste it into a text editor to reveal the obscured content.

There are typically two ways that improper redactions occur:

  1. Covering Text with Boxes: This frequent mistake occurs when people try to treat a digital document like a physical piece of paper. They place annotations over the sensitive content, usually in the form of a black box, and then save a flattened version of the PDF thinking that no one will be able to separate the text from the annotation element. As the Manafort and Facebook cases demonstrate, however, getting around these “redactions” is usually quite easy.
  2. Changing the Color of Text: Another common redaction error involves altering the color of the sensitive text to match the document background. Changing the text color to white, for instance, might make it invisible to the human eye, but it does nothing to alter the content itself. The text can be made visible again by using the copy/paste trick described above or by altering the background characteristics in another program. 

The only way to make these methods viable for true redactions would be to actually print the documents with the content hidden and then scan them back into digital form, where OCR could be used to reconstruct a new file. But even in this case, there’s a chance that a powerful OCR engine might be able to pick up the hidden elements.

Using Proper Redaction Prior to Flattening with PrizmDoc Viewer

In order to redact documents securely, applications need to have access to specialized redaction tools that are capable of actually removing content from the document itself before applying redaction indicators. PrizmDoc Viewer’s redaction API can find and extract key text while also providing single or multiple reasons for the removal. 

This not only allows organizations to redact documents quickly, but it also ensures that the redacted information won’t be exposed later because it no longer even exists within the document. More importantly, the outputted document is entirely new, so there is no deleted information to recover. 

While most people are familiar with the distinctive black bars that indicate redacted content, even this leaves behind significant context clues that could provide hints of what was removed. Consider, for instance, a document involving multiple parties where the names of conversation participants have been redacted.

The following information:

PDF Redaction

The length of the redaction, then, would at least indicate when the redaction did not involve one person or the other. There are also many instances involving government documents where the length of the redacted information in classified material might suggest its relevance or importance.

When it comes to GovTech applications that need to remove large portions of information for security reasons, it often helps to perform redaction BEFORE turning a document into a flattened PDF. The PrizmDoc Viewer redaction API can be used to quickly extract text from a document and then redact it as a plain text file

Unlike a static PDF document, plain text accounts for width variations, so all redactions can be replaced with a standardized <Text Redacted> marker that makes it impossible to know the length of the redacted content. The text could then be converted into a PDF after the redaction process is complete.

Take Control of PDFs with PrizmDoc Viewer

As a fully-featured HTML5 viewer, Accusoft’s PrizmDoc Viewer delivers powerful viewing, annotation, and conversion functionality to your web application. It provides a broad range of redaction capabilities that allow legal, financial, and government organizations to keep their sensitive data secure and protect their customers. 

By integrating these complex features into your applications, you can focus your development efforts on building the tools that set your solution apart from the competition while our proven technology powers your customers’ viewing and redaction needs. To learn more about PrizmDoc Viewer’s powerful capabilities, download a free trial and test how it can support and enhance your application.

Question

We have just applied the solution name and key for our cloud license, however, when trying to start the Prizm service, it fails to start.
What could be causing this issue?

Answer

There are a few reasons why this would occur:

  1. The server does not have internet access. Internet access is required for cloud licensing to connect to an S3 bucket.
  2. The server does not have proper rights to access the S3 bucket configured. Please verify the rights to the S3 bucket. Information can be found here: https://help.accusoft.com/PrizmDoc/latest/HTML/prizmdoc-cloud-license-and-aws.html
  3. Verify the solution name is spelled properly. The solution name is case-sensitive.
  4. Verify that the name of the S3 bucket entered in the customer portal matches your actual S3 bucket name. The S3 bucket name is case-sensitive.
Question

As a customer, I want to know the anticipated amount of time that you will continue supporting my specific version so that I can plan our releases ahead of time.

Answer

We currently have our Support Policy located below.
Please see the section named Product Versions

https://www.accusoft.com/company/legal/support-policy/

Question

We have been noticing in our PrizmDoc environment that the viewer seems to take longer and longer to view documents over time. After a few days, we restart the Prizm services, and the Viewer processes faster. What might be the reason for this issue?

Answer

This issue is typically caused by a change in the core count of the server after PrizmDoc has been installed. Specifically, the non-interactive heap size will not automatically update if the core count is changed after PrizmDoc has been installed. We update this value during install.

If you have made changes to the core count of the server after installation, please see the following page for correlation between the non-interactive heap size and the CPU cores count:
https://help.accusoft.com/PrizmDoc/latest/HTML/registry-changes.html?highlight=heap%2C.

The reason the non-interactive heap size matters here is because it affects performance of the Office and HTML conversion services, and the symptom of insufficient non-interactive heap size is soffice.bin crashing.

Question

Sometimes, when redacting an Office or PDF document, redactions drawn over certain content (such as an image or a logo) appears to get burned on other occurrences of the image on other pages. Why does this happen?

Answer

The reason why the duplicate redactions are occurring is because the images are shared images. In PrizmDoc, when a change is made to one instance of the shared image, it gets applied to every other instance. Per engineering, this is to mimic the behavior of Adobe Acrobat.

There currently exists a feature request to allow shared images to be treated as individual images so that they could be redacted separately:

https://ideas.accusoft.com/ideas/PDV-I-655

Question

I am integrating PrizmDoc using just the API to convert documents, and I am noticing an initial delay of about 10 seconds before the conversion starts.

Why is this happening?

Answer

One of the likely reasons this could happen is if your PrizmDoc Server is not licensed properly or if you are running in the Evaluation mode. In such cases, there are restrictions in place.

Among those restrictions is an artificial delay of 10 seconds imposed before viewing or conversion operations begin. A dialog window normally indicates this in the Viewer interface, but if you are just making API calls to the server, it will not be apparent.

A valid product license is required to eliminate these restrictions, which can be done as follows: https://help.accusoft.com/PrizmDoc/latest/HTML/prizmdoc-server-docker.html#2-configure-your-license.

Since they first rolled out in supermarkets in the 1970s, barcodes and barcode scanners have become essential tools in today’s globalized economy. No longer confined to retail shelves and supplier warehouses, barcodes are used across multiple industries to streamline operations and improve data accuracy. Given their continued importance, it’s helpful for developers to keep the key advantages of barcodes in mind as they build applications that could benefit from them.

Four Key Barcode Benefits

1. Efficiency

Since scanning a barcode automatically enters a large amount of data into a system, they are incredibly valuable for streamlining recordkeeping and improving efficiency. Modern supply chain and inventory management simply would not be possible without the use of barcodes. Rather than manually entering inventory and shipment data for every item into a system, employees can simply scan entire pallets, crates, and even shipping containers to instantly know what contents they contain inside. Given the sheer scale of products moving through a supply chain, barcodes allow companies to automate a key process to save time and money even as they scale operations. Barcode scanners can also streamline onboarding and training since it takes much less time to teach someone to use a scanner than to manually enter data.

2. Error Reduction

Manual data entry is notorious for its high levels of human error. According to research conducted over several decades, even workplaces with the best performance measures in place see human error rates of five to ten failures in every hundred opportunities. That’s a lot of opportunities for things to go wrong, whether it takes the form of inverted characters, skipped lines, misreadings, illegible markings, or faulty keystrokes. Even worse, once an error occurs, it will often be reproduced across a system, making it very difficult to locate and remediate the original mistake. According to one estimate, errors resulting in bad data cost businesses more than $600 billion each year. Scanning a barcode, by contrast, completely automates the data entry process and significantly reduces the risks associated with manual errors. Information encoded into a barcode will be reproduced accurately each and every time the image is scanned to ensure consistency across systems.

3. Tracking

Each time a barcode is scanned, it creates another step in a data trail that can be easily referenced to locate items and events. This allows businesses to greatly improve real-time visibility into their operations. From identifying a shipment’s most recent location or determining whether or not a patient picked up their prescription from a pharmacy, barcodes help organizations and customers alike to track down information quickly and accurately. By improving visibility throughout their systems, companies can deliver a better customer experience that builds trust and prioritizes transparency. Since barcodes are easy to create and print, they can be added to almost any type of business process to streamline productivity and track essential activities.

4. Data Collection

Today’s organizations rely heavily upon data analytics to formulate their business strategy and make key decisions. The more data they have available to them, the more nuanced and accurate their analysis will be. Barcodes play a critical role in data collection strategies. Not only are they used to gather information about inventory, supply chain, and sales activity, but the latest generation of QR codes (a common form of 2d barcode) are also being deployed to learn more about customer behavior and preferences. Thanks to real-time QR code tracking, companies can see how many times the barcode is scanned, where it was scanned, and what devices were used to scan it. Gathering more extensive barcode data provides a more detailed picture of what’s actually happening “on the ground” throughout an organization and in the market. By eliminating conjecture and guesswork, businesses can make much more informed decisions that will help them to sustainably scale operations and capitalize on opportunities.

Barcode Use Cases by Industry

Although most commonly associated with retail and logistics, barcode scanners are deployed across many industries to improve efficiency and accuracy. Here are a few of the most common use cases:

  • Education: From student ID cards to tracking school equipment, educational institutions utilize a variety of barcode types and barcode scanners to streamline operations.
  • Government: Federal, state, and local governments use barcode scanning to manage access to secure facilities, catalog physical assets, and organize records. The ability to quickly create barcodes is essential for agencies that need to catalog and track documents and materials.
  • Legal, Insurance, & Finance: Various forms of barcodes can be used to improve document management, making it easier to track and organize contracts, applications, and invoices as well as flag sensitive documents that require additional security precautions.
  • Healthcare: Barcodes have long been used to streamline hospital processes such as admitting patients and accessing patient records with a simple scan rather than a protracted (and error-prone) manual process. They are especially useful for managing medications and ensuring that critical prescription information like strength and dosage remains accurate and consistent.
  • Retail: A classic use case for barcode scanning, retailers use barcodes every day to manage their inventory, track sales, and reduce shrink. Handheld barcode scanners have made it easier than ever for them to process transactions, access product information, and locate products.
  • Supply Chain: Barcode scanning technology has helped to automate key elements of logistics across multiple industries. As companies continue to do business around the world, the ability to easily track shipments and provide information to customs authorities is more crucial than ever before.

Implementing Your Barcode Solution

Despite the clear benefits of barcodes, many applications lack the basic functionality necessary to read barcodes, much less write them. Luckily, integrating those features is easy to do with the help of a code-based SDK barcode toolkit like Accusoft’s Barcode Xpress. With support for more than 30 barcode types and the powerful image processing capabilities that can clean up and repair barcodes that are broken, damaged, or poorly printed, Barcode Xpress can enhance the functionality of barcode scanners or allow Windows and Linux-based systems to locate and read barcodes on documents. Capable of reading up to 1,000 pages per minute, Barcode Xpress can turn your application into a barcode scanning powerhouse. Visit our product overview to learn more about how Barcode Xpress can solve your application’s barcode scanning needs.  

Here at Accusoft, we’re always looking for new ways of connecting people with progress to improve productivity and drive innovation. It’s why we put so much work into our standards-based APIs and SDKs. We understand that developers need mature integrations that are ready to enhance their applications from day one and will be supported by extensive, accurate documentation. From the onset of 2020, we had a strategy in place to help us focus on making it easier for our customers to solve their business problems.

And then, well, 2020 happened…

As this challenging year finally comes to a close, we wanted to take a look back at how we adapted to stay focused on our enduring mission to deliver better products and services to our customers.

2020 Customer Advisory Board Meetings

Since most of our products are delivered through APIs and SDKs, we often encounter situations where our customers and partners independently purchase, download, and extend applications with minimal interaction. Historically, this made it difficult to gain insight into how our clients utilized many of our solutions and what features they would like to see from them in the future.

That’s why we hosted our first Board of Connectors (BoC) meeting in 2019 to bring customers and product managers together in an ongoing dialogue about business needs and product strategy. These meetings also had the benefit of allowing our customers to build relationships with our internal teams, provide feedback on product features, share their business challenges, and discuss key development trends impacting their respective industries.

We had the good fortune to hold our first BoC meeting in-person before the COVID-19 pandemic forced us to adopt rigorous social distance and work-from-home protocols for the safety of our employees and customers. Our second meeting took place in virtual format later in the year, which allowed us to learn first-hand how our customers were dealing with pandemic pressures and how we could adjust our product strategies to meet their rapidly shifting needs.

An Eventful 2020 for PrizmDoc Viewer

One of the principal beneficiaries of these meetings was our popular PrizmDoc Viewer solution. As a best-in-class HTML5 viewer, PrizmDoc Viewer was already a powerful and versatile viewing integration capable of enhancing a variety of applications. But if there’s one thing we’ve learned over the years, it’s that there’s always room for improvement.

That’s why we made it a point of emphasis to implement the top five requests we heard at the first BoC meeting of 2020. Despite all the disruption of COVID-19, we’re incredibly pleased that we were able to deliver on every one of these requests. We also rolled out a host of new product features and continued to optimize PrizmDoc Viewer for improved performance.

Here’s a quick rundown of the five big PrizmDoc Viewer upgrades of 2020:

v.13.11: February 2020 

For the first release of the year, we focused on improving performance when viewing large raster images. We also wanted to make PrizmDoc Viewer easier to install and upgrade.

What we did:

  • Improved the PrizmDoc Viewer Raster Conversion Service to significantly reduce memory consumption and reduce the time it takes to generate raster tiles when viewing large image files.
  • In addition to our traditional installers for Windows and Linux, we released new PrizmDoc Server and PrizmDoc Application Services (PAS) Docker images for production deployments, making the setting up of the PrizmDoc Viewer backend dramatically easier.
  • Released a new .NET SDK for PrizmDoc Server – for .NET developers doing backend document processing with PrizmDoc Server this wrapper around the PrizmDoc Server REST APIs makes it easy to use PrizmDoc Server functionality in .NET.
  • Upgraded the PrizmDoc Server installer to allow for in-place upgrades so users no longer need to uninstall the previous version before installing the newest version.

v.13.12: April 2020 

For the second release of the year, we expanded our use of Docker technology to make PrizmDoc Viewer easier to evaluate. We also worked to improve the performance and stability of PrizmDoc Server.

What we did:

  • Released a new evaluation Docker image that provides a demo web application to explore the viewer and its features, and start a complete PrizmDoc Viewer backend to begin using for local development.
  • Updated online help with a new look and feel for easier navigation. Added a new getting started topic for streamlined evaluation, and initial integration topic for an easy transition after evaluation. 
  • Improved performance and stability of PrizmDoc Server when viewing complex PDF documents.

v.13.13: June 2020 

This release saw the rollout of a new redaction feature along with myriad performance improvements.

What we did:

  • Provided support for multiple redaction reasons via our client API so users can apply more than one reason, selected from a customizable list, to any redaction reason. Reasons appear on top of the black box of redacted content and can be burned into a downloadable PDF along with the rest of the redacted content. Developers can also import a pre-built set of redaction reasons from an existing JSON file for streamlined end-user application.
  • Improved conversion times and memory consumption when viewing multi-page DWF documents.
  • Improved performance when retrieving revision data and scrolling through results when comparing two versions of a Word document.

v.13.14: September 2020

The fall release saw new support for viewing email attachments, more redaction features, and continued improvements to the upgrade process.

What we did:

  • Added support for opening email attachments in the same viewer window where the original email is being viewed. Improved the client UI to show email attachments in a compact dropdown menu.
  • Added server-side support for multiple redaction reasons using the Redaction Creators API.
  • Released the ability to draft redactions without obscuring the content, allowing users to produce PDF documents with transparent redactions that display the document content underneath the redaction rectangles.
  • Added the ability to retain configuration setting when upgrading PrizmDoc Server and PAS.

v.13.1: December 2020

The final update of 2020 focused primarily on reducing resource strain, but also saw the release of new sample code and added new Java Virtual Machine (JVM) controls.

What we did:

  • Optimized log entries for the PrizmDoc PDF processing service to dramatically reduce log file size and storage needs.
  • Enhanced PrizmDoc service health detection to automatically return to healthy status as soon as a failed backend service returns to normal operation, eliminating a potential need to restart PrizmDoc Server.
  • Released two new Angular samples on GitHub: a .NET backend sample and a Java backend sample.
  • Added new parameters in central configuration that provide controls for JVM settings when starting PrizmDoc Server Java-based services.

What’s Next for 2021?

Following our virtual BoC meeting in Q3, our product teams have been hard at work developing new features for the upcoming year that will continue to meet the diverse use case needs of our clients’ applications. We want to build on our successes in 2020 when it comes to engaging our customers and using their direct feedback to make beneficial and lasting improvements to our family of SDK and API solutions.

If you’re currently using our products and would like to participate in one of our upcoming BoC meetings for 2021 to submit feedback or learn about future releases, contact us today! We’re looking forward to working with you in the new year!

Many organizations utilize spreadsheets to track data and perform complex calculations. Since spreadsheets offer substantial flexibility, it’s not uncommon for a single organization to use them in a variety of ways. For instance, one department might use them for budgeting while another deploys them for risk assessment. Although they can handle complex calculations, spreadsheets are relatively easy to set up and don’t require the same programming knowledge as more specialized solutions. That accessibility has led many organizations to simply convert Excel to web applications using API integrations rather than building new functionality from scratch.

Why You Should Convert Excel Files to Web Applications

Consumers often turn to financial and insurance companies looking for simple answers to simple questions: 

  • How many payments will it take to eliminate my debt?
  • Will adding another person to my insurance policy change my rate?
  • What will the monthly payments on my loan cost based on different interest rates?

To answer questions like these, someone in the organization typically enters the customer’s data into a premade spreadsheet, applies a few conditions using preset formulas, and shares the result. This process could be significantly streamlined by making these calculations readily available as a web application to anyone who visits the firm’s website, allowing both prospective and current customers to get answers quickly while also freeing up time for employees to work on more high-value tasks.

Unfortunately, building a secure, functional web application takes up valuable development resources. A developer could easily spend weeks converting complex spreadsheet formulas into a fully-functional application that integrates into the website or larger platform seamlessly. Even worse, if anything about those formulas were to change (as is often the case with financial and insurance formulas), more development resources will need to be pulled away from existing projects to make the updates.

By converting Excel files to web applications, firms can avoid these problems and provide clients with ready access to the calculations they need. FinTech and InsurTech developers can accommodate this need by building integrations into their solutions that allow users to easily upload and share spreadsheets entirely within an application and without any Microsoft Word dependencies. This bypasses the time-consuming build process and makes it much easier to update the formulas as needed.

Keeping Your Spreadsheets Secure

Of course, making spreadsheets readily available as web applications presents a few important security challenges. Many of the calculations running inside an organization’s spreadsheets are proprietary or contain hidden data that needs to remain private for various confidentiality reasons. That’s why companies are hesitant to simply send copies of their internal spreadsheets to customers or vendors. If those Excel files are made accessible online, there’s an obvious risk that someone could download a copy for themselves or access valuable private intellectual property.

Incidentally, this is also the reason why many firms struggle with sharing spreadsheets even in a collaborative environment. Not only are .XLSX files among the most commonly used file extensions by malware, but granting cloud providers or email servers access to spreadsheets represents too great a security risk for companies in heavily regulated industries.

By converting Excel to web applications, however, organizations can maintain strict access and visibility controls over their spreadsheet files. A good spreadsheet viewer integration will allow users to determine what people see when they use the application and also what information they can access. Formulas and calculations that contain vital intellectual property can be hidden completely. Visitors can be restricted to only editing cells that apply to their information, allowing them to use the spreadsheet without breaking or altering its functionality.

Sharing controls can also restrict what can be downloaded locally. A visitor may need to download or print a copy of their calculations, but they don’t need to download a fully functional copy of the spreadsheet file. Even in a collaborative environment, allowing people to download and edit copies of a spreadsheet can introduce significant version confusion. By keeping everything safely within the confines of the organization’s larger web application, essential data remains as secure and up-to-date as possible.

Other Reasons to Convert Excel to Web Applications

The versatility of spreadsheets allows people to adapt them to a variety of uses. In addition to more traditional budgeting and adjustment tasks, they can also be used for things like calculating survey results, analyzing resource usage, or estimating server uptime. Adding customizable calculators that provide quick results to a website experience can provide customers with important information and keep them engaged. 

Rather than building a specialized app or plug-in for every one of these calculators, organizations can simply use a spreadsheet viewer integration to quickly create one without any specialized coding or development knowledge. When the integration is set up within their solution, they can even customize it to match their branding and make it look more like a designed application than a simple spreadsheet.

Explore the Potential of Spreadsheet Integration with PrizmDoc Cells

Accusoft’s PrizmDoc Cells was originally designed to help our clients securely view and share XLSX files without any third party dependencies, but it’s increasingly being used to help improve customer experiences across a variety of applications. Get a hands-on experience with this API-driven integration to explore the potential of converting your Excel files to web applications. For a more detailed overview of what you can do with PrizmDoc Cells, sign up for a free trial.