FastBankConvertFastBankConvert home
BlogSign inConvert in seconds

Google Sheets, Numbers and LibreOffice

If you work in Google Sheets, Apple Numbers or LibreOffice Calc, this category is for you. It covers getting PDF data into each app, the import settings that keep columns and dates intact, cleaning text and numbers with each app's own functions, combining months, sharing safely and moving files back to Excel. Read Excel Online vs Google Sheets for Statement Data first if you have not chosen an app yet.

  1. Numbers App Date Format: Fix Imported Dates

    Fix the Numbers app date format when imported dates show as text or in the wrong order: cell format, region settings and re-import.

    Published October 15, 2026apple numbersdatesimport

  2. REGEXEXTRACT in Google Sheets for Statement Text

    Use REGEXEXTRACT in Google Sheets to pull dates, amounts and references out of statement text, with patterns that you can copy and adapt.

    Published September 25, 2026google sheetsregexformulas

  3. Negative Numbers in Parentheses in Google Sheets

    Turn negative numbers in parentheses in Google Sheets into real negatives, or show negatives that way with a custom number format.

    Published September 15, 2026google sheetsnumber formatsnegative amounts

  4. Split Column in Numbers When PDF Data Sticks

    Split a column in Numbers when pasted PDF data sticks together: TEXTBEFORE style formulas, the CSV round trip, and other options.

    Published August 17, 2026apple numbersformulaspdf paste

  5. Fix Dates in Google Sheets After a CSV Import

    Fix dates in Google Sheets that import as text or swap day and month: the spreadsheet locale, DATEVALUE, and splitting dates apart.

    Published August 14, 2026google sheetsdatescsv import

  6. Google Sheets Numbers as Text: Make Them Sum

    Fix Google Sheets numbers stored as text after an import: format changes, VALUE, removing symbols, and the locale setting that causes it.

    Published August 12, 2026google sheetstext to numberimports

  7. Open CSV in Numbers on Mac, iPhone or iPad

    Open CSV in Numbers on Mac, iPhone or iPad: delimiter and encoding settings, dates and leading zeros, and saving back to CSV.

    Published August 8, 2026apple numberscsvmac

  8. Google Docs OCR PDF: The Open-With Trick, Tested

    Use Google Docs OCR on a PDF by opening it with Docs from Drive: what it reads, why tables come out as text, and moving it into Sheets.

    Published July 20, 2026google docsocrscanned pdf

  9. PDF to LibreOffice Calc: Draw, Copy and Import

    Get a PDF to LibreOffice Calc: open the PDF in Draw, copy text, or import a converted CSV, with the settings that keep columns apart.

    Published July 5, 2026libreofficecalccsv import

  10. Combine Multiple Sheets in Google Sheets into One List

    Combine multiple sheets in Google Sheets into one list of months: curly-brace arrays, VSTACK, QUERY to drop blanks, and matching columns.

    Published May 29, 2026google sheetsvstackquery

  11. Google Sheets Cell Limit: Will Your Statements Fit?

    What the Google Sheets cell limit means for converted statements: rows times columns, how many years fit, and what to do near the cap.

    Published May 16, 2026google sheetslimitslarge files

  12. Download Google Sheets as Excel, Formatting Intact

    Download Google Sheets as Excel when someone wants XLSX: what carries over, Sheets-only functions that break, and checking the file.

    Published May 10, 2026google sheetsxlsxexport

  13. ODS vs XLSX: Which Format to Save Your Statements In

    ODS vs XLSX for your converted statements: who can open each, formatting and formula differences, and which to send to other people.

    Published April 28, 2026file formatslibreofficeexcel

  14. Remove Duplicates in Google Sheets Without Losing Rows

    Remove duplicates in Google Sheets after stacking statements: the cleanup tool, UNIQUE, and keeping genuine repeated charges.

    Published April 22, 2026google sheetsduplicatesdata cleanup

  15. Upload Excel to Google Sheets: Convert or Keep XLSX

    Upload Excel to Google Sheets: convert the file or edit it as XLSX, what formatting changes, and the auto-convert setting in Drive.

    Published April 11, 2026google sheetsexcelgoogle drive

  16. Export Numbers to Excel Without Breaking Formulas

    Export Numbers to Excel when someone needs an XLSX: what converts, which functions and tables change, and how to check the exported file.

    Published April 11, 2026numbersexcelxlsx export

  17. LibreOffice Calc CSV Import: The Dialog, Explained

    Use the LibreOffice Calc CSV import dialog well: character set, separators, column types, detect special numbers, and date order.

    Published April 9, 2026libreofficecsv importcalc

  18. Currency Format in Google Sheets for Statements

    Set the currency format in Google Sheets for statement amounts: built-in and custom formats, other currencies, and keeping values numeric.

    Published February 4, 2026google sheetsnumber formatscurrency

  19. Excel Online vs Google Sheets for Statement Data

    Excel Online vs Google Sheets for converted statement data: imports, cleanup tools, row limits, sharing, and which one suits your files.

    Published October 7, 2025excel for the webgoogle sheetscomparison

  20. Split Text to Columns in Google Sheets for PDF Data

    Split text to columns in Google Sheets when PDF data lands in one column: the menu option, custom separators, and the SPLIT function.

    Published June 20, 2025google sheetssplit textpdf paste

  21. Share Google Sheet View Only and Hide Account Details

    Share a Google Sheet view only with an accountant or partner: link settings, blocking downloads, and hiding account numbers first.

    Published May 25, 2025google sheetssharingprivacy

  22. PDF to Numbers on Mac: Getting a Table into Numbers

    Get a PDF to Numbers on a Mac: copy from Preview, open a converted CSV or XLSX, and fix the columns and dates Numbers changes.

    Published April 19, 2025apple numbersmacpdf tables

  23. Google Sheets Slow with Large Data? Lighten It

    Google Sheets slow with large data from statements? Heavy formulas, whole-column ranges, conditional formats and imports, and the fixes.

    Published March 21, 2025google sheetsperformanceformulas

  24. Open CSV in Excel Online Without a Desktop Copy

    Open CSV in Excel online through OneDrive: upload, import options, what the web version cannot do, and saving the result as XLSX.

    Published March 4, 2025excel for the webcsvonedrive

  25. TRIM and CLEAN in Google Sheets for Imported Text

    Use TRIM and CLEAN in Google Sheets on imported PDF text: extra spaces, non-breaking spaces, hidden characters, and the trim tool.

    Published February 14, 2025google sheetstext cleanupformulas

  26. Image to Google Sheets: Table Photos into Cells

    Turn an image to Google Sheets cells: OCR the photo, paste or import the text, and split it into columns, with the limits of each route.

    Published December 1, 2024google sheetsocrphotos