To import an Excel spreadsheet into InDesign, choose File > Place, select the .xlsx or .xls file, tick Show Import Options, and click Open. Pick the sheet, cell range and table formatting, click OK, then click on the page to drop in the table.
A client sent the price list as an Excel file, and it has to go into an InDesign layout without retyping every cell. This covers InDesign on Windows and macOS, including keeping the table linked.
Get the Spreadsheet Ready Before You Place It
Adobe’s supported file formats list includes Excel XLSX and XLS files for Place, described as tables with basic formatting. Five minutes in Excel saves a lot of cleanup in InDesign:
- Keep one header row. A single row of column labels converts cleanly into a table header you can style later.
- Remove what the layout doesn’t need. Notes columns, scratch totals and blank spacer rows all come across as real cells.
- Check merged cells. Layouts with heavy merging may need fixing after import, so unmerge where you can and merge again in InDesign if the design calls for it.
- Name the range you want. If the sheet holds more than the price table, select those cells in Excel and give them a name with Formulas > Defined Names > Define Name. InDesign’s import options accept named ranges, so you can pick “PriceList” instead of typing A1:D40.
- Save the workbook. InDesign reads the saved file, so unsaved edits in an open Excel window won’t come across.
If the file came to you as .csv or from Google Sheets (where you can download the sheet as an Excel file), open it in Excel and save a copy as .xlsx first; CSV is not on Adobe’s list of Place formats. If you need one layout per row of a CSV (tags, cards or labels) rather than one table, InDesign’s Data Merge panel (Window > Utilities > Data Merge) reads comma-delimited (CSV) and tab-delimited (TXT) files directly, as Adobe’s data source files page explains. The tutorial on opening CSV files with Excel helps if Windows keeps sending them to another app.
Decide Whether the Table Should Stay Linked
Make this choice before you place the file, because it can’t be switched in the Place dialog. Adobe’s import text files page states that text files you place are embedded and not linked by default. An embedded table is a one-time copy: later edits to the Excel file never reach the layout.
If the client will send revised prices, turn on linking first:
- On Windows, choose Edit > Preferences > File Handling. On macOS, choose InDesign > Preferences > File Handling.
- Select Create Links When Placing Text and Spreadsheet Files.

- Click OK.
Where you change the preference matters. With a document open, the setting applies to that document. With all documents closed, it applies to new documents you create afterward.
Place the Excel File in Your Layout
- Open the InDesign document. To fill an existing text frame, select it with the Type tool or Selection tool first.
- Choose File > Place (Ctrl+D on Windows, Command+D on macOS).
- Select the Excel file and tick Show Import Options. Tick Replace Selected Item only if you want the table to replace the contents of the selected frame.

- Click Open. The Microsoft Excel Import Options dialog appears.
- Set the options described in the next section and click OK.
- If no frame was selected, the cursor shows a loaded text icon. Click on the page to create a frame at that spot, or click inside an existing frame to place the table there.
Long tables flow across threaded text frames. If a red plus sign appears in the frame’s out port, the table is overset: click the plus sign and then click inside the next frame or page to continue the table.
Choose the Right Excel Import Options
This dialog is where most of the control lives. Adobe’s import options reference describes each setting:
| Option | What it does | When to change it |
|---|---|---|
| Sheet | Picks the worksheet to import | The workbook has several tabs |
| View | Uses a custom view saved in Excel | The client set up a print view |
| Cell Range | Sets a range or a named range | You only need part of the sheet |
| Import Hidden Cells Not Saved in View | Brings in hidden rows and columns | Usually leave it off |
| Table | Formatted or unformatted table | See below |
| Table Style | Applies an InDesign table style to an unformatted table | You have a house table style |
| Cell Alignment | Sets text alignment in the cells | Prices should align right |
| Include Inline Graphics | Keeps images placed in cells | The sheet has product thumbnails |
| Number of Decimal Places to Include | Limits decimals in numbers | Prices show 2.4999 instead of 2.50 |
| Use Typographer’s Quotes | Converts straight quotes to curly ones | Product names include quote marks |

Formatted or unformatted? A formatted table tries to keep the fonts, fills and borders from Excel. That is handy for a quick proof, but the result rarely matches your document’s typography. An unformatted table brings in plain cells, which you style with your own table style. For a printed price list, unformatted plus a Table Style is usually the cleaner route. Depending on your version, you may also see a choice to import the cells as tab-separated text with no table at all, which suits running copy better than a grid.
InDesign tables don’t calculate, so expect the cell values rather than working formulas. Finish the math in Excel before you place the file.
Update or Repair the Link in the Links Panel
When linking is on, the spreadsheet shows in the Links panel (Window > Links) like a placed image. Adobe’s Links panel overview explains the status icons:
- No icon: the table matches the saved spreadsheet.
- Modified: the Excel file was edited and saved after you placed it.
- Missing: InDesign can’t find the file at its original path because it was moved, renamed, or is on a disconnected drive.
- Embedded: the content is stored in the document and can’t refresh from the source.

Warning: linked text is not updated automatically, and updating it replaces any edits you made to the table in InDesign, including formatting you applied by hand. Put your styling in table and cell styles so it can be reapplied in a click, or update before you fine-tune the design.
To bring in the client’s new prices, select the link with the Modified icon and click the Update Link button at the bottom of the panel. For a Missing link, select it, click Relink, and browse to the file’s new location; you can tick Search for Missing Links in This Folder to fix several at once. Adobe’s update, restore and replace links page also covers relinking to a different file, where Show Import Options lets you choose a new sheet or range.
Paste Cells Instead of Placing the File
For a short table you won’t need to update, copy the cells in Excel and paste them into InDesign. What arrives depends on Edit > Preferences > Clipboard Handling (InDesign > Preferences on macOS):
- Text Only pastes plain text, which you can then turn into a table (select the text with the Type tool and choose Table > Convert Text to Table).
- All Information pastes the cells as a table with some formatting.
Adobe’s create and import tables page recommends Place over pasting when you want to keep spreadsheet formatting or have more control. Pasting never creates a link. If you paste into an existing InDesign table, add rows or columns first with Table > Insert so the data has room.
Style the Imported Table
Once the table is on the page, select it with the Type tool and work from the Table menu and the Table and Cell Styles panels. Three changes do most of the work for a price list. First, select the top row and choose Table > Convert Rows > To Header so it repeats when the table flows to the next frame (Table > Table Options > Headers and Footers sets how often it repeats). Second, apply a table style for borders and alternating fills. Third, apply a cell style to the price column for right alignment and tabular figures.
Because a link update can wipe manual formatting, styles are what keep the table looking right through revision after revision.
If the same spreadsheet also feeds letters or labels, Word’s mail merge is the better tool for that job; see how to merge Excel data into Word documents.
Questions About Excel Tables in InDesign
Why didn’t my table change when I updated the spreadsheet?
Either the file was embedded (the default) or the link hasn’t been updated yet. Open the Links panel: if the spreadsheet isn’t listed, or shows the Embedded icon, turn on Create Links When Placing Text and Spreadsheet Files and place the file again. If it shows the Modified icon, click Update Link.
Can I place just one table from a busy worksheet?
Yes. Enter the range, such as A5:D30, in Cell Range in the import options, or pick a named range you created in Excel. A named range is easier to keep right when the client adds rows, as long as they extend the name too.
Can I edit the numbers directly in InDesign?
You can type in the cells like any InDesign table. For a linked file, though, the next Update Link overwrites those edits, so make content changes in Excel and only style in InDesign.
Why does a price show too many decimals?
Excel can store more decimals than the cell displays. Set Number of Decimal Places to Include in the import options, or round the values in Excel before placing.
Start with a test placement of the price list on a spare page, check the import options result, and then set up your table style before placing it in the final layout.

Matthew Burleigh is the founder, head writer, and editor of Solve Your Tech, which he launched in 2012. He has written technology tutorials since 2008 and worked in IT since 2003, including small-business support, IT management, and consulting. He holds Bachelor’s and Master’s degrees in Computer Science from Arizona State University.
Matthew writes practical guides for Windows, iPhone and iPad, Microsoft Office, Outlook, Google apps, and Android. Solve Your Tech’s guides are checked step by step against the device or app maker’s own documentation and tested on his own devices whenever he has the hardware or software, with clear steps, sources, and update dates.
Read more about Matthew and how Solve Your Tech writes and updates its guides, or report a correction.