Yes. In QGIS, open the layer’s attribute table, select the rows you want, and use the table’s Copy selected rows to clipboard command; then paste into Excel with Ctrl+V on Windows. For a reusable spreadsheet with more predictable headers and formatting, export the layer as an XLSX file instead.
Two ways to move QGIS attributes into Excel
Copying from the attribute table is the quickest option for a small, one-time transfer. It sends selected attribute values through the system clipboard, which Excel can usually place into separate cells. This is convenient when you want to review a few records, make a quick chart, or pass a table to someone without creating another GIS file.
Exporting is generally better for a large table, a repeatable workflow, or a file you plan to share. QGIS can write attribute data to formats such as XLSX and CSV when the required format support is available. An exported file is saved on disk, so you can reopen it without repeating the selection and clipboard steps.
- Choose clipboard copy for quick, temporary transfer of selected rows.
- Choose XLSX export when you want an Excel workbook and need control over exported fields or selected features.
- Choose CSV export for a simple text file that can be opened by many spreadsheet and data tools.
Copy selected rows from the attribute table
- In the QGIS Layers panel, select the vector layer whose attributes you need.
- Open its attribute table, for example by right-clicking the layer and choosing Open Attribute Table.
- Select the records. Use the table’s Select all features control for the whole layer, or use the selection tools to choose particular records. If the layer is already filtered or some features are selected, check what the table is showing before copying.
- Choose Copy selected rows to clipboard from the attribute table toolbar. Depending on the QGIS version and platform, a copy command or Ctrl+C may also be available after selecting rows.
- Switch to Excel, select the destination cell, usually A1, and press Ctrl+V.
In Excel for Microsoft 365 on Windows, a pasted clipboard table normally fills adjacent cells, with the first copied field going into the selected cell. If everything appears in one column, use Excel’s Data > Text to Columns and choose the appropriate delimiter, or repeat the transfer using an exported XLSX or CSV file. On a Mac, use Command+C and Command+V in place of Ctrl+C and Ctrl+V where the application uses standard macOS shortcuts.
Clipboard contents can vary with QGIS version, operating system, and the copy command used. Before relying on a large paste, try a few records and inspect the result. In particular, verify whether the field names came across; if they did not, add a header row in Excel or export the table instead. Clipboard copying is an attribute transfer, not a guarantee that Excel will receive every aspect of the GIS layer.
Select the right records and fields first
Selection determines what is copied. If you only need a subset, select those features in the map or attribute table before invoking the copy command. To find records using a condition, use the attribute table’s filtering or selection tools, then verify the selected count and visible records. A filter that merely hides rows is not always the same thing as a feature selection, so do not assume that copying will include only what happens to be visible.
Similarly, think about which columns belong in the spreadsheet. Attribute tables often contain internal identifiers, long descriptions, coded values, or fields that are useful in GIS but distracting in a report. You can hide columns in the attribute table for easier viewing, but hiding a field should not be treated as proof it will be omitted from an export. For a deliberate field list, use the export dialog’s field selection controls and review the result afterward.
For example, a planning layer might have hundreds of parcel records and fields for a database key, zoning code, area, owner category, and notes. A quick clipboard paste is suitable for checking a handful of parcels. If a colleague needs a clean list of zoning code and area for every selected parcel, an export with only those fields is easier to explain and repeat.
Export an XLSX workbook from QGIS
To create an Excel file, right-click the layer in the Layers panel and choose Export > Save Features As. In the format list, select the Excel XLSX format if it is offered by your QGIS installation. Choose a filename ending in .xlsx and set the destination folder. The exact format label and options can differ across QGIS and GDAL builds.
Review the export dialog before clicking OK. Depending on the available options, you can choose which fields to write, select a coordinate reference system, and save only selected features. If the goal is an attribute-only workbook, choose a no-geometry option if the dialog provides one. Otherwise, confirm how the chosen driver will represent geometry and inspect the workbook after export rather than assuming it will be a plain attribute table.
- Set a clear output filename and location so the exported workbook is easy to find.
- Limit the fields to those the recipient needs, especially if the source has internal or sensitive attributes.
- Use the selected-features option when you intend to export a selection rather than the entire layer.
- Open the resulting workbook in Excel and check the column names, record count, and values before sharing it.
XLSX is usually the most straightforward choice when the recipient specifically asks for an Excel workbook. However, spreadsheet formats have practical limits: an Excel worksheet supports at most 1,048,576 rows and 16,384 columns. If the layer is larger than that, it cannot fit as one worksheet, and a database or GIS format is more appropriate than trying to force the whole dataset into Excel.
Use CSV when you need a portable plain-text table
CSV is a useful alternative when you need a lightweight, broadly supported table rather than an Excel workbook. In QGIS, use the same Export > Save Features As route and choose a CSV format. Set the filename, review the field and geometry options, and pay attention to the delimiter and text encoding if those settings are offered.
CSV files do not store workbook styling, multiple sheets, formulas, or Excel-specific cell formatting. They are plain text, and the way Excel opens them can depend on regional settings. For example, some systems expect commas between fields while others commonly use semicolons. If Excel puts a whole row into one column, import the file through Excel’s Data > From Text/CSV command and check the delimiter and encoding in the import preview.
Encoding matters when fields contain accented letters or other non-English characters. UTF-8 is a common choice, but check the imported result rather than assuming every program will interpret the file identically. CSV also does not reliably preserve GIS field types: a value such as a code beginning with zero may be interpreted by Excel as a number and lose that leading zero. If preserving spreadsheet-friendly text and formatting matters, XLSX is often safer, though you should still verify the output.
What is preserved, and what needs checking?
A copied or exported attribute table is not the same as a complete copy of a QGIS layer. Attributes are the values stored in its fields; geometry is the spatial shape or location of each feature. A normal attribute-table paste should not be relied on to transfer usable map geometry. If Excel users need coordinates, create or export explicit coordinate fields, such as X and Y values for point features, before making the spreadsheet. For lines and polygons, a pair of coordinates is not enough to represent the full geometry.
Also check how Excel interprets types. Excel may display long identifiers in scientific notation, remove leading zeros from codes, or treat date-like text as dates. These are interpretation changes in the spreadsheet, not necessarily changes to the source layer. If identifiers must remain exact, import the file and set the relevant columns to Text, or retain a separate unchanged source export. For numeric measurements, confirm decimal separators and units; a value copied correctly can still be misunderstood if its field name or units are unclear.
Field aliases can make QGIS tables easier to read, but aliases and stored field names are not always treated the same way by every export route. Inspect the column headings in Excel and rename them there if needed. Keep a copy of the original QGIS data and avoid editing the only source file while preparing a spreadsheet for delivery.
Common problems and practical fixes
- Excel pastes everything into one column: The clipboard text may not be split using the delimiter Excel expects. Try Text to Columns, or export to XLSX. For CSV, use the import preview to select the actual delimiter.
- Only a few rows appear: Check whether only a few features were selected, whether the table is filtered, and whether the copy command copies selected records rather than all records. Select the intended features explicitly and check the count.
- Column headings are missing: Clipboard copying may not include headings in the form you expect. Add them manually for a small paste, or use an export and verify the first row.
- Leading zeros disappear: Excel has interpreted a code as a number. Import the field as Text or preserve the code in a format and workflow that treats it as text.
- Special characters look wrong: For CSV, check the file encoding during export and import. Reopen through Excel’s text import route and inspect the preview before loading.
- The XLSX option is unavailable: Your QGIS installation may not expose the relevant driver. Try CSV, update or use a QGIS installation with XLSX support, or export to another supported format and convert it carefully.
Which method should you choose?
For a quick answer to a one-off question, clipboard copy is efficient: select the records, copy them, paste into Excel, and check the result. For a deliverable that another person will reuse, XLSX export offers a saved file and a more controlled field list. CSV is useful for interoperability and simple data exchange, provided the recipient understands that it is plain text and may need import settings.
Use QGIS export rather than Excel copy-and-paste when the record count is large, selection rules must be documented, or the output needs to be generated again later. If the recipient needs to map or analyze the actual geometry, send a GIS dataset as well as, or instead of, a spreadsheet. A spreadsheet is a convenient view of tabular attributes; it is not a replacement for the spatial source data.
Frequently Asked Questions
Can I copy the entire QGIS attribute table into Excel?
Yes. Open the attribute table, select all the intended features, copy the selected rows, and paste into Excel. For a very large layer, export to XLSX or CSV and check Excel’s worksheet row limit and the exported record count.
Does copying the table include the field names?
It may depend on the copy command and QGIS version, so check the pasted result. If the headers are absent or not the names you need, add a header row or use the export dialog and inspect the output headings.
Can I copy only selected features?
Yes. Select the features first, then use Copy selected rows to clipboard. When exporting with Save Features As, look for the option to save only selected features and confirm that it is enabled before exporting.
Can I export QGIS attributes directly to Excel?
Yes, if XLSX is available in the Save Features As format list. Right-click the layer, choose Export > Save Features As, choose the Excel format, set the output path, and review fields and geometry options before saving.
Why did Excel remove zeros from my QGIS codes?
Excel likely interpreted the values as numbers, and numeric values do not retain leading zeros. Import the column as text or use an appropriate text-preserving workflow, then compare a few values against QGIS to confirm they remain intact.
Related
- Excel Number Format Dropdown: What It Does and How to Use It
- Number Bullets in Excel: Add, Format, and Manage Lists
- Notepad to Excel Conversion: Steps and Common Fixes
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Change the Slide Ratio in PowerPointTo change a PowerPoint slide ratio in Microsoft 365 for Windows, open Design > Slide Size, choose Widescreen…
- Fill an Excel Column With Weekday Dates AutomaticallyTo fill an Excel column with weekdays, enter the first date, then enter =WORKDAY(A2,1) in the cell below…
- How to Make a Flowchart in PowerPointTo make a flowchart in PowerPoint, choose Insert > SmartArt > Process for a quick, mostly linear diagram,…
- Google Sheets GOOGLEFINANCE: Prices, History, and LimitsYes. Google Sheets can retrieve financial information with the GOOGLEFINANCE function: enter a ticker and, optionally, a data…
- Google Sheets Project Tracker: Setup and Best PracticesA Google Sheets project tracker is a shared spreadsheet for organizing tasks, owners, deadlines, priorities, and progress in…
- Extend a Page Break in Excel: Adjust Print LayoutTo extend a page break in Excel, open View > Page Break Preview, then drag the blue page…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.