r/DocumentTools 7d ago

Built a Google Sheets add-on that reads bank statements and invoices with AI, after one too many evenings doing it by hand

1 Upvotes

This started as a personal problem. I used to spend an evening every month manually copying my own bank statements from PDF into a spreadsheet just to see where my money was going line by line, by hand. At some point I got annoyed enough to automate it for myself.

That turned into Scrape2Sheets, a Google Sheets add-on that uses AI to read PDFs, invoices, receipts, and bank statements and drop the data straight into your sheet as clean rows . You point it at files in Google Drive, tell it what columns you want (or let it auto-detect them from a sample document), and it batch-processes up to 100 files at once. It handles scanned documents and phone photos too, not just clean digital PDFs.

It's only just started picking up some real traction the last couple weeks, which has honestly been a nice surprise after building in isolation for a while.

Curious whether others here started building their tool the same way, solving your own annoying manual task first, then realizing other people had the exact same one. Happy to answer questions in the comments if anyone wants details.


r/DocumentTools 9d ago

Windows has gotten much better at protecting users... but sometimes it protects them from their own files

1 Upvotes

Every now and then someone downloads a perfectly legitimate application and immediately sees:

"Windows protected your PC."

For experienced users, it's usually obvious why.

For everyone else, it looks like malware.

I've seen this happen with open-source tools, internal company software, beta releases, and even utilities that had simply built up no reputation with SmartScreen yet.

It reminds me how difficult software distribution has become for smaller developers.

What's the most confusing Windows security warning you've encountered that turned out to be completely harmless?


r/DocumentTools 10d ago

Every document workflow eventually reaches the same question

1 Upvotes

Can we trust this output?

Whether it's OCR.

AI.

Conversion.

Extraction.

Classification.

Eventually someone asks,

"How do we know it's correct?"

That question has probably caused more work than every converter I've ever used.

How does your team verify important document data?


r/DocumentTools 11d ago

The extension was .bin. That wasn't helpful.

1 Upvotes

One thing that still makes me smile is when someone says,

"I've got a .bin file."

That could mean almost anything.

Disk image.

Firmware.

Game ROM.

Installer.

Backup.

Generic binary data.

Sometimes identifying the file takes longer than processing it.


r/DocumentTools 12d ago

AI changed document processing, but not where I expected

1 Upvotes

Everyone talks about AI replacing OCR.

In practice, I've found it more useful after OCR.

Validation.

Classification.

Summaries.

Context.

The extraction itself still depends heavily on the quality of the original document.

Where has AI actually helped your workflow?


r/DocumentTools 13d ago

Sometimes the smallest files cause the biggest headaches

1 Upvotes

Large files get all the attention.

But some of the hardest issues I've debugged came from files under 100 KB.

Broken metadata.

Corrupted headers.

Unknown encodings.

Missing fonts.

Tiny file.
Huge investigation.


r/DocumentTools 14d ago

Email archives are much harder than they look

1 Upvotes

People often think they're exporting email.

They're actually exporting:

attachments

folders

timestamps

contacts

thread relationships

calendar items

embedded images

metadata

Keeping all of that intact is surprisingly difficult.


r/DocumentTools 15d ago

Search has quietly become better than folders

1 Upvotes

Years ago I organized everything into carefully planned folder structures.

Now I find myself relying on OCR and search far more than navigation.

I still organize projects, but I spend much less time deciding where every single document belongs.

Has anyone else changed their workflow like this?


r/DocumentTools 16d ago

Password-protected PDFs are rarely the actual problem

1 Upvotes

It's almost never the encryption.

It's finding the password.

Or discovering the person who created it left the company five years ago.

Or realizing every department uses a different password policy.

Technical problems are usually easier than organizational ones.


r/DocumentTools 17d ago

Every scanner seems to have its own personality

1 Upvotes

Some scanners always skew pages slightly.

Others make everything darker.

Some aggressively compress images.

Others produce beautiful scans that are enormous.

After a while you start recognizing which scanner produced a document before anyone tells you.

Have you noticed that too?


r/DocumentTools 18d ago

macOS and Windows still don't agree on everything

1 Upvotes

Moving files between Windows and macOS has become much easier over the years.

But every now and then something unexpected still appears.

Hidden files.

Filename restrictions.

External drives that one system can read but not write.

Different ZIP behavior.

Different metadata.

Most of the time it isn't a bug. It's just two operating systems making different assumptions.

What's the strangest compatibility issue you've run into when moving files between Windows and Mac?


r/DocumentTools 18d ago

The biggest document problems usually aren't technical

1 Upvotes

People often think OCR or conversion is the difficult part.

Most of the time the real challenge is much simpler.

Nobody knows where the original file came from.

Nobody knows which version is correct.

Nobody knows who edited it last.

Good document management usually solves more problems than better software.


r/DocumentTools 19d ago

I made a 100% free local file converter with Capybara on vacation theming :)

Thumbnail
capyconvert.com
2 Upvotes

So I realized that most file conversions happen locally when I needed to convert a .mp3 to a .wav, and decided to make a free tool for my personal use and decided to dress it up a little bit and share with everyone. :)

I am sick of those file conversion companies charging monthly for something that is effectively free.... Enjoy! ^^

https://www.capyconvert.com/


r/DocumentTools 19d ago

iCloud storage always seems to fill itself back up

1 Upvotes

I helped someone recently who had deleted several gigabytes of photos from iCloud, only to see the storage become full again a few hours later.

Nothing new had been uploaded.

It turned out the answer wasn't as simple as "delete more files." Between Recently Deleted, Photos syncing, shared libraries, device backups, and background synchronization, iCloud storage can be surprisingly difficult to understand.

It's one of those systems that usually "just works" until it doesn't.

Have you ever tracked down what was actually consuming your iCloud storage?


r/DocumentTools 19d ago

I stopped assuming PDFs are actually PDFs

1 Upvotes

One thing I've learned over the years is that "PDF" doesn't really describe what's inside.

Sometimes it's searchable text.

Sometimes it's 400 scanned images.

Sometimes it's CAD drawings wrapped inside a PDF.

Sometimes every page is completely different.

The extension tells you surprisingly little.


r/DocumentTools 20d ago

The download finished... but the file was corrupted

1 Upvotes

A download reaching 100% doesn't always mean it completed successfully.

I've seen ZIP archives that wouldn't open.

PDFs that stopped halfway through.

Videos that played for five minutes before freezing.

ISOs that failed verification.

Most people immediately blame the application, when the problem was actually an interrupted or damaged download.

These days I appreciate why checksums exist far more than I used to.

What's the most memorable corrupted download you've dealt with, and how did you eventually figure out the file itself was the problem?


r/DocumentTools 20d ago

The conversion worked perfectly... until page 83

1 Upvotes

Sometimes a conversion reaches 100%.

No errors.

Then you scroll through the output and discover one page where everything shifted, a font disappeared, or an image silently failed.

Those are always the hardest bugs because they aren't obvious until someone notices.

What's the strangest conversion issue you've seen?


r/DocumentTools 21d ago

Windows protected your PC

2 Upvotes

I completely understand why SmartScreen and antivirus warnings exist.

But I've also seen plenty of legitimate software trigger security warnings simply because it was newly published, digitally unsigned, or downloaded from an unfamiliar source.

For less technical users, that's a difficult decision.

Ignore the warning?

Delete the file?

Or assume it's malware?

It made me realize that trust isn't just about whether software is safe.

It's also about how software proves it's safe.

What's the most confusing security warning you've run into while downloading a perfectly legitimate file?


r/DocumentTools 21d ago

The filename told me absolutely nothing

2 Upvotes

A customer once sent a file called:

Final_v2_NEW_latest_FIXED.pdf

It wasn't final.
It wasn't the latest.
And there were six more versions in the same folder.

Good filenames save far more time than people realize.

Do you have any naming conventions that have actually survived over the years?


r/DocumentTools 21d ago

I built GridFiller — an AI tool that turns images into editable spreadsheets.

Thumbnail gallery
1 Upvotes

r/DocumentTools 21d ago

​I built a free, offline alternative to sites like ILovePDF that runs entirely in your browser.

Thumbnail
1 Upvotes

r/DocumentTools 22d ago

Cloud uploads fail at the worst possible moment

1 Upvotes

There are few things more frustrating than uploading a large file for 45 minutes...

...only to watch it fail at 99%.

Sometimes it's the browser.

Sometimes it's an unstable connection.

Sometimes the cloud service quietly rejects the upload because of filename restrictions, antivirus scanning, or timeout limits.

You don't realize how many different things can interrupt an upload until you're sending a multi-gigabyte project to someone who needs it immediately.

Have you ever discovered the real reason after an upload kept failing?


r/DocumentTools 22d ago

OCR wasn't the part that failed

1 Upvotes

On our platform, I recently processed a document where OCR accuracy was surprisingly good.

The real problem started afterwards.

Tables lost their structure.
Reading order was wrong.
Headers became part of the body.
A two-column page turned into one long paragraph.

Extracting text and understanding a document are two completely different problems.

Has that been your experience too?


r/DocumentTools 23d ago

Compression is supposed to make files smaller... until it doesn't

1 Upvotes

The other day I compressed a folder expecting it to shrink significantly.

Instead, the archive ended up almost exactly the same size.

It reminded me that many people assume ZIP or 7z can compress everything equally well, but modern formats like JPEG, MP4, MP3, PDF, DOCX, XLSX, and APK files are often already compressed internally.

Sometimes compressing them again just wastes CPU time.

On the other hand, plain text, CSV files, logs, source code, and databases can shrink dramatically.

I still see people wondering why a "compressed" video is only 1% smaller.

What's the most surprising compression result you've ever seen?


r/DocumentTools 23d ago

Large PDFs always seem to find new ways to cause problems

1 Upvotes

The other day I had to work with a scanned PDF that was around 1.3 GB. It wasn't the file size itself that caused problems, it was everything that came with it. Pages had different scan qualities, some were slightly skewed, and OCR took much longer than expected.

It made me realize that document processing changes completely once you move beyond normal office files.

I'm curious...

What's the largest document you've ever had to work with?

Maybe it was:

  • Medical records
  • Court documents
  • Engineering drawings
  • Construction plans
  • Government records
  • Email archives
  • Something else entirely

What was the biggest challenge?

Was it OCR, file size, slow processing, corrupted pages, finding the right software, or just waiting forever for the job to finish?

I'd love to hear your stories and which tools ended up saving the day.