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. 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 October 17, 2026google sheetsexcelgoogle drive

  2. 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 October 17, 2026google sheetstext cleanupformulas

  3. 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 October 17, 2026google sheetssplit textpdf paste

  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 October 17, 2026apple numbersformulaspdf paste

  5. 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 October 17, 2026google sheetssharingprivacy

  6. 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 October 17, 2026google sheetsduplicatesdata cleanup

  7. 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 October 17, 2026google sheetsregexformulas

  8. 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 October 17, 2026apple numbersmacpdf tables

  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 October 17, 2026libreofficecalccsv import

  10. 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 October 17, 2026apple numberscsvmac

  11. 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 October 17, 2026excel for the webcsvonedrive

  12. 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 October 17, 2026file formatslibreofficeexcel

  13. 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 17, 2026apple numbersdatesimport

  14. 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 October 17, 2026google sheetsnumber formatsnegative amounts

  15. 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 October 17, 2026libreofficecsv importcalc

  16. 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 October 17, 2026google sheetsocrphotos

  17. 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 October 17, 2026google sheetsperformanceformulas

  18. 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 October 17, 2026google sheetstext to numberimports

  19. 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 October 17, 2026google sheetslimitslarge files

  20. 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 October 17, 2026google docsocrscanned pdf

  21. 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 October 17, 2026google sheetsdatescsv import

  22. 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 October 17, 2026numbersexcelxlsx export

  23. 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 17, 2026excel for the webgoogle sheetscomparison

  24. 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 October 17, 2026google sheetsxlsxexport

  25. 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 October 17, 2026google sheetsnumber formatscurrency

  26. 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 October 17, 2026google sheetsvstackquery