You can convert and open spreadsheets in Numbers on iPhone, iPad, iPod touch, Mac, or online at iCloud.com.
Oct 08, 2019 You can open a file from the Finder or from the Numbers app: From the Finder, Control-click the file, then choose Open With Numbers. If Numbers is the only spreadsheet app on your Mac, you can just double-click the file. From the Numbers for Mac app, choose File. It depends on your level of proficiency with Excel, but Excel for Mac is just fine. I was a power user on PC and now am a power user on Mac. It took me just a few weeks to internalize it all. For basic operations like simple formulas, sorting.
Convert and open spreadsheets in Numbers on iPhone or iPad
You can work with a variety of file formats in Numbers on your iPhone or iPad. Check which formats are compatible with Numbers on iPhone and iPad.
Convert a Numbers spreadsheet in Numbers on iPhone or iPad
If you want to open a Numbers spreadsheet in another app like Microsoft Excel, use Numbers to convert the spreadsheet into the appropriate format.
- In Numbers, open the spreadsheet that you want to convert, then tap the More button .
- Tap Export.
- Choose a format for your spreadsheet. For example, if you want to open your Numbers spreadsheet in Microsoft Excel, choose Excel.
- Choose how you want to send your spreadsheet, like with Mail or Messages.
Open a file in Numbers on your iPhone or iPad
To open a file like a Microsoft Excel spreadsheet on your iPhone or iPad, tap the file in the spreadsheet manager. If you don’t see the spreadsheet manager, tap the Back button (on an iPhone or iPod touch) or Spreadsheets (on an iPad), then tap the file that you want to open. If a file is dimmed, it’s not in a compatible format.
You can also open a file in Numbers from a different app like the Files app, or from an email:
- Open the other app, then select the spreadsheet or attachment.
- Tap the Share button .
- Tap Copy to Numbers. The original file remains intact.
After the file opens, you might get a message that the file was last edited in an app other than the most recent version of Numbers. Tap Done to open the file in Numbers.
Convert and open spreadsheets in Numbers for Mac
You can work with a variety of file formats in Numbers for Mac. Check which formats are compatible with Numbers for Mac.
Convert a Numbers spreadsheet in Numbers for Mac
If you want to open a Numbers spreadsheet in another app like Microsoft Excel, use Numbers to convert the spreadsheet to an appropriate format.
- In Numbers, open the Numbers spreadsheet that you want to convert.
- Choose File > Export To, then select the format.
- In the window that appears, you can choose a different format or set up any additional options. For example, you can require a password to open an exported PDF, or choose the format for an exported Excel spreadsheet.
- Click Next.
- Enter a name for your file and select a folder to save it to.
- Click Export.
To send a file in a specific format through Mail, Messages, AirDrop, or Notes, choose Share > Send a Copy, choose how you want to send the spreadsheet, then choose a format.
Open a file in Numbers for Mac
You can open a file from the Finder or from the Numbers app:
- From the Finder, Control-click the file, then choose Open With > Numbers. If Numbers is the only spreadsheet app on your Mac, you can just double-click the file.
- From the Numbers for Mac app, choose File > Open, select the file, then click Open. If a file is dimmed, it’s not a compatible format.
When the file opens, you might get a message that the spreadsheet will look different. For example, Numbers notifies you when fonts are missing. You might see also see warnings when you open spreadsheets created in older versions of Numbers.
Convert and open spreadsheets in Numbers for iCloud
Numbers for iCloud lets you open, edit, and share your files from a supported browser on a Mac or PC. Check which formats are compatible with Numbers for iCloud.
Convert a Numbers spreadsheet in Numbers for iCloud
- Sign in to iCloud.com with your Apple ID.
- Click Numbers.
- In the spreadsheet manager, click the More button on the file you want to convert, then choose Download a Copy. If you have the spreadsheet open, click the Tools button in the toolbar, then choose Download a Copy.
- Choose a format for the spreadsheet. The file begins to download to your browser’s download location.
Open a file in Numbers for iCloud
- Sign in to iCloud.com with your Apple ID.
- Click Numbers.
- Drag the file you want to upload into the spreadsheet manager in your browser. Or click the Upload button , select the file, then click Choose.
- Double-click the file in the spreadsheet manager.
Check file format compatibility
Formats you can open in Numbers
You can open these file formats in Numbers on iPhone, iPad, Mac, and online at iCloud.com:
- All Numbers versions
- Microsoft Excel: Office Open XML (.xlsx) and Office 97 or later (.xls)
- Comma Separated Values (.csv)
- Tab-delimited or fixed-width text files
Formats you can convert Numbers spreadsheets into
Numbers on iPhone or iPad:
- Microsoft Excel Office Open XML (.xlsx)
- Comma Separated Values (.csv)
- Tab Separated Values (.tsv)
Numbers for Mac:
- Numbers ’09
- Microsoft Excel: Office Open XML (.xlsx) and Office 97 or later (.xls)
- Comma Separated Values (.csv)
- Tab Separated Values (.tsv)
Numbers for iCloud:
- Microsoft Excel Office Open XML (.xlsx)
- Comma Separated Values (.csv)
Learn more
- Numbers on iPhone, iPad, Mac, and online at iCloud.com use the same file format. If you create or edit a spreadsheet in Numbers on one platform, you can open it in Numbers on any of the other platforms.
- You can update to current versions of Numbers on your iPhone, iPad, or iPod touch from the App Store. To update Numbers for Mac, use the App Store app on your Mac.
- If you convert a Numbers spreadsheet into Numbers ’09-compatible spreadsheet, learn more about changes that happen when you export to iWork ’09.
Correctly copy and paste tables from the web into Excel | 14 comments | Create New Account
Click here to return to the 'Correctly copy and paste tables from the web into Excel' hint |
The following comments are owned by whoever posted them. This site is not responsible for what they say.
Correctly copy and paste tables from the web into Excel
Excel has a nice feature that can convert any data (not just web tables) in a single column to separate columns. Use: Data-->Text to columns....
You can then choose how the data is delimited and in a few clicks, you'll have your data in separate columns.
If you're a mainly Safari user such as myself, this method migh be faster than loading up another browser and doing the cut and paste again.
Note: I know this works with Excel v.X, but I don't know about older verisons.
You can then choose how the data is delimited and in a few clicks, you'll have your data in separate columns.
If you're a mainly Safari user such as myself, this method migh be faster than loading up another browser and doing the cut and paste again.
Note: I know this works with Excel v.X, but I don't know about older verisons.
Correctly copy and paste tables from the web into Excel
To make your life even easier, you can customize a toolbar to include that command as a feature.
If however, you do the same thing to the same page frequently, create a Query for it. Here is a basic web query:
WEB
1
http://www.cluelessmailers.org/index.html#blacklist
Selection=EntirePage
Formatting=All
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
replace the url with the url of the page you want the data from
save the block into a textfile of any name in /Applications/Microsoft Office X/Office/Queries, and it will be available in the saved external query area under the Data menu
this is an old query of mine, that used to return a list of blacklisted spam houses. it doesn't do that anymore.
I don't really know what the extra options are that you can pass to the web query engine, but i haven't needed them before.
If however, you do the same thing to the same page frequently, create a Query for it. Here is a basic web query:
WEB
1
http://www.cluelessmailers.org/index.html#blacklist
Selection=EntirePage
Formatting=All
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
replace the url with the url of the page you want the data from
save the block into a textfile of any name in /Applications/Microsoft Office X/Office/Queries, and it will be available in the saved external query area under the Data menu
this is an old query of mine, that used to return a list of blacklisted spam houses. it doesn't do that anymore.
I don't really know what the extra options are that you can pass to the web query engine, but i haven't needed them before.
took some diggin, but:
http://support.microsoft.com/default.aspx?scid=kb;en-us;178870
explains what all the lines should have on them, how to POST data in your query, and all other formatting options
http://support.microsoft.com/default.aspx?scid=kb;en-us;178870
explains what all the lines should have on them, how to POST data in your query, and all other formatting options
Correctly copy and paste tables from the web into Excel
I tried the suggestion using Firefox and still wound up having everything pasted into a single column. But I did find a solution.
Choose 'View Source' from within any browser. Select everything from the appropriate <table> tag all the matching </table> tag and past that into Excel. Bingo. Works from all the browsers I tried, even Safari.
Choose 'View Source' from within any browser. Select everything from the appropriate <table> tag all the matching </table> tag and past that into Excel. Bingo. Works from all the browsers I tried, even Safari.
Correctly copy and paste tables from the web into Excel
Thie method (viewing the source then copy/paste into Excel) is the method I've been using for quite a while. I'm pretty sure it's worked since Excel 2001 on OS 9. I use it all the time from any browser into Excel v.X.
Correctly copy and paste tables from the web into Excel
Thanks for this post. I was copying some stuff from my bank site the other day and ended up using the Windows PC because this was driving me nuts. I thought it was an Excel for Mac issue and not a browser issue.
Thanks again.
---
Tim
Thanks again.
---
Tim
Correctly copy and paste tables from the web into Excel
There's another way. I've always accomplished this by saving the page as .html. Open Excel and then do a 'File Open', open the .html file (you may have to change it so that you can 'View All Files.') The table will show up in the page, you'll probably want to delete out all the other junk, but this has always worked for me. Handy if Safari is your primary browser (although FireFox is coming on STRONG.)
Correctly copy and paste tables from the web into Excel
I want to figure out how to copy some cells from excel into mail.app without it pasting it as a graphic. WTF is up with that Microsoft?
Mac Automator Download
The thing happening is that in the copy process, WebKit adds RETURN or NEWLINE instead of TABs.
Excel expect TABS.
I do this in BBEdit, if needed:
1: Past in new window.
2: Find and replace all Double Returns 'rr' with '$r'
3: Find and replace all Single Returns 'r' with a TAB: 't'
4: Find and replace all $r with Returns: 'r'
Takes about 10 sec, and your done!
The trick here is that a line has Single Returns between cells, but double Returns at the 'end of line'.
Hope it helps...
---
/Marook
Excel expect TABS.
I do this in BBEdit, if needed:
1: Past in new window.
2: Find and replace all Double Returns 'rr' with '$r'
3: Find and replace all Single Returns 'r' with a TAB: 't'
4: Find and replace all $r with Returns: 'r'
Takes about 10 sec, and your done!
The trick here is that a line has Single Returns between cells, but double Returns at the 'end of line'.
Hope it helps...
---
/Marook
1: Past in new window.
2: Find and replace all Returns 'r' with a TAB: 't'
3: Find and replace all Double Tabs 'tt' with a Return: 'r'
sorry if i'm nitpicking
2: Find and replace all Returns 'r' with a TAB: 't'
3: Find and replace all Double Tabs 'tt' with a Return: 'r'
sorry if i'm nitpicking
Automator App Mac
I think that will cause problems if a cell is empty. You'll end up with split lines at the empty cell.
What Is The Automator App
first thanks for the hint tamc! i couldn't get the Data-->Text to columns....' method mentioned by EntropyGuru to work so i tried to prepare the copied data in Tex-Edit Plus.. by the time i was done i saw marook's method of preparing in BBEdit. i ‘ll post the Tex-Edit Plus way anyway since many use it and in Tex-Edit Plus you can make a script of it.. maybe in BB too.. open Script Editor and paste the below in a new window: and save this as script inside the Tex-Edit Plus scripts folder
hrmpf - too bad this method doesn't work when data inside a cell contains breaks or is (auto)wrapped by the cell-width.. chocky's method of pasting html-table-data works best, it's even more reliable than pasting from explorer, since explorer puts data separated by a break in another cell as well
Mac Automator Example
Saving the file as .html, opening with word and then dragging or pasting the table into excel works flawlessly. I just used this method for some tax related stuff this weekend.
If you own office it's a nice timesaver as no formatting is lost.
HTH
If you own office it's a nice timesaver as no formatting is lost.
HTH