Spreadsheet editing software

Main Features: Simple Spreadsheet, as the name implies, allows text and formula entry to handle lists and basic calculations.

You can also format color of cells to help readability. Unlike many mobile spreadsheet apps, you can customize the width of your columns and the height of your rows, and autofit them as well. Compatibility: It is only compatible with itself. You can save spreadsheets to be opened on the Android device they were created on, and share them as.

Best Use Case: Simple Spreadsheet is best for personal, casual use to manage easy calculations and lists on your Android smartphone while on the go. WPS Office - Spreadsheets. Their suite of apps are completely free without ads, though they do have more robust paid desktop versions of the same apps, including PDF editing capabilities. You can open multiple worksheets at once, and the product is as slick and fast as any desktop spreadsheet app. It can import and export to all of these, and be accessed by the same apps on other devices, including desktop.

For storage, it supports Google Drive and Dropbox. How to Set Up a Sheet: There are dozens of templates to choose from to get started. To make your own, click Create a blank sheet. Enter or import data. Create charts and graphs, which can be dragged, dropped, and resized. Polaris Office - Spreadsheets. About the Company: Polaris Office makes productivity software for desktop and mobile, targeted both towards casual and business users.

It features hundreds of formulas and dozens of 2D and 3D charts, compatibility with most other spreadsheet formats, and built-in cloud storage called Polaris Drive. Additionally, the mobile versions of the app allow for hand drawn notes, lines and shapes for intuitive editing. You can share spreadsheets through unique URLs in emails, IM, or even Twitter and Facebook in order to view them in their most up-to-date version.

The mobile version also offers the ability to select and drag multiple objects at once. Documents can be saved in Polaris Drive and edited from multiple locations, so changes are kept intact. How to Set Up a Sheet: There are many templates to get started with.

OfficeSuite - Spreadsheet Editor. About the Company: MobiSystems is a creator of desktop-grade mobile productivity apps, and is fully-featured for anytime, anywhere use. Their focus is compatibility, so you can open any type of file without losing formatting. Their software comes preloaded on a number of tablets and Chromebooks. Main Features: Though it is a mobile-focused platform, OfficeSuite has nearly every feature that desktop spreadsheet apps have.

It can track changes with multiple authors, make real-time changes on-the-fly that affect your data and graphs, format, find and replace, and even text-to-speech. All of its functionality - ike selection, editing, and highlighting - is mobile-friendly, though its upper ribbon is so fully-stocked that you must scroll through it on a small screen, and it can take time to remember the location of everything.

The free version has ads, and strips out some important functionality like protecting and encrypting sheets, and creating tags for certain types of data. Best Use Case: It is best for users who want to get the most formulas, functions, fonts, and even look of Excel without the price tag.

How to Set Up a Sheet: OfficeSuite has just nine spreadsheet templates that are all for basic functions. Setting up sheets is identical to Excel. Quip Spreadsheets. About the Company: Quip is a subsidiary of Salesforce and is focused on collaborative productivity apps that include instant messaging and cloud storage. The company began independently, so their focus is entirely on updating their productivity offerings.

It functions like most spreadsheets, but on a white background with word processor-like text areas to add context to your sheets. These areas can contain linkable data, like values that update in real-time, or you can tag team members in the Quip ecosystem.

It can also use special column properties like Contacts and check boxes along with conditional formatting for tasks like project management. Any spreadsheet you create can be transformed into a table and inserted into a Quip document for easy presentation and sharing. Automation: It can pull in contacts synced with its ecosystem, such as your Quip teams, or with Salesforce for enterprise users who also have Salesforce. Compatibility: Import spreadsheets from virtually any cloud storage service, and from Excel documents.

Documents to Go - Sheets To Go. Main Features: Sheets To Go is a fairly complete free spreadsheet tool for simple calculations and access to most popular cloud drives for importing and exporting.

It was built explicitly with touchscreens in mind, first for iPad. It bills itself more as an Excel editing platform for mobile work and review than as a true generator itself. Its main differentiator is the use of a larger font for ease of reading. Mobility: It is available for Android and iOS devices, along with a desktop sync app that lets you store your documents there.

About the Company: Savy Soda makes a variety of iPhone and iPad apps, all of which are lightweight with slick graphical presentation. Main Features: iSpreadsheet is an iOS-exclusive app that allows a wide range of arithmetic calculations and the ability to import and export your Excel and Numbers projects via any cloud storage for editing on the go. Mobility: It is mobile only, and can save files to most cloud drives. Compatibility: iSpreadsheet is compatible with all types of Excel and Apple Numbers files.

It also supports real-time document syncing with Google Sheets. Best Use Case: This app is best if you simply want to open, review, and make small edits to spreadsheets on a mobile device, or just use it for simple home budgeting and lists.

Calc XLS. It has no visualization features, but allows for intuitive cell formatting and row and column resizing to create functional sheets and lists. Mobility: It is mobile-only, and can save to DropBox to keep your phone and tablet storage freed up. Best Use Case: This app is best if you simply want to open, review, and make small edits to spreadsheets on-the-go, or just use it for simple home budgeting and lists.

How to Set Up a Sheet: It has a similar process to other spreadsheet apps. Citrix QuickEdit. About the Company: Citrix is a producer of primarily cloud and network solutions, so ease of uploading, editing, and access is their main focus for productivity apps.

Main Features: Citrix QuickEdit is a highly-compatible spreadsheet app, and can be saved with nearly every cloud drive solution on the market. It has an Excel-like formula editor, basic cell formatting options for readability, and over functions including string and logical varieties for complex calculations on the go. Mobility: It is mobile only, but you can also save files to DropBox to free up your phone and tablet storage.

About the Company: This software is designed for collaboration as part of the Free Software Foundation, and seeks to bring high quality software to the masses and maintain transparency.

Main Features: EtherCalc is a free, open source web app accessible on any platform with a browser that supports javascript.

It is clean and visually appealing, with the ability to quickly add and edit data with a number of handy contextual shortcuts. For example, if you select a cell, hold and left-click, and then move your mouse a little to the side, a circular menu appears with options to move or slide the cell, or fill an area with its value or function. The app can also create simple charts and forms, and supports instance-based commenting and simultaneous editing with multiple users.

Mobility: Theoretically, any browser can access it, but you cannot begin working on a sheet on one device and pick it up again on another. LibreOffice Calc. About the Company: LibreOffice is a maker of community-driven software for non-profits under open source licenses.

They provide their source code and only make money through donations. Main Features: LibreOffice Calc is a full-featured desktop spreadsheet app with tons of downloadable templates and in-app guides, so anyone from a novice to an expert can get the full range of use. Users can modify Schedule XL options to select explicit functionality for handling cell sizing, merging and borders.

Schedule XL can insert images into Revit schedules and drafting views if they exist in the source spreadsheet. SXL will extract the images from the spreadsheet to the same folder containing it. The images used will then be linked into Revit and placed in their corresponding locations. This capability requires that Microsoft Excel is installed on the system. If a Revit project contains previously created schedules with images and is opened on a system without Excel, the schedules will not be updated automatically.

Graphics Options are specific to each link. On the main window, click Add or double click an item in the list. Graphic options are useful to override the appearance of the schedule in Revit. The effect of each option varies depending upon the source worksheet and its settings or formats. Set Auto Merge adjacent cells to force multiple cells in a row to become one. Table Layout: SXL can optionally create multiple schedule tables as specified. These options are useful when working with many rows in a schedule that need to be split up to fit on sheets.

Combine with Column Headers option to repeat headers at the top of each table. Override Text Font: set this to force a single font or Revit text style to be used for all of the schedule text. The styles and widths of borders are limited to what Revit will allow ie.

Print Areas: check this option to force SXL to only use print areas in the spreadsheet for the schedule. Colors and Formatting: check the boxes next to these options to apply cell colors in the schedule. A schedule can get a custom name when adding only the active sheet from a workbook.

A schedule definition can be removed from the list by first selecting one or more items from the list, then either:. If a spreadsheet file is moved or renamed, when opening the project file where Auto Update was turned on, the following message will briefly appear:. When selecting this choice, a file browser dialog will appear which allow you to choose the location of the new file to associate with that definition. NOTE: Doing this for one item will repair the links for all items that had been pointing to the old file and reassign them to using the newly selected file.

If entire directories of spreadsheets have been relocated, use the Edit Paths… function to quickly re-map to the new location. In the "Find:" text box, type or browse to the portion of the original path which is no longer applicable.

In the "Replace:" text box, type or browse to the portion of the new path. The FBI compiles national crime statistics, including data on the types of weapons used in homicides. This data is in an Excel spreadsheet. Expanded Homicide Data Table 8 Download Excel. To import the file into a Google Docs spreadsheet, create a new spreadsheet and in the menu at the top click on:. Google Spreadsheet also allows you to import data from your Google Drive.

It may give you an option to replace existing data, or to create a new sheet. Choose the best option for your situation. This spreadsheet shows the number of murder victims in each year from to in five columns, with the columns labeled by year in cells B4 to F4. Below that the spreadsheet shows the weapon used in the murders in 18 rows of data, with the rows labeled by type of weapon in cells A5 which is the overall total for all weapons to A You can improve the display of the data in a spreadsheet by increasing or decreasing the width of a column or the height of a row.

Note for Excel: if you narrow the width of a column displaying a number too much, you will see a series of pound signs displayed in the cell:. You can also speed up the resizing of columns and avoid making them too narrow by moving your mouse cursor to the border separating two columns in the gray bar at the top and double-clicking on the border.

This will automatically resize the column to the left, making it just wide enough to fit the longest entry on any row in that column. To delete a row, hover your mouse cursor over a row number in the gray area to the left, in this case row Right click and in the pop-up menu select Delete row. Hover your mouse cursor over a column letter in the gray area at the top, right click and in the pop-up menu select Delete column you also can click on the tiny downward-pointing arrow to get this pop-up menu.

If you want to add a column or row, again hover your mouse cursor over the appropriate column or row in the gray area above or to the left, right click and in the pop-up menu select one of the Insert options. With a spreadsheet you can insert a formula that will instantly add, subtract, multiply or divide numbers in columns or rows. A formula then has a symbol for what kind of calculation you want to perform add, subtract, multiply, divide, etc. The symbols a spreadsheet uses for calculations are:.

In the spreadsheet for types of weapons used in murders that we downloaded from the FBI website, the spreadsheet already included the total number of homicides in which any kind of firearm was used each year from to Those numbers are in row 6. This would require totaling up for each year the column of numbers for the five weapon types in the spreadsheet:.

This tells the spreadsheet to add up the number of murders committed with handguns B7 , rifles B8 , shotguns B9 , other guns B10 , and firearms, type not stated B11 for the year If we now wanted to calculate the total number of gun related homicides for the other four years, we could repeat the process of typing an addition formula into each cell in the rest of row But a spreadsheet has a much faster way of accomplishing this — by letting you simply copy the formula to one or more of the other cells in the same row.

Pass your mouse cursor over the bottom right corner of cell B23 and notice your cursor changes from an arrow pointer to a thin crosshairs. Click on that crosshairs , hold down your mouse button and drag your mouse to the right over the rest of the cells in row Release your mouse button and the total number of homicides involving firearms for each year from to will appear in row The spreadsheet has calculated these totals for you by applying the formula you first typed in cell B23 to the rest of the cells in row You can double click on the cell to display the formula in the cell and then edit or retype it there.

To edit the formula you can click in the formula bar where the formula for this cell is displayed. Cells can display their data in many different ways. For example, you can format a cell to display data as currency, as a date, scientific notation, or several other formats. For example, in the case of currency format, the cell data could have several decimal places. But when formatting for currency, a dollar symbol will display and the cell will only show the hundredths place 2 decimal points , even if the actual data in the cell has is more exact and has more decimal points.

The way to understand what the actual data is in a cell is to look at the formula bar. This will sometimes show you the raw data. The cell format is generally used to make thing more human-readable. But sometimes this can be the cause of consternation, especially when using formulas. This could especially be tricky when using dates.

This next section will describe how to calculate a percent change between two numbers. A percent change is calculated by finding the difference between the two numbers, and comparing that difference by the first number. In our spreadsheet on murder weapons, we can calculate how much each weapon increased or decreased between to This formula tells the spreadsheet to find the difference of homicides by subtracting the total homicides in from After that, divides the results to the original value.

Note: The parentheses in this formula are also important to define the correct order of operations. The total number of homicides by all types of weapons declined by 9.

But to make it into a more human-readable format, we can change the data format of the cell to a percentage. Click on cell:. Pass your mouse over the bottom right corner of the cell until the cursor changes to thin crosshairs. Click and drag the mouse cursor down over the rest of the cells in the H column. Release your mouse button when you get to cell:. The percent changes for all the different types of weapons used in homicides will appear on your screen.

In the formula for percent change we used in the previous section, parentheses were included in the formula:. The parentheses in this formula are very important. These tell the spreadsheet to subtract the number of homicides in B5 from the number of homicides in F5 first , and then divide that amount by the number of homicides in B5. Finally it would subtract the result from F5, resulting in an incorrect number.