I want to switch from excel to numbers, but am running into a problem. With excel you can reference cells from different workbooks but with numbers they all need to be in 1 spreadsheet (document). So, is there an easy way to import 2 excel workbooks in 1 numbers spreadsheet?
MacBook Pro 13″, macOS 12.4
Converting from Excel to Numbers will take some work.
While you are at it you might consider putting your data in a form that is more easily analyzed in spreadsheets.
Hard to analyze: Data that is spread across identical tables, one for each month.
Efficient to analyze: Like data that is kept together in one table.
So you could try copy-pasting your data from the various monthly Excel worksheets into one Numbers table. To that table add a month column and add the relevant month to each row of data.
That way you can easily extract monthly and other summaries via SUMIFS, COUNTIFS or, even easier, Filters and Pivot Tables that do not require formulas.
SG
Converting from Excel to Numbers will take some work.
While you are at it you might consider putting your data in a form that is more easily analyzed in spreadsheets.
Hard to analyze: Data that is spread across identical tables, one for each month.
Efficient to analyze: Like data that is kept together in one table.
So you could try copy-pasting your data from the various monthly Excel worksheets into one Numbers table. To that table add a month column and add the relevant month to each row of data.
That way you can easily extract monthly and other summaries via SUMIFS, COUNTIFS or, even easier, Filters and Pivot Tables that do not require formulas.
SG
Open the two documents in Numbers, then copy the sheet in the second and paste into the first
If you want all of those sheet in the same document, then you will have to move them one at a time. Perhaps could also use an AppleScript to programmatically move them.
So I think you would have to repeat the copy paste operation 13 time for one year.
Inefficient and error prone: creating a monthly report by putting each month’s data in a separate sheet., and then pulling together an annual summary from those separate monthly sheets.
Efficient, and much easier to set up and maintain: keeping like data together and creating a monthly report by extracting a summary from the data table using formulas or a Filter or Pivot Table. And using similar technique to extract a neat annual summary.
Recommend reconsidering, even if you decide to stick with Excel.
SG
Thanks, but we have to make a monthly report, thats why we have 1 sheet per month. The totals of each sheet/month are accumulated in the sheet 'Totaal 2022', which gives a neat overview of the results in that year. Seems that Numbers just isn't as versatile as Excel, which is a pity because we really want to move to Apple applications.
Sorry, that doesn't do the trick, because each workbook consists of a number of sheets, 1 for each month and 1 with totals. I'll add a screenshot of one of them.
Yes, and then do the same for the other workbooks of the other products. This doesn't seem very efficient....
Thanks SG, will do that.
combining 2 excel workbooks in 1 numbers spreadsheet
