Messy Spreadsheets, PDF Tables, and a Website You Keep Putting Off: Practical Fixes for Small Businesses
Most small businesses don't have a data team or a web developer on staff. They have a spreadsheet that's grown for years, a stack of PDF reports, and a vague plan to "get a website up someday." None of these are big problems on their own, but together they eat time every week. Here are practical ways to handle each one, plus how to tell when it's worth handing off.
1. CLEANING UP A MESSY SPREADSHEET
Spreadsheets get messy for ordinary reasons: data copied from different sources, several people typing in their own style, and columns added "just for now" that never went away. The result is a file where sorting, filtering, and totals can't be trusted.
Start with these steps:
- Make a copy first. Always work on a duplicate so you can compare against the original.
- Standardize text. Use TRIM to remove extra spaces and PROPER, UPPER, or LOWER to make names and categories consistent. "New York," "new york," and "New York " should all become the same value.
- Fix numbers and dates. Numbers stored as text won't add up correctly. Dates in mixed formats sort wrong. Convert them to real number and date formats.
- Remove duplicates, carefully. Excel's Remove Duplicates and Google Sheets' UNIQUE function work well, but only after you've standardized the data. Decide which columns define a duplicate (email address? name plus phone?) before you delete anything.
- Use one row per record and one column per field. Avoid merged cells and blank rows in the middle of data. It makes filters, pivot tables, and formulas work the way you expect.
If you're combining several files, line up the column names first, then use XLOOKUP (or VLOOKUP/INDEX-MATCH) to pull matching information from one sheet into another.
2. GETTING DATA OUT OF A PDF AND INTO EXCEL
PDFs are made for reading, not for working with data. When you need the numbers in a spreadsheet, a simple copy-paste often gives you everything in one column, broken rows, or headers repeated on every page.
A few tips:
- Check what kind of PDF it is. If you can highlight the text, it's text-based and usually converts well. If it's a scanned image, it needs OCR (text recognition), and you should expect to review the results more carefully.
- Try built-in tools first. Recent versions of Excel can import data from a PDF (Data > Get Data > From File > From PDF). For simple tables this can save a lot of time.
- Clean as you go. Remove repeated headers and footers, split combined columns, and convert text to real numbers and dates.
- Verify. Compare row counts and a few totals against the original PDF. This is the step people skip, and it's the one that catches mistakes.
For multi-page reports, statements with inconsistent layouts, or scanned documents, conversion can take a fair amount of careful checking. That's often a good place to bring in help.
3. A SIMPLE LANDING PAGE THAT WORKS ON PHONES
Many small businesses and solo service providers don't need a large website. They need a clear, simple page that answers a visitor's main questions quickly:
- What do you do?
- Who is it for?
- How do I contact you, book, or buy?
A good simple page includes a clear headline, a short description of your service, a few key points or benefits, and one obvious call to action, like a contact form, a booking link, or a phone number. Add your location or service area if it matters, and make sure it loads quickly.
Most importantly, check it on a phone. Text should be readable without zooming, buttons should be easy to tap, and the main call to action should be visible without much scrolling. A page that looks great on a laptop but is awkward on a phone will lose visitors.
Keep it simple to update, too. If changing your hours or prices requires a developer every time, the page will go out of date fast.
WHEN TO HAND IT OFF
All of these tasks can be done yourself with some patience. It makes sense to get help when the job is repetitive, when mistakes would be costly, or when you'd rather spend your time running your business.
That's the kind of work I do: Excel and Google Sheets cleanup, deduplication, merging files, PDF-to-Excel conversion, and formulas, plus simple 1-5 page mobile-friendly websites and landing pages. If you've got a file that needs fixing or a page you've been meaning to build, get in touch. Tell me what you're working with and I'll let you know how I can help.