QGIS – Batch Export GeoPackage Attribute Table to CSV

attribute-tablecsvexportqgisqgis-3

I have a large quantity (200+) of GeoPackage files, and I want to export the attributes table of all of them to CSV's. Is there a way I can do that in the GUI or with a Plugin for QGIS 3.16.15?

Alternatively, is there a Python script I can use to export them? I'm not too comfortable with Python so would prefer a Plugin if it exists, but if not I can run the Python script & input the file path/destination folder.

Best Answer

To export all layers opened in QGIS i created this little Python script:

from qgis.core import *

#Put your folder where you want your CSV exported to here
 pathToFile = "C:/Path/To/Export/Folder/"
 layers = QgsProject.instance().mapLayers().values()
 for lyr in layers:
     newName = lyr.name() + ".csv"
     save_options = QgsVectorFileWriter.SaveVectorOptions()
     save_options.driverName = "CSV"
     save_options.fileEncoding = "UTF-8"
     transform_context = QgsProject.instance().transformContext()
     ret = QgsVectorFileWriter.writeAsVectorFormatV2(lyr, pathToFile + newName, transform_context,save_options)

Related Solutions

QGIS Export – How to Export Attribute Table to Excel from QGIS

QGIS v3.x

Right click on the layer in the Table of Contents (aka. legend or layer tree) and open the Save As... dialog.

Once there, click on the Format option list and choose MS Office Open XML spreadsheet [XLSX].

Note that you also have an option for Libre Office files: Open Document spreadsheet [ODS].

ORIGINAL ANSWER (no longer valid):

Install the XY Tools plugin by Richard Duivenvoorde.
Select a vector file from the ToC (that is, make it active).
Go to Vector->XY tools->Save attribute table as Excel file.

enter image description here

You would need the Python library xlw installed for doing so.

QGIS Batch Export – Exporting Multiple QGS Projects to Image or PDF

First try.

Thanks to PyQGIS, we can call the Maps Printer plugin's functions to achieve what you want! So, having such plugin installed, adjust your own settings in Your settings section of the following code snippet. Open a new QGIS project and run the code in the QGIS Python console.

from PyQt4.QtCore import QFileInfo

# Your settings
projectPaths = ['/path/to/project1.qgs','/path/to/project2.qgs']
folder = '/path/to/export_folder/'
extension = '.png' # Any extension supported by the plugin

# Some useful object instances that we need
mp = qgis.utils.plugins['MapsPrinter']
project = QgsProject.instance()

# Do the work!
for projectPath in projectPaths:
    iface.newProject() # Needed to reset composer manager
    project.read( QFileInfo( projectPath ) )
    for composer in iface.activeComposers():
        title = composer.composerWindow().windowTitle()
        mp.exportCompo( composer, folder, title, extension )

It'll take a while.

NOTES:

If composer names are repeated across projects, you'd need to differentiate their title (second to last line in the code), for example, by appending the project name. Otherwise files will be overwritten.
If you just need to export certain composers, you could filter them using their name. It would need an extra if clause in the inner for loop.

I just test this with a couple of projects. Give it a try, I hope it works for you.

EDIT:

I acknowledge a PyQGIS script is not very user-friendly, so I've created a Processing Script that a user can run from the Processing Toolbox with its own GUI:

You can install it using the QGIS Resource Sharing plugin and adding my repository:

URL: https://github.com/gacarrillor/QGIS-Resources.git

Or, you can download the script directly from here and use the Add script from file tool from the Toolbox.

Best Answer

Related Solutions

QGIS Export – How to Export Attribute Table to Excel from QGIS

QGIS Batch Export – Exporting Multiple QGS Projects to Image or PDF

Related Question