PDF Mikata

Convert Excel Formulas to Values

When you want to share an Excel file without its formulas.

Your files are never uploaded. Everything is processed on this device.

  1. 1Choose an Excel file
  2. 2Check the result
  3. 3Save as values

The file is processed on this device. Nothing is sent anywhere.

Done

🔒 Your files are never sent to an external server. Everything is processed safely inside this browser.

How to use

  1. Tap "Choose an Excel file" and select an .xlsx file.
  2. Check how many formula cells there are.
  3. Tap "Replace formulas with values and save" and save the file.

How it works

  • Formulas are removed and only their results are kept.
  • The original file is untouched; the result is saved as a new file ending in _values.
  • Handy when you do not want to show the calculations to others.

Notes

  • The calculated results saved in the file become the values.
  • If you need up-to-date results, re-save the file in Excel first.
  • Formatting and the look of the sheets are kept.

FAQ

Are my files uploaded anywhere?

No. Everything is processed inside the browser on your device.

Can I get the formulas back?

No. The formulas are gone from the new file. Keep the original file somewhere else.

If PDF Mikata was useful, a small tip would mean a lot.

Send a tip (¥300)Send a gift (Amazon wishlist)

Guides for this tool

How to Convert Excel Formulas to Values (Free)Sharing Excel Without Showing FormulasIs the Formatting Kept?When the Results Are Out of DateGetting the Formulas BackWhen the File Is an Old .xlsIs My Excel File Uploaded?

More tools

Photos to PDFCombine several photos into one PDF in the order you choose. You can rotate, reorder and set a size limit.Merge PDFsCombine several PDF files into one, in the order you choose.Extract or Delete PDF PagesKeep only the pages you need, or remove the pages you don't.Compress PDFShrink a PDF to fit under a size you choose, for upload limits.PDF to ImagesSave each page of a PDF as a JPEG or PNG image.Convert Image Format (JPG, PNG, WebP)Convert images to JPG, PNG or WebP, several at once.Rotate & Reorder PDF PagesFix sideways pages, change the page order, or remove pages.Add Page Numbers to PDFAdd page numbers to a PDF, choosing position and style.Compress & Resize ImagesMake image files smaller, and resize them if you like.Convert HEIC to JPGConvert HEIC photos from iPhone to JPG or PNG.Split PDFSplit a PDF into several files: one page each, every N pages, or by ranges.Crop & Rotate ImageCrop an image to any area or ratio, and rotate it.Extract Text from PDFPull the text out of a PDF to copy or save.Create a Receipt PDFFill in the payer, amount and description to make a receipt PDF. Tax breakdown and invoice registration number are optional.Create a Resume PDF (Japanese Rirekisho)Fill in your details, education, work history and motivation to make a Japanese-style resume (rirekisho) PDF, with an optional ID photo.Create a Timetable / Weekly ScheduleEnter classes, jobs and plans to make a timetable or weekly schedule as a PDF or image, with color coding.Create Business Cards / Name CardsEnter your name and details to make business or name cards laid out on A4 as a PDF. You can also make name tags in bulk from a list.Create a QR Code (URL, Wi-Fi)Make a QR code from a URL, text or Wi-Fi details and save it as PNG, SVG or PDF.Combine PDF Pages onto One Sheet (2-up, 4-up)Arrange several PDF pages on one A4 sheet (2, 4, 6, 8 or 9 up) to save paper when printing.Convert a PDF to Grayscale (Black & White)Turn a color PDF into grayscale or pure black and white, ready for monochrome printing, copying or fax. Choose the resolution.Add a Text Watermark to PDFAdd text such as "For submission", "Copy" or "Confidential" lightly across every PDF page. Choose position, color and opacity.Crop PDF MarginsTrim PDF margins automatically or by setting each edge. Easier to read on a phone, cleaner to print.Black Out (Redact) Parts of a PDFDrag over the parts of a PDF you want to hide and black them out. Redacted pages become images, so the text underneath is gone.View and Remove PDF Properties (Author, Title)See the author, title, software and dates stored in a PDF, then remove or edit them.Fill In a PDF: Add Text, Date, Signature and MarksAdd text, a date, check marks, circles, a handwritten signature or an image (such as a seal) anywhere on a PDF.Resize PDF Pages to A4 or Another Paper SizeMake PDF pages of mixed sizes all the same size, such as A4, A3, B5 or Letter. Text and graphics stay sharp.Delete Pages from a PDFChoose and delete unwanted pages from a PDF.Extract Pages from a PDFPick the pages you need and save them as a new PDF.Reverse the Page Order of a PDFReverse the page order of a PDF.Insert Blank Pages into a PDFInsert blank pages anywhere in a PDF.Split PDF Spreads into Single PagesSplit spreads in a PDF into single pages.Add a Header and Footer to a PDFAdd a title, date or page numbers to the top and bottom of a PDF.Arrange a PDF as a Booklet for PrintingReorder a PDF so it prints and folds into a booklet.Find and Remove Blank Pages in a PDFFind blank pages in a PDF automatically and delete them.Turn a PDF into One Long ImageJoin all pages of a PDF into one tall image.Merge Front and Back Scans into One PDFInterleave a fronts PDF and a backs PDF into one PDF.Resize Images by Pixel SizeResize images by width, height or percentage.Rotate and Flip ImagesRotate images and flip them horizontally or vertically.Add a Text Watermark to ImagesOverlay watermark text such as "Copy" on images.Mosaic or Blur Part of an ImageHide parts of an image with mosaic, blur or a black box.Remove Location and Shooting Data from PhotosRemove GPS, date and camera data from photos and save a clean copy.Apply Black-and-White, Sepia and Other LooksTurn images black and white or sepia, or change brightness.Make a Favicon (Site Icon)Make a complete favicon set from one image.Join Several Images into OneStack or join several images into one image.Crop to ID Photo Size and Tile for PrintingCrop a photo to ID photo size and tile it on an L-size sheet.Pick Color Codes from an ImageRead color codes from an image and find the main colors.Character Counter (for Applications and Reports)Count characters, lines and manuscript sheets of your text.Convert Between Western Years and Japanese ErasConvert between AD years and Japanese eras.Convert Full-Width, Half-Width, Hiragana and KatakanaConvert full-width/half-width and hiragana/katakana.Remove and Tidy Line Breaks in TextTidy line breaks in text copied from PDFs and elsewhere.Calculate Consumption Tax (Incl. / Excl. Tax)Calculate prices incl. and excl. tax.Calculate Age, Days Between Dates and Date OffsetsCalculate age and days between dates.Remove a Password from a PDFRemove the password and restrictions from a PDF whose password you know.Add a Password to a PDFAdd a password needed to open a PDF.Read Text from Images and PDFs (OCR)Turn text in images and scanned PDFs into text.Compare Two PDFs (Find Differences)Show the text differences between two PDFs, color-coded.Generate a Strong Random PasswordGenerate strong random passwords instantly.Calculate Percentages, Discounts and % ChangeCalculate percentages, discounts and % change instantly.Remove Duplicate Lines and Sort a ListRemove duplicate lines and sort them.Unit Converter (Length, Weight, Area, Temperature and More)Convert length, weight, area, temperature and more instantly.Make a ZIP FilePack several files into one ZIP.Open a ZIP File (Unzip)See what is inside a ZIP and extract the files you need.Check a File's Hash (SHA-256)Calculate a file's hash and compare it.Convert CSV and JSONConvert between CSV and JSON instantly.Convert SVG to PNGConvert an SVG file to a PNG image.Convert Files and Base64Convert between files and Base64 text.Format and Validate JSONFormat, minify and validate JSON.Compare Two Texts (Diff)Show the differences between two texts line by line.Convert Excel to CSV or JSONConvert an Excel sheet to CSV, TSV or JSON.Convert CSV to Excel (.xlsx)Convert a CSV to an Excel (.xlsx) file.Extract Text from a Word FileExtract the plain text from a Word file.Extract Text from PowerPointExtract the text of each PowerPoint slide.Put PDF Text into WordExtract PDF text into a Word file.Put Images into a Word FilePut images into a Word file, one per page.Remove Author Info from Office FilesClear the author and other info stored in Office files.Extract Images from Word, Excel and PowerPointExtract images from Office files as a ZIP.Convert Word to HTMLTurn Word text into HTML.Split an Excel File by SheetSplit each Excel sheet into its own CSV or TSV.