utils logo UTILS
Free online tools to generate, calculate,
convert, format, encode, and play.
 

Spreadsheet Editor

A lightweight in-browser spreadsheet; enter data, write formulas like =SUM(A1:A5), =AVG(B1:B10) or =IF(A1>10,"high","low"), then sort, filter and export to CSV or XLSX. Everything runs locally in your browser.

A1 fx

Sort

Filter

Import / Export

When "Export computed values" is on, formulas are replaced by their results; otherwise the raw formula text is exported.

How It Works

Cells & References

Columns are labelled with letters (A, B, C…) and rows with numbers, so each cell has an address like A1 or C4. Click a cell to edit it directly, or use the formula bar at the top. A cell holds plain text, a number, or a formula. anything that starts with = is treated as a formula.

Formulas

Formulas support cell references, ranges (e.g. A1:A5), the arithmetic operators + - * /, parentheses, and comparisons (= <> < > <= >=). The following functions are available:

SUM(range) AVG(range) AVERAGE(range) MIN(range) MAX(range) COUNT(range) IF(cond, a, b) ROUND(x, n) ABS(x)

Examples

  • =SUM(A1:A10). adds every number in the range.
  • =AVG(B2:B8). averages the numeric cells in the range.
  • =IF(C1>100, "over", "ok"). returns text based on a condition.
  • =(A1+A2)*B1. mixes references, arithmetic and grouping.
  • =ROUND(SUM(A1:A3)/3, 2). nests functions and rounds the result.

Formulas recalculate automatically as you type. Circular references show #CIRC and invalid formulas show #ERR.

Sorting & Filtering

Sort reorders the data rows by the chosen column, ascending or descending, with an option to keep the first row pinned as a header. Filtering hides rows that do not match a condition without deleting them. clear the filter to show everything again. You can also click a column header to sort by that column instantly.

Import & Export

Import a CSV file to populate the grid, or export your work as a CSV or XLSX file. Exporting computed values turns formulas into their results, which is handy for sharing final numbers; turn it off to keep the formulas.

Privacy

Everything happens in your browser. no data is uploaded to any server.

Embed This Util

You can embed this util on your own site as a widget. Adding ?embed=1 to the URL loads a compact version with just the tool itself; no header, menu, or documentation. Paste this snippet into your HTML: 


    

       Copy snippet
      Adjust the height to taste.
    

  




  


  

          

    
 Related Utils

    

      

        
           Excel to JSON
        
        
           Table Formatter
        
        
           CSV Sorter
        
        
           JSON & CSV
        
        
           Mock Data
        
      

    

  


          

          

          

              Feedback
          

          

            

              Help us improve this page by providing feedback,
              and include your name/email if you want us to reach back. Thank you in advance.
            

            

              
              

              
            

          

          
          
          
          

          

            Share with