How to Make a Spreadsheet on iPhone

PDF download Download Article
PDF download Download Article

Do you want to organize that data on a spreadsheet from your iPhone? Luckily, there are a number of free services that can help you, including built-in apps like Numbers. Read on to learn easy ways to make spreadsheets using Apple Numbers, Microsoft Excel, and Google Sheets on your iPhone.

Method 1
Method 1 of 3:

Using Numbers

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/89\/Make-a-Spreadsheet-on-iPhone-Step-1.jpg\/v4-460px-Make-a-Spreadsheet-on-iPhone-Step-1.jpg","bigUrl":"\/images\/thumb\/8\/89\/Make-a-Spreadsheet-on-iPhone-Step-1.jpg\/aid13092760-v4-728px-Make-a-Spreadsheet-on-iPhone-Step-1.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    This app looks like a bar chart on a green background. [1]
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d1\/Make-a-Spreadsheet-on-iPhone-Step-2.jpg\/v4-460px-Make-a-Spreadsheet-on-iPhone-Step-2.jpg","bigUrl":"\/images\/thumb\/d\/d1\/Make-a-Spreadsheet-on-iPhone-Step-2.jpg\/aid13092760-v4-728px-Make-a-Spreadsheet-on-iPhone-Step-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    You'll see this plus sign in the top right corner of your screen.
    • You'll see different templates for spreadsheets that you can use. Swipe across to see more in categories, or tap a category header to see more of that type of spreadsheet.
    Advertisement
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/6e\/Make-a-Spreadsheet-on-iPhone-Step-3.jpg\/v4-460px-Make-a-Spreadsheet-on-iPhone-Step-3.jpg","bigUrl":"\/images\/thumb\/6\/6e\/Make-a-Spreadsheet-on-iPhone-Step-3.jpg\/aid13092760-v4-728px-Make-a-Spreadsheet-on-iPhone-Step-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    You can also tap Blank if you don't want to use any of the templates displayed.
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/9a\/Make-a-Spreadsheet-on-iPhone-Step-4.jpg\/v4-460px-Make-a-Spreadsheet-on-iPhone-Step-4.jpg","bigUrl":"\/images\/thumb\/9\/9a\/Make-a-Spreadsheet-on-iPhone-Step-4.jpg\/aid13092760-v4-728px-Make-a-Spreadsheet-on-iPhone-Step-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    To do so, you can tap cells to replace the default placeholder content with your own. Add tables, text boxes, shapes, or objects by tapping + in the toolbar.
    • Pinch your fingers in or out to magnify or zoom out of your spreadsheet.
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/8a\/Make-a-Spreadsheet-on-iPhone-Step-5.jpg\/v4-460px-Make-a-Spreadsheet-on-iPhone-Step-5.jpg","bigUrl":"\/images\/thumb\/8\/8a\/Make-a-Spreadsheet-on-iPhone-Step-5.jpg\/aid13092760-v4-728px-Make-a-Spreadsheet-on-iPhone-Step-5.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":547,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    To do this, tap < or Spreadsheets in the top left corner of your screen.
    • Your data is saved automatically, so don't worry about losing anything. [2]
    • Share your work by tapping the profile icon in the top left corner of your screen, then continue to your sharing options.
    6. Advertisement
Method 2
Method 2 of 3:

Using Google Sheets

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/e8\/Make-a-Spreadsheet-on-iPhone-Step-6.jpg\/v4-460px-Make-a-Spreadsheet-on-iPhone-Step-6.jpg","bigUrl":"\/images\/thumb\/e\/e8\/Make-a-Spreadsheet-on-iPhone-Step-6.jpg\/aid13092760-v4-728px-Make-a-Spreadsheet-on-iPhone-Step-6.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    This app icon looks like a green sheet of paper with a grid on it.
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/18\/Make-a-Spreadsheet-on-iPhone-Step-7.jpg\/v4-460px-Make-a-Spreadsheet-on-iPhone-Step-7.jpg","bigUrl":"\/images\/thumb\/1\/18\/Make-a-Spreadsheet-on-iPhone-Step-7.jpg\/aid13092760-v4-728px-Make-a-Spreadsheet-on-iPhone-Step-7.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    It's in the lower right corner of your screen.
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/08\/Make-a-Spreadsheet-on-iPhone-Step-8.jpg\/v4-460px-Make-a-Spreadsheet-on-iPhone-Step-8.jpg","bigUrl":"\/images\/thumb\/0\/08\/Make-a-Spreadsheet-on-iPhone-Step-8.jpg\/aid13092760-v4-728px-Make-a-Spreadsheet-on-iPhone-Step-8.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    If you tap Template , you'll then need to tap a template to select it.
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a1\/Make-a-Spreadsheet-on-iPhone-Step-9.jpg\/v4-460px-Make-a-Spreadsheet-on-iPhone-Step-9.jpg","bigUrl":"\/images\/thumb\/a\/a1\/Make-a-Spreadsheet-on-iPhone-Step-9.jpg\/aid13092760-v4-728px-Make-a-Spreadsheet-on-iPhone-Step-9.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    To do so, you can tap cells to add your own data.
    • Add tables, links, comments, shapes, or images by tapping + in the toolbar if you have a cell selected.
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c3\/Make-a-Spreadsheet-on-iPhone-Step-10.jpg\/v4-460px-Make-a-Spreadsheet-on-iPhone-Step-10.jpg","bigUrl":"\/images\/thumb\/c\/c3\/Make-a-Spreadsheet-on-iPhone-Step-10.jpg\/aid13092760-v4-728px-Make-a-Spreadsheet-on-iPhone-Step-10.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    To do this, tap the checkmark icon in the top left corner of your screen. You can't have a cell selected to see this option.
    • Your data is saved automatically when you're online, so don't worry about losing anything. If you're offline, the changes are saved locally until Sheets can save the changes online in your Drive.
    • Share your work by tapping the three-dot menu icon in the top right corner of your screen, then tap Share & export , and continue to your sharing options. [3]
    6. Advertisement
Method 3
Method 3 of 3:

Using Microsoft Excel

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/68\/Make-a-Spreadsheet-on-iPhone-Step-11.jpg\/v4-460px-Make-a-Spreadsheet-on-iPhone-Step-11.jpg","bigUrl":"\/images\/thumb\/6\/68\/Make-a-Spreadsheet-on-iPhone-Step-11.jpg\/aid13092760-v4-728px-Make-a-Spreadsheet-on-iPhone-Step-11.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    This app icon looks like a green sheet of paper next to another sheet of paper with an X on it.
    • If this is your first time opening the app, you'll be prompted to sign in to your Microsoft account. You'll then be prompted to try a Microsoft 365 subscription for 30 days before paying. The app is free to use, but you'll be limited on the features and functions that Office has to offer.
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/ce\/Make-a-Spreadsheet-on-iPhone-Step-12.jpg\/v4-460px-Make-a-Spreadsheet-on-iPhone-Step-12.jpg","bigUrl":"\/images\/thumb\/c\/ce\/Make-a-Spreadsheet-on-iPhone-Step-12.jpg\/aid13092760-v4-728px-Make-a-Spreadsheet-on-iPhone-Step-12.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    It's in the upper right corner of your screen.
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/75\/Make-a-Spreadsheet-on-iPhone-Step-13.jpg\/v4-460px-Make-a-Spreadsheet-on-iPhone-Step-13.jpg","bigUrl":"\/images\/thumb\/7\/75\/Make-a-Spreadsheet-on-iPhone-Step-13.jpg\/aid13092760-v4-728px-Make-a-Spreadsheet-on-iPhone-Step-13.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    Drag your finger up and down to scroll through the menu, then tap the spreadsheet you want to use.
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/72\/Make-a-Spreadsheet-on-iPhone-Step-14.jpg\/v4-460px-Make-a-Spreadsheet-on-iPhone-Step-14.jpg","bigUrl":"\/images\/thumb\/7\/72\/Make-a-Spreadsheet-on-iPhone-Step-14.jpg\/aid13092760-v4-728px-Make-a-Spreadsheet-on-iPhone-Step-14.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    To do so, you can tap cells to add your own data.
    • Use the toolbar at the bottom of the screen to change how the text looks.
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/f9\/Make-a-Spreadsheet-on-iPhone-Step-15.jpg\/v4-460px-Make-a-Spreadsheet-on-iPhone-Step-15.jpg","bigUrl":"\/images\/thumb\/f\/f9\/Make-a-Spreadsheet-on-iPhone-Step-15.jpg\/aid13092760-v4-728px-Make-a-Spreadsheet-on-iPhone-Step-15.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    To do this, tap the back arrow in the top left corner of your screen. If you're working in a cell, tap the checkmark icon to close out of that.
    • Your data is saved automatically, so don't worry about losing anything. [4]
    6. Advertisement

Expert Q&A

Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Tips

      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Submit
      Thanks for submitting a tip for review!

      You Might Also Like

      4 Easy Ways to Add the Time and Date Automatically in Sheets
      How to Create an IF-THEN Formula in Excel: Basic Syntax, Multiple Conditions, & More
      The 3 Easiest Ways to Sort by Number in Google Sheets
      How to Make a Google Spreadsheet: Beginners Guide
      3 Easy Ways to Get Rid of Dotted Lines in Microsoft Excel
      How to
      Add the Same Value to Multiple Cells in Excel
      How to
      Add Rows to a Pivot Table
      How to Add Custom Calculated Fields to Pivot Tables in Excel
      Easily Embed Documents and Files in an Excel Spreadsheet
      How to Use Google Sheets: The Ultimate Guide for Getting Started
      How to
      Add Two Cells Containing the Sum of Other Formulas in Excel
      3 Simple Ways to Create a Shared Spreadsheet
      How to Change the X Axis Scale in an Excel Chart
      How to
      Add a Row to a Table in Excel
      Advertisement

      References

      1. ↑ https://support.apple.com/en-sg/guide/numbers-iphone/welcome/ios
      2. ↑ https://support.apple.com/en-sg/guide/numbers-iphone/tanc33201f3f/11.2/ios/1.0
      3. ↑ https://support.google.com/docs/answer/49114?co=GENIE.Platform%3DiOS&oco=1
      4. ↑ https://support.microsoft.com/en-us/office/excel-for-iphone-features-faac09c9-51af-4b3c-8c20-16c10145eff3

      About This Article

      Article Summary X

      1. Open Numbers.
      2. Tap the plus sign.
      3. Tap a spreadsheet template to open it.
      4. Customize your spreadsheet.
      5. Close the spreadsheet.

      Did this summary help you?
      Thanks to all authors for creating a page that has been read 15,135 times.

      Is this article up to date?

      Advertisement