Create spreadsheet from data files

The following code example is the SpreadsheetML markup for the worksheet created by the sample code. You can find these classes in the DocumentFormat. Spreadsheet namespace. The following table lists the class names of the classes that correspond to the workbook , sheets , sheet , worksheet , and sheetData elements. This is shown in the sample code and generates the required SpreadsheetML markup. The CreateSpreadsheetWorkbook method shown here can be used to create a basic Excel document, a workbook with one sheet named "mySheet".

To call it in your program, you can use the following code example that creates a file named "Sheet2. Notice that the file name extension,. Workbook parameter in the call to the Create method. Skip to main content. Plus, with the Paint Bucket icon, you can customize the shading rather than choosing one from the dropdown menu.

These tools let you design the borders of each individual cell, and the entire table. You can choose thickness, color, and type of line dotted, straight, wavy, etc. Again, this only works for tables created in Word. Use these tools to select rows, and choose whether or not to show the gridlines. You can also open up the Properties window and edit various elements, table alignment, or how the borders and shading appear.

This is another home for the Draw Table and Erase table tools. Use these tools to drag your mouse and draw each cell and erase them, one side at a time. These are tools for deleting rows, columns, or entire tables. You can also do this by highlighting a cell, right-clicking, and selecting to delete these portions.

Insert rows or columns wherever you like in your table with these tools. Again, you can also access these tools by highlighting and right-clicking different parts of the table. These tools let you change the organization of your table. You can merge and unmerge cells, like in Excel.

This is a helpful feature for creating headers or spacing in your table. You can also split the table between any two rows. Adjust the height and width of rows and columns numerically, rather than using drag and drop.

Use these tools to select multiple rows or columns, and evenly distribute them across the page to make your table look clean and professional. The alignment tools help you specify how to align the contents of each cell top left, bottom right, center, etc. Sort works the same way, allowing you to select several rows in a column and use them to alphabetize the table. Convert to Text lets you select any number of cells and put them in text value without a table, separated by commas or spaces.

This can be helpful for editing contents in paragraph form later, or importing data into other applications. Finally, there are the functions. Calling cells in formulas is also somewhat more difficult in Word. If you have a single row table, then every cell will be row 1 - A1, B1, C1, etc. The other relevant item to spreadsheets that can be created in Word is the chart function.

In the Insert tab, click the insert Chart button to access this feature. Once you choose a style, it will open Excel so you can edit the chart data. The functionality works exactly the same as in the Excel tutorial above. However, once the chart is in Word, two new tabs in the Ribbon , in place of Table Design and Layout. They become Chart Design and Format.

Use these tools to add extra important elements to your chart, either individually with Add Chart Element , or all at once using the helpful presets with Quick Layout. Use these tools to adjust the style of your chart without changing its layout too much. You can adjust colors, drop shadows, background, and more.

Manipulate data in the chart with this set of tools. Select Data takes you back into your Excel session to choose data set you want represented in the chart. Edit Data in Excel allows you to change anything you like about the data in Excel. You can also go into Excel by double-clicking your chart.

When you return to Word, click Refresh Data to update your chart to reflect any changes made to the data in Excel. Change Chart Type allows you to switch from a pie chart to a line graph and so on, using the same set of data.

You can select the Plot Area where the graph is stored, the Chart Area where all the axis labels exist, or any other element. Use this to insert shapes into your chart, just like inserting any other object into Word.

Use these tools to color every element on your chart, which can include how you want to fill in lines, the text color, and more. These are all your style options for text in your charts that handle adding WordArt, a fill color, and more.

The positioning tools work similarly to positioning other objects in Word. You can make the text wrap around the chart with Wrap Text , and place it behind or in front of any other element on the page. Use these tools to numerically change the height and width of the entire chart. This opens the Format Pane , which has some of the same tools found in the Ribbon , but they are larger and easier for some to access.

When you open Word, this screen appears. The New tab on the left side lets you create a new document, Recent surfaces recently opened documents, Shared shows documents that other Word users have sent to you, and Open opens a file browser for selecting an existing document.

On the New tab, you can see a number of templates which you can use to jump straight into making different types of documents like resumes, blogs, and research papers. Once your document is created, save it by clicking the save icon shown above, and select a location to save it. This opens a file browser window, where you can select the Simple Budget spreadsheet you created earlier, for instance. Open it. Step 4: Resize Spreadsheet to Fit. A spreadsheet as large as the one we created is too large for a standard Word document at its normal size.

To shrink it, click once on the imported spreadsheet, and hold down the Shift key. While pressing Shift , select a corner of the spreadsheet and drag it towards the center of the object a few times. Feel free to add text below the spreadsheet, as well. However, all of your formulas and formatting will remain intact. You can still work with the rest of the document, typing words and inserting pictures around the spreadsheet. To edit the data, double-click the spreadsheet to open the spreadsheet in a new Excel window.

Here, you can edit any data. It updates in real-time, meaning that as soon as you make the change in Excel, the change will be reflected in Word. In this way, you can bring fully-functional spreadsheets straight into Word.

Note: When you double-click on an inserted object like an Excel workbook, you have access to the entire workbook, not just the first sheet which appears as an object in Word. The newer version of Word lets you simply copy and paste cells and other Excel elements from an Excel workbook into a Word document. In your Word document, right-click on your mouse and click Paste to paste your chart and your selected Excel worksheet content into your Word document, one at a time. Step 4: Format Your Data.

Charts in Word behave a lot like charts in Excel. When you single-click a chart to select it, it opens the Chart Design and Format tabs so you can manipulate information for example, the design and layout.

You can also hover over areas of this pie chart to surface additional information such as how many dollars the blue portion represents. A lot of the formatting as is kept intact, but you lose almost all the formulas. For example, notice the months in the header are no longer angled 45 degrees upward. If you click on the Formula button while keeping your cursor in any cell, the formula that cell contains should appear.

You can re-enter this formula, and it will insert the new sum, but it will treat the rest of the text inside this cell as just text, squeezing the new sum in with it.

The conclusion? Copying tables directly from Excel can be a quick way to get a visual table into Word. Charts, however, are fine to copy and paste into Word, as they are still editable in Excel with their full functionality. Step 2: Insert New Excel Elements. This time, open the Insert tab and go to Insert Object , then click either Microsoft Excel Chart to insert a chart, or Microsoft Excel Worksheet to insert a full worksheet.

Click OK. Either option will open Excel. The Microsoft Excel Worksheet will open a blank Excel sheet. You can enter whatever information you want into it, following the same process as you used in the Excel tutorial above. You cannot change anything about the data in Word, and will again have to double-click the object to open Excel to make edits. If you find you have extraneous cells, you can also double-click to open Excel, select the data you want, then right-click and select Copy.

Delete the original object. Charts will work as described in the previous section on copying Excel charts. Adding a chart will open an Excel file that has one sheet with the chart, and one with the data.

Once you save the chart in your Word document, the data will stay in Excel with only one sheet, and the chart will appear in the Word document. You can change the data in Excel at any time by double-clicking the chart, and changing the styling of the chart in Word. The other way to insert a chart into Word is to click the Insert tab, then click Chart , and select the type of chart and design you want.

Then, you will be taken to Excel to enter your data from scratch, which will update your chart in Word. Step 3: Change Alignment and Text Wrapping. First, shrink the size of the chart by clicking the corner of the object and moving it inward.

This action creates a more manageable size. To move your chart or table more freely, single-click on your table or chart, and click the Layout tab on the Ribbon. Select Wrap Text , and click Tight to drag-and-drop the object anywhere on the page. The final way to create spreadsheets in Word is to create a table from scratch.

Step 2: Insert a Table. Click the Insert tab, and click Insert Table to see a grid. You can hover over the small squares to create a table of any height and width. Step 3: Create Headers. Now we have a blank table with a set amount of cells. The cursor appears in the first cell of top row. Start typing to create column headers. Step 4: Enter the Data.

Enter your data for each day, consisting of your necessary tasks and the hours they require. Sometimes text might be longer than a cell, causing it to split into two lines. Change the width of the cells with longer content by grabbing the left or right edge of a cell, and dragging it as you see fit. Step 5: Apply Styles. To make the schedule visually appealing, apply quick styling presets to it. Click the Home tab.

Select your entire table, then choose a preset you like from the Ribbon. Since you have a heading row, make sure to choose a style that makes it visually distinct.

Now you have a simple, nicely-designed table you can use for day to day scheduling. To extend it and add more items to your to-do list, click a row and then right-click on your mouse and choose Insert: Rows Below. See a complete list of keyboard shortcuts in Microsoft Word. This section will cover all the basics for working with Google Sheets.

Google Sheets is a spreadsheet app that lives in the cloud, meaning you never have to download anything, and you can update Sheets from any computer or smartphone. Google Sheets is not quite as robust as Excel in terms of functionality. What Google Sheets does have, however, is quite good for basic users: real-time collaboration abilities. Sheets integrates with all other Google products, allowing you to insert Google Forms data automatically. Sheets you create will be saved to your Google Drive account, and you can quickly insert any images you have in Google Photos.

It is available in MS office as well as Office , from where a user can create a spreadsheet. Here MS office is an on-premise application where Office is based on the cloud. Start Your Free Excel Course. MS Excel uses this term to emphasize that a single workbook can contain multiple worksheets where each one can have its own data grid, chart, or graph.

Here are a few examples for creating different types of spreadsheets in excel with the key features of the created spreadsheets. Step 3: By default, Sheet1 will be created as a worksheet in the spreadsheet, and the name of the spreadsheet will be given as Book1 if you are opening it for the first time.

He has some product and each product sales in each quarter for the year Now he wants to show this budget to his client. Step 7: Now, in the next row, put one header for Grand Total and calculate each quarter total sales. No account yet? Create an account. Edit this Article. We use cookies to make wikiHow great. By using our site, you agree to our cookie policy.

Cookie Settings. Learn why people trust wikiHow. Download Article Explore this Article methods. Tips and Warnings. Related Articles. Article Summary. Method 1. Open Microsoft Access. It's the red app with an A. Doing so opens the Access template page. Access is designed for use with Excel and comes bundled with Excel in Microsoft Office Professional and is only available for Windows.

Click Blank database. This option is in the upper-left side of the window. If you want to use a different template for your Access database, select the template that you want instead.

Click Create when prompted. This option is in the bottom-right corner of the pop-up window. Your Access database will open. Click the External Data tab. It's in the menu bar at the top of the Access window. Click Saved Imports. You'll find this in the far-left side of the External Data toolbar. A drop-down menu will appear. Select File. It's in the drop-down menu. Selecting this option prompts a pop-out menu.

Click Excel. This option is in the pop-out menu. Clicking it prompts the import window to open. Click Browse. It's in the upper-right part of the window. Select an Excel spreadsheet. Go to the folder in which your Excel spreadsheet is located, then click the Excel spreadsheet which you want to open.